high load avg

hmarei

New member
Joined
Aug 29, 2009
Messages
1
I have a vps with 3gb ram + Directadmin , and now vps load avg is 30 or 40 !
and i edited /etc/my.cnf with :
[mysqld]
local-infile=0
skip-locking
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
max_user_connections=200
interactive_timeout=10
wait_timeout=100
connect_timeout=10
thread_cache_size=20
key_buffer=64M
read_rnd_buffer_size=1M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=1M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
server-id=1

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[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

can you help me for new mysql config ?
Please help me !
 
Hi,

How can anybody help you? You did not provide any information so we can see what might cause high load.

How about pasting top command so we can check what is problem. Do this when your server load i high

Danijel,
 
Back
Top