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