Thanks for the quick reply.
I set max_connections so low because even at peaks I never need more, and
when the slowdowns happen, it seems to have an easier time recovering if
there are 15 slow connections hanging than if there are hundreds.
I'll try the thread concurrency thing, thanks. I was under the impression
this variable was only effective on a Solaris box, but I may be wrong?
I suspect you may be right about linuxthreads being the problem.
Unfortunately, I'm on a managed hosting solution, and I'm not sure if I
want to risk a kernel panic and countless hours of expensive support :)
Thanks again,
Jon
On Mon, 7 May 2001, Rene Tegel wrote:
> On Mon, 7 May 2001 06:27:08 -0400 (EDT)
> Jon Valvatne <[EMAIL PROTECTED]> wrote:
>
>
> > As you'd expect, the server gets bogged down rather quickly at this
> > point, serving new requests very slowly if at all. Restarting MySQL helps
> > right away, buying me another 24 hours of stable uptime.
>
> If this is a linux box it could be a problem with linuxthreads. Try upgrading to
>kernel 2.4.4
> >
> > Details:
> >
> >
> > From my.cnf:
> >
> > skip-locking
> > skip-networking
> > set-variable = max_connections=18
>
> try raising max_connections
>
> > set-variable = key_buffer=200M
> > set-variable = max_allowed_packet=1M
> > set-variable = table_cache=256
> > set-variable = sort_buffer=1M
> > set-variable = record_buffer=1M
> > set-variable = myisam_sort_buffer_size=20M
> > set-variable = thread_cache=8
> > set-variable = thread_concurrency=4 # Try number of CPU's*2
>
> try raising thread concurrency.
>
> > set-variable = query_buffer_size=16k
> > set-variable = tmp_table_size=6M
> > set-variable = delayed_insert_limit=15
> > set-variable = max_write_lock_count=1
> >
> >
> > ---------------------------------------------------------------------
> > 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
> >
>
---------------------------------------------------------------------
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
