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?
Mysql – Innodb using key cache
database-tuninginnodbMySQL
Related Question
- Mysql – Calculating time spent on query cache lock
- Mysql – InnoDB + TokuDB fills up RAM then start swapping
- Mysql – If all tables are theisam, should I use theisam engine instead of default innodb
- MariaDB 10.3 – InnoDB Much Slower Than MyISAM
- MySQL – change all tables’ ENGINE from MyISAM to InnoDB with a single query
- Mysql – Changing storage engine to InnoDb from MyIsam is dropping records from table
Best Answer
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 setkey_buffer_sizeto 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.