Wouter de Jong writes:
> 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
Hi!
This is most probably mutex contention problem. Please use our binary,
or patch your LinuxThreads with a patch on our site.
--
Regards,
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
