← Back to team overview

maria-docs team mailing list archive

R: innodb-buffer-pool-instances confusion

 

I think that the MySQL manual documents this pretty well:

http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_buffer_pool_instances

"Before MySQL 5.6.6, the default is 1. As of MySQL 5.6.6, the default is 8, except on 32-bit Windows systems, where the default depends on the value of innodb_buffer_pool_size"

The 0 value you see on the commandline, however, looks weird...

Regards
Federico


--------------------------------------------
Mer 6/8/14, Daniel Bartholomew <dbart@xxxxxxxxxxx> ha scritto:

 Oggetto: [Maria-docs] innodb-buffer-pool-instances confusion
 A: "maria-developers" <maria-developers@xxxxxxxxxxxxxxxxxxx>
 Cc: "maria-docs" <maria-docs@xxxxxxxxxxxxxxxxxxx>
 Data: Mercoledì 6 agosto 2014, 23:26
 
 I was chatting with some folks on IRC
 and someone pointed this out to me.
 
 On the "Upgrading From MariaDB 5.5 to MariaDB 10.0" page, it
 says that
 the new default value for innodb-buffer-pool-instances is
 '0':
 
 https://mariadb.com/kb/en/upgrading-from-mariadb-55-to-mariadb-100/
 
 And when I run the following, it says the default is indeed
 '0':
 
 mysqld --no-defaults --verbose --help | grep
 innodb-buffer-pool-instances
 ...
 innodb-buffer-pool-instances       
                
        0
 
 
 But when I'm in the client, I get the following:
 
 MariaDB [(none)]> select @@innodb_buffer_pool_instances;
 +--------------------------------+
 | @@innodb_buffer_pool_instances |
 +--------------------------------+
 |               
               8 |
 +--------------------------------+
 
 So when innodb-buffer-pool-instances is set to '0', does
 that mean the
 actual value is dynamic or calculated in some way based on
 my other
 settings?
 
 Just trying to understand what's going on, and once I do,
 use it to
 update the XtraDB/InnoDB buffer-pool page (which doesn't
 appear to
 have been updated for 10.0).
 
 https://mariadb.com/kb/en/xtradbinnodb-buffer-pool/
 
 
 Thanks!
 
 -- 
 Daniel Bartholomew, MariaDB Release Manager
 MariaDB | http://mariadb.com
 
 _______________________________________________
 Mailing list: https://launchpad.net/~maria-docs
 Post to     : maria-docs@xxxxxxxxxxxxxxxxxxx
 Unsubscribe : https://launchpad.net/~maria-docs
 More help   : https://help.launchpad.net/ListHelp



References