From: Martijn van den Burg
Date: September 17 2005 7:38pm
Subject: Does MySQL open the .frm file when opening a table?
List-Archive: http://lists.mysql.com/mysql/189206
Message-Id: <200509172138.38478.m_a_r_t_ij_n@wanadoo.nl>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit

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>