hi all, i've got a mysql server running around 100 queries per sec for most of the time. i got only 1 table in MyISAM format. i got only around 6000 updates to this table per day. max_connection is set to 600 thread_cache is set to 600 table_cache is set to 600 (there is NO join operation)
everything seems fine, right. my problem is, sometimes, i see a lot of processes (200+) got stuck in "Opening table" state. at the same time mysqladmin status tells me the # of open table is 583. this number never reaches the max setting. anyone got an idea why i'm seeing this behavior. please let me know if i'm missing any information here. thanks a lot. -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. --------------------------------------------------------------------- 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
