List:General Discussion« Previous MessageNext Message »
From:walter harms Date:June 13 2013 10:24am
Subject:Re: open files in mysqld 5.1.53
View as plain text  

Am 13.06.2013 12:07, schrieb Hartmut Holzgraefe:
> On 06/13/2013 09:41 AM, walter harms wrote:
> 
>> Hello Manuel,
>> thx for your tip. We caught the problem when we moved to partitions.
>> Strange is that
>> while testing the problem did not show up and even now we no clue why
>> we experience
>> the sudden burst of use for file descriptors.
> 
> problem with partitions is that all partition files get opened when a
> partitioned table is used, even when only actually touching a single
> partition
> 
> this combined with file-per-table engines like MyISAM or ARCHIVE (maybe
> with InnoDB with innodb-file-per-table being active, too?) may well lead
> to a lot of file handles being used, and this again combined with the
> table_cache keeping opened tables (and the related files) open for later
> reuse can lead to a lot of file handles being used and kept in use ...
> FLUSH TABLES may help here by at least releasing those handles that are
> just kept open by the table cache ...
> 
> see also bug reports like e.g.
> 
> http://bugs.mysql.com/bug.php?id=64498
> 

yes that seems related, a quick check show that we have ~800 file/table
we have already increased our files limit some time ago, so this should
not be a problem.

re,
 wh
Thread
open files in mysqld 5.1.53walter harms12 Jun
  • Re: open files in mysqld 5.1.53Reindl Harald12 Jun
  • Re: open files in mysqld 5.1.53Manuel Arostegui12 Jun
    • Re: open files in mysqld 5.1.53walter harms13 Jun
      • Re: open files in mysqld 5.1.53Hartmut Holzgraefe13 Jun
        • Re: open files in mysqld 5.1.53walter harms13 Jun
        • Re: open files in mysqld 5.1.53Reindl Harald13 Jun