Not the answer you need?
Register and ask your own question!

innodb_buffer_pool_size different from what is in my.cnf

ravimalghan@yahoo.com[email protected] EntrantCurrent User Role Novice
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

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.