dusanf

Active Member
Jul 22, 2009
25
2
53
cPanel Access Level
DataCenter Provider
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?


Code:
#[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
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
38
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
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:

Code:
/usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl
Also, you might want to review this presentation on optimizing MySQL:

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