List:General Discussion« Previous MessageNext Message »
From:Miguel Date:March 9 2009 3:30pm
Subject:Re: mysql behaviour
View as plain text  
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 <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
> >
> >

Thread
mysql behaviourMiguel8 Mar
  • Re: mysql behaviourClaudio Nanni9 Mar
    • Re: mysql behaviourMiguel9 Mar
      • Re: mysql behaviourClaudio Nanni9 Mar
        • Re: mysql behaviourMiguel9 Mar
          • Re: mysql behaviourClaudio Nanni9 Mar
Re: mysql behaviourMiguel9 Mar
  • Re: mysql behaviourClaudio Nanni9 Mar
    • Re: mysql behaviourMiguel9 Mar
      • Re: mysql behaviourClaudio Nanni10 Mar
        • Re: mysql behaviourMiguel10 Mar
          • Re: mysql behaviourClaudio Nanni10 Mar