• caches data and indexes in memory
  • caches also inserts and updates
  • with enough memory InnoDB can act as “memory database”
  • can be splited into more parts (if overall size of all of them is bigger then 1 GB) to improve performance
  • parameters:
    • innodb_buffer_pool_size
    • innodb_buffer_pool_instances
    • innodb_old_blocks_pct
    • innodb_old_blocks_time