Hi all, For a few month I was using mysql-3.23.39 without any problems but today the load went up to 25 and higher. I've tried some finetuning (like shorten timeouts to 5 minutes) and upgraded to mysql-3.23.46 but in vain. Still after a few minutes the load is back to 25 and this is the output of 'mysqladmin status':
Uptime: 778 Threads: 85 Questions: 14882 Slow queries: 209 Opens: 2838 Flush tables: 1 Open tables: 416 Queries per second avg: 19.129 Does someone has any clue? The developer of the website told me that he didn't start to use strange queries... Thanks in advance! Best regards, Jurrien Here is my my.cnf: [mysqld] port = 3306 socket = /var/run/mysqld/mysql.sock skip-locking set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = table_cache=256 set-variable = sort_buffer=1M #set-variable = record_buffer=1M set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=64M #set-variable = thread_cache=8 #set-variable = thread_concurrency=2 #set-variable = max_connections=500 set-variable = interactive_timeout=300 set-variable = wait_timeout=300 #log-bin server-id = 1 And this is how I compiled mysqld: ./configure --prefix=/usr/local --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/run/mysqld/mysql.sock --enable- assembler --with-mysqld-ldflags=-all-static --without-bench Some general details of the host: Debian potato stable release, Linux 2.4.9, 512 MB, SCSI harddrive, database is 50mb, Pentium3/1.0 Ghz, gcc version 2.95.2 20000220 (Debian GNU/Linux) --------------------------------------------------------------------- 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
