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.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
