I've been tweaking the values of the buffer pool size (
innodb_buffer_pool_size) and the number of buffer pool instances (
innodb_buffer_pool_instances) in the my.ini initialization file to optimize heavy load handling with MySQL. I can successfully change the buffer pool size, both dynamically and with the my.ini file, but no matter what I change the
innodb_buffer_pool_instances value to, it is always 1 when I query it with
What I've already tried:
I made sure to set the buffer pool size > 1GB. I've set it to 24GB and verified that it is indeed that big.
Made sure I'm using the correct my.ini file location.
After changing the value in my.ini I restart the MySQL server.
I've even tried restarting my computer after changing the value, but it still always remains 1.
What am I missing? Why can't I change the value of