Re: slow overall perfomance
The slowlog threshold is long_query_time, which defaults to a too-high value. Set that to 1 (second).
Well, let's double check some other things...
How much RAM in each machine?
How many CPUs? cores?
Is hyperthreading on or off?
What were your tests like? Real-life? Or Benchmarks?
What was the CPU usage (or "load average") during the tests?
How much disk activity?
sync_binlog? Or was the binlog turned off?
Which version of the Plugin did you use?
(No, I don't know what I am looking for; just hoping something will jump out.)
These all seem too high (until 5.5):
innodb_io_capacity=500
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_open_files=4000
Subject
Views
Written By
Posted
3458
May 20, 2011 03:53AM
Re: slow overall perfomance
1260
May 21, 2011 08:46AM
1392
May 23, 2011 03:07AM
1156
May 23, 2011 09:49AM
1114
August 08, 2011 09:58AM
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.