Mysql configuration tweaks? [message #42199] |
Wed, 16 March 2011 22:43 |
brsox88
Messages: 2 Registered: March 2011 Location: Maine, US
|
Junior Member |
|
|
We have a cpanel vps user on our openvz linux based node. We have been batteling a situation with his vps for the past 2 months. It seems whenever he gets a lot of mysql query's the load on his vps goes up considerably. We have it set so he can use 100% of all 8 cores on the node and yet the load still goes up to around 30-90 on the node.
Is this bad coding on his site? Bad mysql config? We are lost. Below is his current mysql config:
[mysqld]
set-variable = max_connections=500
log-slow-queries
safe-show-database
#tmpdir = /tmpfs
query_cache_size = 8M
log_slow_queries=/var/log/mysql/mysqld.slow.log
|
|
|
|
|