Re: Big load average Dell PowerEdge 6850 and MySQL 5.0.88-ius-log Distributed by The IUS Community Project
Posted by:
Rick James
Date: January 12, 2010 12:47AM
Does table1 have
INDEX(enable, datetime)
The load averages imply you are CPU-bound, not I/O bound?
Are you running MyISAM or InnoDB or both?
innodb_buffer_pool_size -- probably too low on either box.
key_buffer_size -- at one point you say InnoDB 'only', yet the default is MyISAM. What is the real case?
long_query_time = 10 -- shrink this to 2, then study the stuff that goes into the slow log. We can try to optimize those queries. This is not very useful:
log-queries-not-using-indexes
You have this set to both 24 and 16 in A102:
innodb_thread_concurrency
Do you use the query_cache effectively? If not turn it OFF.
innodb_log_file_size = 256M
innodb_log_files_in_group = 3
-- set on one machine, but not the other; what gives?
Subject
Views
Written By
Posted
4774
January 08, 2010 05:13PM
Re: Big load average Dell PowerEdge 6850 and MySQL 5.0.88-ius-log Distributed by The IUS Community Project
2053
January 12, 2010 12:47AM
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.