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