On Mon, 7 May 2001 07:40:26 -0400 (EDT)
<[EMAIL PROTECTED]> wrote:
>
> 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.
Are you saying you have 15 slow queries and thus only 3 connections available for your
site to run at time server crashes? that's wrong and probably one of the reasons your
site slows down.
I guess you have some script(s) with 'corrupt' queries that take loads of time (on
non-indexed fields or something) to complete. So mysql gets more and more slow queries
which may take hours to complete, whilst slowing down your site.
You should check which script(s) are responsible for this, and fix the bugs.
>
> 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?
you might be quite right. i just noticed it was not the default..
>
> 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 :)
you always could try if same database/scripts generate same errors on another box..
>
> 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
>
---------------------------------------------------------------------
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
