The study of Mysql Innodb_buffer_pool_size

In the MySQL configuration file, another configuration option:

Configuration options for Innodb_buffer_pool_size:

The Innodb_buffer_pool_size parameter represents the buffer pool byte size, InnoDB the memory area of the cache table and index data. The default value for MySQL is 128M.

To view a command:

　　

Show  variables like  '%innodb_buffer_pool_size%';

Results:

　　

For the calculation of the value: 134217728[byte]/1024[kb]/1024[mb]=128m that is, mysql default innodb_buffer_pool_size size is 128M

The study of Mysql Innodb_buffer_pool_size