Mysql Experts ...need help please !!

Hello folks
i have a problem on my server ... i think mysql need optimization ....
my box :

3.2 HT processor
2 giga ram
cpanel

i hosted about 40 small databases ( forums ) and 5 mediam databses ...

most of time the server load reaches to 6 and 7 ...
when i restart mysql ...it going down to 0.75 and 1


MYSQL STATUS

Uptime: 87816 Threads: 42 Questions: 1692565 Slow queries: 706 Opens: 55938 Flush
tables: 1 Open tables: 512 Queries per second avg: 19.274


MY my.cnf file contents are :


[client]
#password =newpwd
port = 3306
socket = /var/lib/mysql/mysql.sock

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1000M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
safe-show-database
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
safe-updates

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Any advice please ?

Thanks in advance

 

 

 

 

Top