What data actually gets cached in InnoDB/MySQL?
- by ming yeow
Hi folks, i am trying to optimize performance for my database. My question is - what get cached in the db memory? For example:
(table with 2 columns: key (indexed), data (not indexed) updated (not indexed)
Select * where updated=20100202
(the db will do a scan - will the scanned rows be kept in memory?)
Select * where key = 20
(the db will refer to the index - will the identified rows be kept in memory?)