Hot answers tagged

1 vote

InnoDB Clustered Index is stored under memory?

You set the maximum amount of RAM used by the InnoDB buffer pool. It is the configuration option innodb_buffer_pool_size. If the table's clustered index is larger than the buffer pool, clearly it can'...
user avatar
  • 9,338
1 vote

InnoDB Clustered Index is stored under memory?

Index and data pages are stored in the innodb buffer pool. Only the active part of these indexes and are loaded. The least recently used data/index is purged out of the innodb buffer pool (memory). ...
user avatar
  • 6,380

Only top scored, non community-wiki answers of a minimum length are eligible