1
2
3
4
5
6

# 128MB
innodb_buffer_pool_chunk_size=134217728
# 4 instances
innodb_buffer_pool_instances=4
# 4GB
innodb_buffer_pool_size=4294967296

1
2
3
4

set global innodb_buffer_pool_size=4294967296;

# cat:
show VARIABLES like '%innodb_buffer_pool%';