%s will divide the innodb_buffer_pool into memory regions to improve performance for versions of MariaDB less than 10.5. The max value is 64ySQL upto and including MySQL 8.0.The max value is 64, but should not exceed more than the number of CPU cores/threads.When your innodb_buffer_pool is less than 1GB, you should use the pool size divided by 128MB.Continue to use this equation upto the max of the number of CPU cores or 64.
Coool
None