Just thought I would explain my stupidity!
One of my tables which I'd forgotten about was 100k entries but I'd dropped
the primary key off earlier. Adding the primary key back again made the two
machines the same speed immediately.
Its amazing what indexes can do!
David
>
>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,0=
>00) =
>
>SELECT, INSERT, UPDATE, DELETE on single HEAP tables. The machine I deve=
>loped =
>
>it on was a P3 800 256MB Linux machine running MySQL 3.22.32 (standard ve=
>rsion =
>
>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 f=
>ound =
>
>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 th=
>e =
>
>same binary between both, and compiling on the host machine - no improvem=
>ent). =
>
> 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 whe=
>re 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
>
>
--
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
