List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:September 27 2002 5:14am
Subject:Re: Known Database "Unknown"...
View as plain text  
In the last episode (Sep 26), zxcv said:
> MySQL status:
> 
> Threads: 1  Questions: 1860358  Slow queries: 5  Opens: 2004  Flush
> tables: 1  Open tables: 256 Queries per second avg: 0.524
> 
> MySQL show status:
> 
> | Table_locks_immediate    | 3052077    |
> | Table_locks_waited       | 0          |
> | Open_tables              | 256        | <-- This???
> | Open_files               | 479        |
> | Opened_tables            | 2004       |
> 
> Any suggestions? Did I run out of file descriptors? Currently some
> sysctl's are:

Try doubling your table_cache from 256 to 512 and see how often you get
that error.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Known Database "Unknown"...zxcv27 Sep
  • Re: Known Database "Unknown"...Dan Nelson27 Sep