1. Apr 30, 2024 #1
   

   pamamolf Premium Member Premium Member

   4,100

   428

   83

   May 31, 2014

   Ratings:

   +836

   Local Time:

   10:35 AM

   Nginx-1.26.x

   MariaDB 10.6.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. Apr 30, 2024 #2
   

   eva2000 Administrator Staff Member

   55,155

   12,249

   113

   May 24, 2014

   Brisbane, Australia

   Ratings:

   +18,825

   Local Time:

   5:35 PM

   Nginx 1.27.x

   MariaDB 10.x/11.4+

   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.

    

• Log in with Facebook

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?
  Lost access to your email account?