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 - 04:30:50 CDT

Hello.

> In other words: does opening a MyISAM table take three file handles,

Maybe you can find an answer here:
   http://dev.mysql.com/doc/mysql/en/table-cache.html

" You also have to take into account that the MyISAM storage engine
needs two file descriptors for each unique open table."

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

Martijn van den Burg wrote:
> Hi list,
>
> If MySQL opens a table, does it also need open the corresponding table format
> file?
> If it does, does it increment open_files?
>
> In other words: does opening a MyISAM table take three file handles, and
> opening a InnoDB table two (assuming the tablespace file isn't opened yet)?
>
>
> Kind regards,
>

--
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