List:General Discussion« Previous MessageNext Message »
From:Martijn van den Burg Date:September 17 2005 7:38pm
Subject:Does MySQL open the .frm file when opening a table?
View as plain text  
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,

-- 
</Martijn>
Thread
Does MySQL open the .frm file when opening a table?Martijn van den Burg17 Sep
  • Re: Does MySQL open the .frm file when opening a table?Gleb Paharenko2 Oct
    • Re: Does MySQL open the .frm file when opening a table?Gleb Paharenko2 Oct
      • Re: Does MySQL open the .frm file when opening a table?Martijn van den Burg3 Oct