Troubleshooting poor mysql performance

I've been trying to maximize performance of retrieving certain data from one of my databases. In the course of doing this, I installed mySQL on two of my home PCs and noticed something very strange. Both of my home PCs, including a laptop with a slower processor and less memory, are executing queries on the same data faster than my server.

Can anyone provide some advice into troubleshooting this?

Server Details
Pentium 4 3.0 w/ HyperThreading
1GB RAM
MySQL 4.1.18 (installed from RHEL3 RPM)
CentOS 3.4

Home PCs
Athlon 64 3800+ / 1GB RAM / MySQL 4.1.18 Windows
Pentium 4 2.6 / 512MB RAM / MySQL 4.1.18 Windows

MySQL Configuration File
http://v3.w3counter.com/my.cnf.txt

Notes
There are two other websites on the server along with the one I'm testing on. I stopped the web server, to eliminate any outside queries, and ran queries from the mysql command line and still didn't see speeds as good as even the laptop with inferior hardware. Processor load is minimal (0.05 average).

I'm running a query that takes, on average, 2 seconds for my server, 0.58 seconds for my Athlon 64 desktop PC, and 1.5 seconds for my laptop PC, all on the same data.

Where do I start?

 

 

 

 

Top