high cpu usage

nohie

my cpanel use high cpu for mysql i think this is the cause of high load this is my /etc/mycnf :


[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000

if u need any thing more tell me

Comments

2 comments

MilesWeb

January 04, 2015 10:13
]my cpanel use high cpu for mysql i think this is the cause of high load this is my /etc/mycnf :
[mysqld] default-storage-engine=MyISAM innodb_file_per_table=1 max_allowed_packet=268435456 open_files_limit=10000
if u need any thing more tell me

You will need to monitor the server resources. If top command shows MySQL consuming lot of resources, use the command below to investigate if there is any specific database which is consuming the resources. mysqladmin pr
0
cPanelMichael

January 06, 2015 12:34
Hello :) I suggest running a MySQL tuner to see what variables you should adjust in your /etc/my.cnf file. The following thread should help you get started: mysqlmymonlite.sh server stats gathering tool for cPanel Server Here is another thread that's useful if you need to troubleshoot a high load average: Troubleshooting High Loads On Linux Systems Thank you.
0

Please sign in to leave a comment.