How many files does InnoDB have open?

If you use┬áinnodb_file_per_table = 1 and┬áinnodb_open_files = X (whatever amount is suitable for your server) there’s no way internal to MySQL for finding out how many IBD files InnoDB actually has open. Neither SHOW GLOBAL STATUS LIKE ‘innodb%’ nor SHOW ENGINE INNODB STATUS provide this information. Many sites do have a growing number of tables, […]