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