On Tue, May 31, 2005 at 12:39:25PM +1200, Simon wrote: > Hi There, I have a strange issue with mysql performance... We are running sarge > on our production web server and woody on our dev server... MySQL is the only > issue we have: > > Both servers are running MySQL 4.0.24, one Debian_4 (woody) and one Debian_5 > (sarge)... Both my.cnf files are pretty much the same, both servers are 1.5Mhz > single processor AMD with 512MB RAM, both running software RAID 1 (2 disks) > where the mysql data is stored.... > > We have a database with about 900,000 records in it... serial numbers for > products... Looking up the woody box: > > select * from serial_numbers where serial_number is 'XXXXXXXXXXXXXX'; > > works (pretty much) instantly, where as the sarge box takes about 3 seconds. > > How do i start figuing out this issue? > Step 1. Switch to Postgres. -Roberto -- Roberto C. Sanchez http://familiasanchez.net/~sanchezr
Attachment:
pgpvOB81MhjGt.pgp
Description: PGP signature