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