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