From: Brandon Pulsipher
Date: March 16 1999 8:13pm
Subject: open_files limit?
List-Archive: http://lists.mysql.com/mysql/349
Message-Id: <007c01be6fe9$6b5a5da0$1905000a@brandonp.superstats.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

We are running  mysql 3.22.16a-gamma on a Linux 2.2.3 kernel, patched with
Alan Cox's ac1 patch.  This allows us to increase the file handle limit.  We
have set the limit to several thousand, and increased the table_cache to
1024.  Things seem to be going OK, but when I do a show status, I see this:

| Open_tables              | 1023   |
| Open_files               | 113    |
| Open_streams             | 0      |
| Opened_tables            | 7037   |

Open_files never gets above about 115.  Is mysql really taking advantage of
our improvements on the file handle limit?  If not, how can we make it?

Thank you.


-Brandon