mysql crashes or restart every 500 seconds

[alexd]

Hi:

I see in the .err log of mysql this:

041111 22:22:45  mysqld started
041111 22:22:45 Warning: Asked for 196608 thread stack, but got 126976
/usr/sbin/mysqld: ready for connections.
Version: '4.0.22-standard-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Official MySQL RPM
041111 22:31:07 /usr/sbin/mysqld: Normal shutdown

041111 22:31:08 /usr/sbin/mysqld: Shutdown Complete

041111 22:31:08  mysqld ended

041111 22:31:09  mysqld started
041111 22:31:09 Warning: Asked for 196608 thread stack, but got 126976
/usr/sbin/mysqld: ready for connections.
Version: '4.0.22-standard-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Official MySQL RPM
041111 22:39:37 /usr/sbin/mysqld: Normal shutdown

041111 22:39:38 /usr/sbin/mysqld: Shutdown Complete

041111 22:39:38  mysqld ended

041111 22:39:39  mysqld started
041111 22:39:39 Warning: Asked for 196608 thread stack, but got 126976
/usr/sbin/mysqld: ready for connections.
Version: '4.0.22-standard-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Official MySQL RPM
041111 22:40:46 /usr/sbin/mysqld: Normal shutdown

041111 22:40:47 /usr/sbin/mysqld: Shutdown Complete

041111 22:40:47  mysqld ended

041111 22:40:48  mysqld started
041111 22:40:48 Warning: Asked for 196608 thread stack, but got 126976
/usr/sbin/mysqld: ready for connections.
Version: '4.0.22-standard-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Official MySQL RPM
041111 22:48:01 /usr/sbin/mysqld: Normal shutdown

041111 22:48:02 /usr/sbin/mysqld: Shutdown Complete

041111 22:48:02  mysqld ended

041111 22:48:04  mysqld started
041111 22:48:04 Warning: Asked for 196608 thread stack, but got 126976
/usr/sbin/mysqld: ready for connections.
Version: '4.0.22-standard-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Official MySQL RPM

It's every 500 seconds... but i don't have ANY 500 number in the my.cnf...
Here it is...

[mysqld]
skip-innodb
innodb_data_file_path = ibdata1:10M:autoextend:max:1900M
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=50
innodb_buffer_pool_size=200M
innodb_additional_mem_pool_size=50M

connect_timeout=100
interactive_timeout=100
join_buffer=1M
key_buffer = 384M
key_buffer=16M
log-bin
max_allowed_packet=16M
max_connect_errors=10
max_connections=1000
myisam_sort_buffer_size=64M
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
read_buffer_size=2M
record_buffer=1M
safe-show-database
server-id=1
skip-locking
socket=/var/lib/mysql/mysql.sock
sort_buffer_size=2M
table_cache=1024
thread_cache = 8
thread_cache_size=128
thread_concurrency = 4
thread_stack=192k
wait_timeout=100

[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

So... what can it be ?

By the way... it's amazing, but althought I have the skip-innodb variable... the innodb is still working :P

 

[alexd]

I have upgraded to last current version (4.0.22) and still doing the same...
any ideas?

 

[cPanelNick]

My guess would be that chkservd is restarting it because it can't connect. Check /var/log/chkservd.log for the reason.

 

[alexd]

Your guess comes true
thank you

 

[SACHIN]

mysql restarted every 120 sec.

hello.

we are getting same error we have checkd /var/log/chkservd.log but no luck..
how to fix????