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