Hello,
I'm a database administrator for a hosting provider, and we have currently 2 SMP
MySQL-database servers. The one that is causing me problems, has at least 900
databases running on it. That's an dual PIII-550, with 1024MB memory, running RedHat
6.2, with Linux 2.4.5-ac4.
During working hours, a load of > 5 < 6 is pretty default, with about 600 mysqld
processes. This is already reduced from 900 to 600, by setting the wait-timeout to 600
seconds, to 120, to 30 at the moment. The problem is that the server is in an unstable
situation lately. I see a lot of MySQL-processes with top (sorted by MEM-usage), that
are taking over 90% CPU. If I strace -p <PID> the process, it returns me nothing. I
assume this is a sleeping process. RSS sometimes is 120M, most of the time between 20
and 40M.
No change in running 3.22.32, 3.23.31 - 3.23.38 (.38 currently).
Anyone has a hint on what happens ? SHOW PROCESSLIST gives me for 90% Sleeping as
output.
Here is (partially) my /etc/my.cnf :
skip-locking
set-variable = key_buffer=384M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
set-variable = thread_concurrency=4
set-variable = myisam_sort_buffer_size=64M
set-variable = max_connections=1250
set-variable = max_connect_errors=999999999
set-variable = wait_timeout=30
--
Met vriendelijke groet/With kind regards,
Cable & Wireless http://www.widexs.nl
Wouter de Jong System-Administrator
Tel +31 23 5698070 Fax +31 23 5698099
Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL
---------------------------------------------------------------------
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