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 <[email protected] <mailto:[email protected]>>
> 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
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
