Hello everyone
I'm having a little problem where my mysql 4.0.21 for some reason
stops "responding " until I do a flush-hosts. This is happening almost
every day.
It's a pretty heavy loaded server with at aprox 130 querys per second
(it might not be that loaded for some of you :) ).
I'm using the my-huge.cnf config, and allowing 350 max-connections.
Actually, here's the config:
[mysqld]
port = 4306
datadir = /usr/local/mysql-4/var
basedir = /usr/local/mysql-4
socket = /tmp/mysql-4.sock
skip-locking
set-variable = key_buffer=256M
set-variable = max_allowed_pac ket=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1 M
set-variable = myisam_sort_buf fer_size=64M
set-variable = thread_cache=8
set-variable = max_connections =666666
set-variable = max_user_connec tions=66666
# Try number of CPU's*2 for thread_concurre ncy
set-variable = thread_concurre ncy=8
log-bin
server-id = 1
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128 M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128 M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
If anyone knows what could be done to stop having to use the
flush-hosts every day, I'd appreciate the hint.
Thanks!
Lior
I'm having a little problem where my mysql 4.0.21 for some reason
stops "responding " until I do a flush-hosts. This is happening almost
every day.
It's a pretty heavy loaded server with at aprox 130 querys per second
(it might not be that loaded for some of you :) ).
I'm using the my-huge.cnf config, and allowing 350 max-connections.
Actually, here's the config:
[mysqld]
port = 4306
datadir = /usr/local/mysql-4/var
basedir = /usr/local/mysql-4
socket = /tmp/mysql-4.sock
skip-locking
set-variable = key_buffer=256M
set-variable = max_allowed_pac ket=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1 M
set-variable = myisam_sort_buf fer_size=64M
set-variable = thread_cache=8
set-variable = max_connections =666666
set-variable = max_user_connec tions=66666
# Try number of CPU's*2 for thread_concurre ncy
set-variable = thread_concurre ncy=8
log-bin
server-id = 1
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128 M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128 M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
If anyone knows what could be done to stop having to use the
flush-hosts every day, I'd appreciate the hint.
Thanks!
Lior