Hello list, since I've upgraded to 4.0.4 I'm experiencing serious problems. When mysql starts up, everything is fine (~50 req/sec, ~10 threads) and the system load is about 1.0.
After a while, the number of threads rises up to 60-80 and the CPU load increases up to similar values. The response is incredibly slow and I have to restart mysql. "show processlist" doesn't show anything supspicious. With 3.23.53a everything works fine. Here is my my.cnf: [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable = long_query_time=20 set-variable = key_buffer=384M set-variable = max_allowed_packet=1M set-variable = table_cache=3000 set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=64 set-variable = thread_concurrency=4 set-variable = myisam_sort_buffer_size=64M set-variable = max_connections=1400 set-variable = max_connect_errors=10000 set-variable = tmp_table_size=64M The machine is a dual P-III 1000 with 1GB RAM I also noticed that some entries in the slow queries logfile are corrupted. The shows up some binary trash. This only happens with 4.0.4 also. Any hints are welcome Stefan rp-online.de --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
