Showing entries 1 to 2
Displaying posts with tag: innodb_buffer_pool_instances (reset)
How to get confused about buffer pool size allocation?

How it feels when you realize that, something going to be scary in term of question – “Wait, why? how?”
Let’s see:

I am trying to allocate 9G buffer pool size with 64 instances:


From error log it said that:

InnoDB: Initializing buffer pool, total size = 16G, instances = 64, chunk size = 128M

“Wait, why? how?” N1

From select it is also allocated 16G:

mysql> select @@innodb_buffer_pool_size/1024/1024/1024;
| @@innodb_buffer_pool_size/1024/1024/1024 |
| 16.000000000000 |

Just continue to increase pool size:

If you give 17G:

[Note] InnoDB: Initializing buffer pool, …

[Read more]
MySQL 5.5 – A Community Winner

Ever since MySQL 5.5 beta has been announced by Edward Screven, Oracle’s chief corporate architect; there is lot of positive buzz (here, here, …) about the performance and scalability improvements added in this release. We should all be thankful to Michael Ronstrom (as most of the key developers are already working on different forks), who [...]

Showing entries 1 to 2