Hi, I hope that someone can help me on this matter.
I have a C program which uses MySQL. This program does many many (>100,000)
SELECT, INSERT, UPDATE, DELETE on single HEAP tables. The machine I developed
it on was a P3 800 256MB Linux machine running MySQL 3.22.32 (standard version
of MySQL for Woody version of Debian I think). It happily ran my program in
about 20 minutes.
I then moved it over to the production machine which would be running it (P3
733 256MB RAM SCSI mirrored disks) which is running MySQL 3.23.35 and I found
something very confusing. On this machine it takes about 3 hours to run.
The binarys for my program are identical on both machines (tried using the
same binary between both, and compiling on the host machine - no improvement).
The only difference we can seem to trace it to is the MySQL server.
Can anyone think of a reason why it would be running slower on 3.23 than 3.22?
Most of my SELECTs are either using a WHERE <primary_key> or have no where at
all (ie. selecting everything in the table - usually < 2000 rows).
We've even tried re-compiling MySQL with -O3 for gcc, but that made no
difference. We're connecting via a local socket (not TCP/IP). All the
variable sizes for MySQL seem to be the same between the two machines.
Hope someone can help.
Thanks
David Hearn
--
David Hearn
Trainee Engineer, Unix Development
XO Communications
Desk: 0208 957 1054 Mobile: 07974 423449
Fax: 0208 213 1880 Email: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php