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
>
>
