From: Dan Nelson
Date: September 27 2002 5:14am
Subject: Re: Known Database "Unknown"...
List-Archive: http://lists.mysql.com/mysql/120787
Message-Id: <20020927051416.GA7711@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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