|
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: Martijn van den Burg (m_a_r_t_ij_n
wanadoo.nl)
Date: Mon Oct 03 2005 - 11:21:47 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi,
Thanks for your detailed reply.
Kind regards,
Martijn
On Sunday 02 October 2005 21:18, Gleb Paharenko wrote:
> Hello.
>
> > For InnoDB I'm not sure, so I don't make guessings.
>
> I'm continuing the previous message. Here is what I've found out:
>
>
> InnoDB has its own open file statistics, but currently they are not
> printed even by SHOW INNODB STATUS.
> By default, InnoDB keeps at most 300 files open. It always keeps the
> ibdata files open. Please refer to my.cnf options. If there are more
> than 300 open files, then files are closed on the LRU basis.
--
</Martijn>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]