hi all, since i haven't got any suggestion to the following problem, i'm wondering if anyone could point me to a source where i could seek help (i can't get my boss to pay for the support contract...)
thanks a lot. Sammy Lau wrote: > > 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 -- 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