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 <m...@moviquity.com> > 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 > >
