From: Claudio Nanni
Date: March 9 2009 5:31pm
Subject: Re: mysql behaviour
List-Archive: http://lists.mysql.com/mysql/216638
Message-Id: <49B5528B.7050806@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

It is really not enough for me to give an opinion but I do not see 
anything strange, what is your worry?


Miguel wrote:
> 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 <mailto: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
>> >
>> >
>>