Innodb using key cache?

Question

As Innodb is my default engine, all my tables are innodb. But while monitoring with the help of a tool, I found a constant spike in key_write_requests and key_read_requests. These two variables are myisam variables. Will innodb internally use key cache for any process? Is it possible?

Answer 1

In addition to what Md Haidar Ali Khan said, ... The "default storage engine" does not mean that you created all the tables in that engine. You should verify with SHOW TABLE STATUS; for you database(s). That will say, among other things, what Engine is being used.

innodb_buffer_pool_size, for an InnoDB-only system, should be set to about 70% of available RAM (if RAM is at least 4GB). And set key_buffer_size to some small value, say, 20M because of system tables that are in MyISAM. These system tables probably caused the spikes you saw.

More discussion of memory -- including what to do if you are using MyISAM.

Answer 2

As per MySQL Documentation 'InnoDB' maintains a storage area called the buffer pool for caching data and indexes in memory. Innodb maintain their Buffer Pool through LRU Algorithm.

As Table,data & indexes Storing Format of both MyISAM & Innodb is different ways like MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI) and InnoDB stores its tables and indexes in a tablespace.

For Ref Here & Here