…innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb does not have to keep open file descriptor when table is open – open table…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…performance would suffer. Prepared Statements Number – Happily now there is a limit on total number of…tables. You can also use similar technique with innodb_file_per_table. However you can’t control growth of Innodb…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…number of connections to MySQL, which often happens when several transactions kill the database performance…file descriptor numbers and in the 7th column there are the file sizes. This makes it obvious that InnoDB status has to be under file descriptor…
