What data actually gets cached in InnoDB/MySQL?

Posted by ming yeow on Stack Overflow See other posts from Stack Overflow or by ming yeow
Published on 2010-05-19T16:15:26Z Indexed on 2010/05/19 23:00 UTC
Read the original article Hit count: 175

Filed under:
|

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?)

© Stack Overflow or respective owner

Related posts about mysql

Related posts about caching