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