Hello,
I have some difficulties about mysql. I currently host about 100 sites and I only have 512mb of ram. Server load is normal, about ~0.5 - 1, BUT in some time the SQL server crashes with overload. I may happend about 3 times per day or sometimes it happend once in a week. My current conf is:
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
skip-innodb
key_buffer = 90M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M
query_cache_size = 32M
max_connections = 200
log-bin
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 2M
read_rnd_buffer_size = 768k
write_buffer = 2M
[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 2M
read_rnd_buffer_size = 768k
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
Any suggestions on that?
I have some difficulties about mysql. I currently host about 100 sites and I only have 512mb of ram. Server load is normal, about ~0.5 - 1, BUT in some time the SQL server crashes with overload. I may happend about 3 times per day or sometimes it happend once in a week. My current conf is:
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
skip-innodb
key_buffer = 90M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M
query_cache_size = 32M
max_connections = 200
log-bin
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 2M
read_rnd_buffer_size = 768k
write_buffer = 2M
[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 2M
read_rnd_buffer_size = 768k
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
Any suggestions on that?