How innodb_open_files affects performance

(Peter Zaitsev) Recently I looked at table_cache sizing which showed larger table cache does not always provides the best performance. So I decided to look at yet another similar variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mo

Read More - Register for Free Membership