From: Michael Widenius
Date: March 16 1999 8:49pm
Subject: open_files limit?
List-Archive: http://lists.mysql.com/mysql/351
Message-Id: <14062.49205.503675.499994@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "Brandon" == Brandon Pulsipher <Brandon@stripped> writes:

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

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

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

Brandon> Thank you.

Hi!

I just checked the code for 'open_files':  This correct up to
MY_NFILE;  After this the my_open.c package will not count the number
of open files (everything else will work normal).

If you want, you can increase this at:

include/global.h:

#define MY_NFILE       127     /* This is only used to save filenames */

(The structure is only used to save filenames for some error messages
and isn't critical in any way).

As you have open_tables set to 1023, this means that MySQL is using
the given limit.

Regards,
Monty