Bug #79201 InnoDB: Too small buffer pool for innodb_page_size=64k
Submitted: 10 Nov 2015 10:14 Modified: 22 Dec 2015 18:05
Reporter: Marko Mäkelä Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.7.10 OS:Any
Assigned to: CPU Architecture:Any

[10 Nov 2015 10:14] Marko Mäkelä 
Description:
When WL#5757 enabled innodb_page_size=64k, it failed to adjust the minimum innodb_buffer_pool_size, which is measured in bytes, not pages.
Startup and bootstrap (and possibly also recovery) can fail due to this.

How to repeat:
./mtr --mysqld=--innodb_page_size=64k --mysqld=--innodb-buffer-pool-size=5M main.1st

Suggested fix:
Refuse startup if innodb_buffer_pool_size is smaller than some predetermined number of pages.
Or make the minimum value (currently, 5MiB) big enough for the 64k page size.
[22 Dec 2015 18:05] Daniel Price 
Posted by developer:
 
Fixed as of the upcoming 5.7.11, 5.8.0 release, and here's the changelog entry:

A small buffer pool with an innodb_page_size setting of 64K could cause
startup, bootstrap, and recovery failures.
[30 Aug 2016 11:56] Laurynas Biveinis 
See bug 82798 for a 5.6 backport motivation