On Sun, Jun 10, 2001 at 01:15:38PM +0300, Sinisa Milivojevic wrote:
> > 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
> >
> >
> Hi!
>
> This is most probably mutex contention problem. Please use our binary,
> or patch your LinuxThreads with a patch on our site.
Hmm, I patched glibc 2.1.3 with the patch on your site, then recompiled MySQL. No
change, still huge processes. :< I then tried the binary version, that didn't help
too. I really don't know what to look for anymore :> I can replace the hardware, but I
don't think that will change anything...
*hoping for hints :>*
> --
>
> 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
--
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
