[ACCEPTED]-What is the InnoDB equivalent of MyISAM's key_buffer_size?-myisam

Accepted answer

Score: 17

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.

See the manual page for the full explanation. The 2 MySQL Performance Blog also has an article about how to choose 1 a proper size for it.

Score: 2

As far as I know, the best setting you can 10 adjust for InnoDB is innodb_buffer_pool_size.

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.

Source: stackoverflow.com

MySQL MyISAM how to perform a read without locking a table?

MySQL MyISAM table locking

Unknown table engine 'InnoDB'

What is innodb_buffer_pool_size & innodb_log_file_size?

#1025 - Error on rename of './database/#sql-2e0f_1254ba7' to './database/table' (errno: 150)

MySQL InnoDB locks on joined rows

MySQL REPLACE in an auto incremented row

Prevent auto increment on MySQL duplicate insert

What are MySQL database engines?

How to change MySQL Primary Key from signed to unsigned?

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.