Here is a very interesting reading for you!
2009/3/8 Miguel <mcm@stripped>
> 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
> 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,