Hi list, I think i've found a little bug in MySQL 4.0.15 (mysql-standard-4.0.15-pc-linux-i686.tar.gz)
Description : Here's my error log : Warning: thr_alarm queue is full Warning: thr_alarm queue is full [...] How To Repeat : Here's my conf file : [client] port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-innodb skip-name-resolve skip-host-cache skip-locking set-variable = max_connections=256 set-variable = table_cache=512 set-variable = key_buffer = 64M set-variable = max_allowed_packet = 1M set-variable = sort_buffer_size = 512K set-variable = net_buffer_length = 8K set-variable = myisam_sort_buffer_size = 8M Then use "SET" to modify some variables : set global max_connections=512; set global table_cache = 1024; And wait :) It seems that thr_alarm queue was allocated when server starts and not reallocated when modify some variables. How To Solve : Do not use "SET", modify my.cnf and restart the server instead. Hope this help. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
