Does MySQL InnoDB engine use tablecache?

Question

Does MySQL InnoDB engine use tablecache? I migrated from MyIsam to Innodb as the table engine and the monitors for "table-cache" hitrate are super low. Does Innodb use table-cache?

score 2 · Answer 1 · answered Feb 07 '12 at 06:10

2

No, InnoDB has it's own table cache which is per table. They call it the 'data dictionary'

answered Feb 07 '12 at 06:10

Mark

31
2

score 2 · Accepted Answer · answered Feb 07 '12 at 06:20

2

Nope, the table cache is generally used for MyISAM tables. InnoDB has its own cache, called either the "data dictionary" or the "table definition cache". It's built-in and configures itself.

answered Feb 07 '12 at 06:20

aestetix

36
1

Does MySQL InnoDB engine use tablecache?

2 Answers2