thank you Claudio, something that is messing me up is what folllows: Uptime: 7079381 Threads: 3 Questions: 776439788 Slow queries: 189 Opens: 27771 Flush tables: 1 Open tables: 64 Queries per second avg: 109.676
I am trying to optimize a django project. I am not familiar with this framework but it seems it has a very very bad performance. Is it not normal the above results, isn't it? On Mon, 2009-03-09 at 14:00 +0100, Claudio Nanni wrote: > 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 > > > >