Join the community today
Become a Member

MariaDB MariaDB 10.3.x and up needs another value for innodb_buffer_pool_instances?

Discussion in 'MariaDB & General MySQL news & discussions' started by pamamolf, Apr 30, 2024.

  1. pamamolf

    pamamolf Premium Member Premium Member

    4,056
    427
    83
    May 31, 2014
    Ratings:
    +828
    Local Time:
    7:55 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    Hi,

    If i am understanding correctly using MariaDB 10.3.x and up the value:

    Code:
    innodb_buffer_pool_instances=12
    According to:
    https://mariadb.com/kb/en/mariadb/xtradbinnodb-server-system-variables/#innodb_buffer_pool_instances

    should be set to 1

    I just install on Almalinux using the one line installer MariaDB 10.4.x and i can i got that value as:


    Code:
    innodb_buffer_pool_instances=12
    Maybe we can change it for better performance on Centminmod template?

    Thank you !
     
  2. eva2000

    eva2000 Administrator Staff Member

    51,987
    11,976
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,473
    Local Time:
    2:55 AM
    Nginx 1.25.x
    MariaDB 10.x
    Nice catch! Will update the template routines. FYI, for MariaDB 10.5+ Centmin Mod automatically removes innodb_buffer_pool_instances anyway as it's deprecated variable.