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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
