From: Claudio Nanni
Date: March 9 2009 1:00pm
Subject: Re: mysql behaviour
List-Archive: http://lists.mysql.com/mysql/216632
Message-Id: <53bcf3a60903090600k523c5856ob4a13161bf6d149@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016e6de000b5989150464af375b

--0016e6de000b5989150464af375b
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Here is a very interesting reading for you!

http://dev.mysql.com/doc/refman/5.0/en/table-cache.html

Claudio


2009/3/8 Miguel <mcm@stripped>

> Hello,
>
> I wanted to know how mysql behaves when accessing to its tables.
> I have check the file descriptors and I could see different MYI and MYD
> opened.
>
> mysqld  17638 mysql  125u   REG        8,4    124928
> 83197 /usr/var/lib/mysql/xxxxxx.MYI
> mysqld  17638 mysql  126u   REG        8,4   1186784
> 83051 /usr/var/lib/mysql/yyyyy.MYD
>
> [...]
>
> my question is , must these files descriptors be closed after accesing
> to the tables? or these files keep opening?
>
> thank you very much,
> Miguel
>
>

--0016e6de000b5989150464af375b--