…Open_filesblogpercona.commanual open_files_limitblogpercona.commanual Open_streamsblogpercona.commanual Open_table_definitionsblogpercona.commanual Open_tablesblogpercona.commanual Opened_filesblogpercona.commanual Opened_table_definitionsblogpercona.commanual Opened…
Post: Limiting InnoDB Data Dictionary
February 11, 2009 By 13 Comments
…table) it is disaster. For 100.000+ tables InnoDB is consuming gigabytes of memory, keeping definition in memory all time after table was once opened…/files/patches/innodb_dict_size_limit_…table_cache, memory consumed by data dictionary may exceed innodb_dict_size_limit, as we can’t delete any table…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… 100 tables and the table_definition_cache set to 1000. My understanding of this is that MySQL won’t revert to opening the FRM files to read the table definition…. what storage engine it is. We can ignore the upper limit on number of storage engines for MySQL and understanding the…
Post: Slow DROP TABLE
June 16, 2009 By 21 Comments
…Opening tables | select sql_no_cache * from other_table limit 1 | +—–+——+———–+——+———+——+—————-+————————————————+ I tried some alternative approaches to trick MySQL into removing smaller files with DROP TABLE…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…Definition of foreign key which failed as well as the closest match which was located in parent table…use. Innodb tries to limit thread concurrency allowing only…cache is not enough. This is typically done by calling fsync() for modified files… queue 1 read views open inside InnoDB Main thread process …
