High load - please check my.cnf

[dusanf]

Hi,

Im hosting a website with a lot of visitors (joomla, etc) and im having load over 60 on my vps with 4 gigs of ram and 4 gigs burst. Im using cpanel.

This is my.cnf, can anyone tell whats wrong?

#[mysqld]
#innodb_file_per_table=1

[mysqld]
datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
skip-locking
#skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=250
max_connections=5000
interactive_timeout=10
wait_timeout=10
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192 

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192 

#[mysqldump]
#quick
#max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M 

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

[Eric]

Howdy,

I'd ask that you open a ticket. There could be more going on than MySQL load.

Thanks!

[nibb]

Howdy,

I'd ask that you open a ticket. There could be more going on than MySQL load.

Thanks!

I was not aware cPanel did MySQL optimization. Is this included in standard support?

[cPanelTristan]

We can help with optimization on the forums. In the ticket system, we can check the system to see if a cPanel service is the issue. If it isn't, we can provide input on where to look further and then suggest the forums otherwise.

For determining what you might want to change for MySQL settings, please run the following after MySQL has been up at least 24 hours:

/usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl

Also, you might want to review this presentation on optimizing MySQL:

http://videos.cpanel.net/mysql-optimization/