OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Does MySQL open the .frm file when opening a table?

From: Gleb Paharenko (gleb.paharenkoensita.net)
Date: Sun Oct 02 2005 - 14:18:25 CDT

Hello.

> For InnoDB I'm not sure, so I don't make guessings.

I'm continuing the previous message. Here is what I've found out:

  InnoDB has its own open file statistics, but currently they are not
printed even by SHOW INNODB STATUS.
   By default, InnoDB keeps at most 300 files open. It always keeps the
ibdata files open. Please refer to my.cnf options. If there are more
than 300 open files, then files are closed on the LRU basis.

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __ ___ ___ ____ __
  / |/ /_ __/ __/ __ \/ / Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql