Re: processes stuck in "Opening table" state

2002-03-17 Thread Sammy Lau
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 qu

processes stuck in "Opening table" state

2002-03-15 Thread Sammy Lau
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) eve