MySQL Forums
Forum List  »  Performance

Re: slow overall perfomance
Posted by: Rick James
Date: May 21, 2011 08:46AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3089
N N
May 20, 2011 03:53AM
Re: slow overall perfomance
1138
May 21, 2011 08:46AM
1222
N N
May 23, 2011 03:07AM
1031
May 23, 2011 09:49AM
985
N N
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.