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
3535
January 23, 2013 07:23PM
Re: Performance tuning - comparing two computers
1174
January 24, 2013 03:15AM
1006
January 24, 2013 09:27PM
1057
January 24, 2013 10:38PM
1075
January 25, 2013 07:59PM
909
January 25, 2013 08:36PM
1066
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.