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