.
Kurt Duncan
> -Original Message-
> From: Duncan, Kurt (MCUSA) [mailto:k...@medconnectusa.com]
> Sent: Thursday, April 09, 2009 12:28 PM
> To: mysql@lists.mysql.com
> Subject: S L O W query over internet
>
> We are running a remote service and have an application t
arched the internet and
found several postings that this is normal but I can't believe anyone would
wait this long... does anyone have any ideas or can you point me in the right
direction?
Kurt Duncan
and running the same query and same database on a
2000 server 1 gig less memory runs the query in about 15 seconds with no
issues. Is this an issue with MySQL or the 2008 server?
Kurt Duncan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
speed on the VPN has tested fine. Does anyone have any ideas?
Kurt Duncan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ldn't work between SPARC & x86,
both running the same Solaris version, especially if they're both
running the same version of mySQL.
I would suggest doing a test copy, if possible to see what happens.
Kurt
--
MySQL General Mailing List
For list archives: http://lists.mysql.
hasn't been modified since June of
2005, so I may not have to migrate it to the new server anyhow. If it's
decided that we have to keep the database, I'll just tell the database
developers that they'll need to rename the table and modify their code
accordingly.
Thanks,
Kurt
-
to indicate that v5.0.x of mysql expects "repeat" to be
something special. If this is the case, then it would seem that we
would need to rename this table in order for the database to work with
mysql v5.0.24, no matter what method I use to transfer the data.
Am I on the right track
inue to blur. I
expect that each will continue to edge out the other in their current
respective fortes. This is, however, getting a little astray from the
original question.
Kurt.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
find posts complaining about the license change, not information
on the technical issues.
Kurt.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
bug? Are there some libraries I can install, where do I find them,
and where do I install them?
Or, are my only choices compiling my own (yuck) or using an RPM (bigger
yuck) on Fedore Core 2?
Thank you!
Take care,
Kurt Hansen
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: ht
Jesper Krogh wrote:
I gmane.comp.db.mysql.general, skrev Kurt Haegeman:
What is the optimal InnoDB datafile size? Is 75 * 2GB prefered over 1 *
1G:autoextend? The filesystem (ext3) has no problems handling the
filesizes, so that should not be an issue.
If your one large datafile suffers
e would be better without them
(smaller tables -> more speed).
Greetings,
Kurt Haegeman
Mediargus.be
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yahoo! Finance Tax Center - File online. File on time.
Absolutely. In an R&D environment, I created a table with more than 7
million newspaper articles. Didn't use load data local infile, though,
but a fairly simple Perl script.
Regards,
Kurt Haegeman
Mediargus.be
--
MySQL General Ma
hough.
Regards,
Kurt
y from the database (content-disposition
header).
Hi Kurt,
I have been using MySQL to store links to PDFs which live in other
directories.
Is there an advantage to storing the PDFs directly into the database?
-Erich-
Not all PDF's are viewable for all users. First it is determined wh
ion header).
Hope this helps.
Kurt Haegeman
Mediargus.com
Paul Rigor wrote:
Are you running a web server (or ftp server) as well? Because if you
are, then you can upload the files to a separate directory using perl
and just store the links to that file into a table in your database...
If you'r
a1.link
INNER JOIN p1a on p1a.link = a1.link
INNER JOIN mtg on mtg.link = a1.link
INNER JOIN state on state.state_code = a2.state_code
WHERE
state.state = 'FL'
AND h2.homeowner_probability_model <= '020'
AND p1a.first is not null
AND p1a.last is not null
AND
Hi,
Sergei Golubchik wrote:
Hi!
On Jan 13, Kurt Haegeman wrote:
Hi,
When trying to create a fulltext index on my large table, I get the
following error:
ERROR 1034 (HY000): 121 when fixing table
Sorry, I still cannot repeat this :(
Could you try to create a smaller test case ?
I
Hi Eli,
Eli Hen wrote:
"Kurt Haegeman" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Sergei Golubchik wrote:
Hi!
On Jan 13, Kurt Haegeman wrote:
Hi,
When trying to create a fulltext index on my large table, I get the
following error:
ERROR 1034 (
Sergei Golubchik wrote:
Hi!
On Jan 13, Kurt Haegeman wrote:
Hi,
When trying to create a fulltext index on my large table, I get the
following error:
ERROR 1034 (HY000): 121 when fixing table
I'm using version 4.1.1-alpha of the MySQL database, a source-compiled
version with the -
ase is using a cnf based on my-huge.cnf.
Somebody knows where to start looking?
Thanks in advance,
Kurt.
I have just installed MySQL 4.0 (from Marc Liyanage at www.entropy.ch) on my
Mac. The mysql process is running. However, when ever I try mysql or
mysql 'options' I receive this error:
dyld: mysql Undefined symbols:
mysql undefined reference to _BC expected to be defined in
/usr/lib/libSystem.B
; to differentiate it from the mysql executable.
Another option might be to try ./mysqladmin -u root -ppassword create databasename,
but since I didn't do it that way, I can't vouch for whether it works. Give it a try
and let me know; I'm curious.
Good luck,
-Kurt
--
I haven'
ce I did that, I left off the '-p' when initially setting the password and am now in
business.
Many thanks,
-Kurt
--
I haven't failed, I've found 10,000 ways that don't work.
-- Benjamin Franklin
-
Before
t the root user password for the first time.
Thanks for any ideas,
-Kurt
--
I haven't failed, I've found 10,000 ways that don't work.
-- Benjamin Franklin
-
Before posting, please check:
http://www.mysq
ffice products have Avery Wizards.
Thanks in advance for any help.
Kurt Giessler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Sorry--found the info:
http://www.latencyzero.com/macosx/mysql.html
http://www.entropy.ch/software/macosx/mysql/
-Kurt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
rt this due to the existence of the NetInfo system.
* Turning to the "manual.html" included in the MacOS X build, only Linux and Windows
are mentioned.
Can anyone who has successfully installed MySQL under MacOS X tell me how they did so??
Thanks,
-Kurt
--
I haven't failed, I
m), so the manual install instructions are unusable from step #1 as well.
Thanks,
-Kurt
--
I haven't failed, I've found 10,000 ways that don't work.
-- Benjamin Franklin
-
Before posting, please check:
http:
keeps track of a group of judges scores for something.
20 judges...3 rounds...17 categories...1020 single digit entries.
Thanks,
Kurt
-
Before posting, please check:
http://www.mysql.com/manual.php (the
column that should be "judges score
id" and have it link to a table that corresponds "judges score id" to "judges score"?
That would create a table that would look like this:
1 1
2 2
3 3
and so on. I would be replacing an int with an int.
What
ut this:
http://www.mysql.com/doc/U/s/User_Account_Management.html
HTH,
Kurt Hansen
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the lis
SQL_Database_Adm
inistration.html#User_Account_Management
You have a second problem: why isn't phpMyAdmin using 'dbuser' and 'mysql'?
I have no experience with php so I'm sorry I can't help you there.
Best of luck,
Kurt Hansen
[EMAIL PROTECTED]
http://www.ch
ew minutes.
Any ideas why it would be taking so long? This is on a RH 6.0 system.
Thank you!
Kurt Hansen
[EMAIL PROTECTED]
> > Subject: ERROR 2013: Lost connection to MySQL server during query
> >
> >
> > Hello,
> >
> > I'm getting the error message above when
Hi Milos,
Thanks for responding!
I had updated the /etc/hosts files already, but went and checked it after
getting your message. Still no luck.
Any other troubleshooting clues?
Thanks!
Kurt Hansen
[EMAIL PROTECTED]
- Original Message -
From: Milos Rackov <[EMAIL PROTECTED]>
To
.
MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2.
The mysqld variables are set to their default except for max_allowed_packet,
which has been increased to 10048512 on the 3.22.21 system in a vain attempt
to solve the
ets a lock on table 2.
Then they result in deadlock trying to get a lock on the other table.
could this ever happen using the lock tables command in MySQL?
>From: Gerald Clark <[EMAIL PROTECTED]>
>To: Kurt Washington <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject:
I am curious if any knows of possible deadlock
conditions that can ocurr when using the lock tables command in MySQL when
you are referenceing multiple tables?
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
38 matches
Mail list logo
