High load average on MySQL server. Why?
Recently we're experiencing serious performance problem on our Grails 2.2.1 application. Application server and database server are separate. At the database server end, load average getting higher in no time. CPU usage remain high too (around 200%).
load average: 16.91, 21.48, 30.91
At the application end we've manually closed the database connections wherever they have manually opened. my.cnf is also a bit configured using following parameters:
innodb_buffer_pool_size = 4G
query_cache_type = 1
wait_timeout = 1800
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 32
query_cache_limit = 5M
query_cache_size = 640M
query_cache_type = 1
But still there's no visible improvement. Server usage is still very high. What could possibly go wrong with configuration? How to keep server load average normal (or at least close to normal)?
Subject
Written By
Posted
High load average on MySQL server. Why?
August 29, 2016 12:17AM
September 01, 2016 10:23PM
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.