Hi, It's true that MyISAM keeps two files descriptors open per open table but this is MyISAM specific. An open table in MySQL isn't a one to one mapping to file descriptors, it's simply a c++ object. It's up to the storage engine how it manages file descriptors. Engines can use worker threads with their own descriptors or like the heap engine use none at all. it's possible to have many more open tables than file descriptors.
-Eric On Mon, Jun 2, 2008 at 9:54 AM, Jean-Paul Bauer <[EMAIL PROTECTED]> wrote: > Hi all, > I'm a bit confused about the allowed range of values for the > open-files-limit and the table_cache settings. The documentation > states that the range of values allowed for open-files-limit is > 0-65535 and for table_cache it is 1-524288. > > Where I get confused is that from my understanding each table in the > table_cache will require at least one file descriptor (two if it is a > MyISAM) table. Surely this means that the maximum for table_cache > effectively is 65535. What am I misunderstanding or missing here? > > Documentation links: > http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_open-files-limit > http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#option_mysqld_table_cache > > Thanks for any clarification on this. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- high performance mysql consulting. http://provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
