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 <query>' on both machines; the output should be the same.
4.0.1 isn't the latest, so I assume you're using something later. Regardless, I wouldn't expect the performance on the two machines to be so different unless the one has so much ram that everything is running from memory while the other has to thrash the disk. --Pete On Sun, Mar 21, 2004 at 11:05:49AM -0800, Gene H. Dreher wrote: > 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 don't expect the same, but close would > be nice.) > > thanks, ghd > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
