Re: Performance tuning - comparing two computers
Hi, Francis
Are you runnning the same version of MySQL on both computers?
Does EXPLAIN of the query give same output?
You could try to compare the output of "SHOW STATUS LIKE 'Handler%'". (Remember to do FLUSH STATUS before running the query). That will tell you if the number of accesses from MySQL server to InnoDB storage engine are the same in both cases.
Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway
Subject
Views
Written By
Posted
3547
January 23, 2013 07:23PM
Re: Performance tuning - comparing two computers
1187
January 24, 2013 03:15AM
1015
January 24, 2013 09:27PM
1064
January 24, 2013 10:38PM
1087
January 25, 2013 07:59PM
919
January 25, 2013 08:36PM
1071
January 26, 2013 12:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.