I built a "test" box out of an old junker PC, 200 mhz processor, old board, and an old 4G hard drive, with 98 MB RAM
I just moved the "test" application to the live box... a 600mhz, new, fast board, and a new, fast 80 GB drive, 8MB buffer, ect, plus 128 RAM
On the new box, I see that select queries are taking a very long time. I have run the following test as a query from the mysql command line:
SELECT BENCHMARK(10000000,1+1);
On the old box, the result comes back in about .65 seconds. On the new box, the result comes back in about 7 seconds.
I see the same thing doing a query from one of my larger tables. The DB on the new box is an exact copy of the one from the old box. On the old box, I get this result in about 3 seconds, but it's more like 30 seconds on the new box.
Both boxes are installed with mySQL 3.23.52. Both boxes were fresh installed from the RedHat 8.0 cd's. I have looked at all the variables and parameter files for each box, and they are identical in every way.
I have also verified that all indexes are still present on both tables and so on. I've been at this all day, and I can't find a single place that mysql is configured different in any way on the two boxes.
I have also checked various memory items with 'top' and other commands, and both boxes are putting out about the same stats for mysqld.
Why are my selects on the new box running so much slower? This is a much faster box, so I should see comperable speed.
Any ideas I can check?
