Do a mysqldump -d on both machines to make sure the schema, and the
indexes in particular, are exactly the same. Run "analyze table" on
all tables. Make sure the MySQL conf files (e.g., /etc/my.cnf) are
the same. Do an 'explain ' on both machines; the output should
be the same.
4.0.1 isn't the
I've got 2 Redhat 8 machines with 4.0.1 (? latest) database. Machine1 is a P3-750,
Machine2 is a P4-1.6 .. The same database is deployed to both machines using myisam
tables. Query on Machine 1 takes almost 2 min to produce data. Same query on
Machine2 returns in 5 seconds... ? Why? (I do
