innodb_buffer_pool_size different from what is in my.cnf

MySQL & MariaDB Other MySQL® Questions
1

My my.cnf file has

innodb_buffer_pool_size = 105G
innodb_buffer_pool_instances = 105

But when I do a show variables like 'innodb%, the values seen are different.

show variables like 'innodb_buffer%';
+-------------------------------------+----------------+
| Variable_name | Value |
+-------------------------------------+----------------+
| innodb_buffer_pool_chunk_size | 134217728 |
| innodb_buffer_pool_dump_at_shutdown | ON |
| innodb_buffer_pool_dump_now | OFF |
| innodb_buffer_pool_dump_pct | 25 |
| innodb_buffer_pool_filename | ib_buffer_pool |
| innodb_buffer_pool_instances | 64 |
| innodb_buffer_pool_load_abort | OFF |
| innodb_buffer_pool_load_at_startup | ON |
| innodb_buffer_pool_load_now | OFF |
| innodb_buffer_pool_size | 120259084288 |
+-------------------------------------+----------------+

I don’t even have innodb_buffer_pool_chunk_size in my my.cnf. Any idea why the values from my.cnf are not reflected in the database ?

Thanks
Ravi

2

Hi Ravi,

The innodb_buffer_pool_chunk_size is only used when you’re resizing the buffer pool online. See [URL=“MySQL :: MySQL 5.7 Reference Manual :: 14.15 InnoDB Startup Options and System Variables”]https://dev.mysql.com/doc/refman/5.7...ool_chunk_size[/URL] - if you don’t specify a value it will default to ).

The innodb_buffer_pool_size of always needs to be a multiple of
(