MySQL down every few hours, in log every time same errors, please help...

x-man

Well-Known Member
Jan 25, 2004
118
0
166
Hi,
in last few days my MySQL stoping to work and WHM starting again every few hours and I can`t find what is problem!
Every time MySQL stoping to work after toooo much errors like this:

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529489 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529488 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529486 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529485 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529484 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529472 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529466 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529465 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529460 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529459 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529454 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529453 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529450 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529446 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529444 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529441 user: ''

060601 7:11:47 /usr/sbin/mysqld: Forcing close of thread 529437 user: ''

this killing MySQL, after restart again all working fine few hours (without errors like this) but after few hours again errors like this and again MySQL restart...somebody know why???

This is on server with:
mysql (4.0.27-standard)
WHM 10.8.0 cPanel 10.8.1-S114
RedHat Enterprise 4

I must tell that ./mysqlup --force and ./upcp don`t helping to me!!!!

What now? This is very very big problem for me because this MySQL server must be stable...

Thanks.
 

mOdY

Well-Known Member
Dec 25, 2004
80
0
156
can you cat here your my.cnf? would be much easy to help you through
 

x-man

Well-Known Member
Jan 25, 2004
118
0
166
OK, here is my.cnf but I must tell that all worked fine in past with this my.cnf:

[mysqld]
set-variable = max_connections=1000
safe-show-database
skip-innodb
key_buffer = 150M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 80
wait_timeout = 30
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 16M
max_connect_errors = 10000
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M