MySQL Forums
Forum List  »  Install & Repo

Mysql High Cpu Usage to 100%
Posted by: shahzaib cb
Date: October 29, 2013 06:13AM

Hello,

I am struggling with mysql configuration for last 4 days. Currently we're using server with 32G ram and there's no traffic as well as no active query in mysql processlist but mysql usage is constant on 100% and above. My site is loading way too slow due to this issue. I have also tried optimizing mysql configuration but in vain. As i am newbie to this field so there might be possibility that i am not configuring mysql variables properly. Following is the my.cnf settings and we're using myisam storage engine, i've also tried the solution regarding date -s but in vain too.

As there's no traffic on the server so there's no high I/o of Hdd.

mysql-version is 5.5

my.cnf

[mysqld]
innodb_file_per_table=1
key_buffer_size=128M
query_cache_size=50M
query_cache_limit=2M
query_cache_type=1
thread_cache=32
thread_cache_size=4
table_cache=8096
tmp_table_size=64M
max_heap_table_size=64M
read_buffer=1M
onnect_timeout=30
wait_timeout=300
interactive_timeout=30
performance_schema=off

Help would be highly appreciated.

Best Regards.
Shahzaib

Options: ReplyQuote


Subject
Written By
Posted
Mysql High Cpu Usage to 100%
October 29, 2013 06:13AM


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.