[ACCEPTED]-What is the InnoDB equivalent of MyISAM's key_buffer_size?-myisam
innodb_buffer_pool_size is the setting that controls the size of 5 the memory buffer that InnoDB uses to cache 4 indexes and data. It's an important performance 3 option.
As far as I know, the best setting you can 10 adjust for InnoDB is
The size in bytes 9 of the memory buffer InnoDB uses to cache data and 8 indexes of its tables. The default value is 8MB. The 7 larger you set this value, the less disk 6 I/O is needed to access data in tables. On 5 a dedicated database server, you may set 4 this to up to 80% of the machine physical memory 3 size. However, do not set it too large 2 because competition for physical memory 1 might cause paging in the operating system.
More Related questions