Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Unable to create mysql files with innodb_page_size=64k

Description

Hi,

 

We encountered an issue while trying to set innodb_page_size = 64k

It worked with Percona Server, it does not with PXC

 

Reproduction step, starting from a fresh install:

  • service mysql stop

  • rm -rf /var/lib/mysql

  • Setting "innodb_page_size = 64k" in .cnf

  • service mysql start

 

These steps work for Percona Server or Oracle MySQL

 

We always see the same logs :

2019-10-28T17:43:20.890647Z 0 [ERROR] InnoDB: Invalid page size=65536.

 

I even tried to recreate it with:

mysqld --user=mysql --defaults-file=my.cnf --initialize --innodb-page-size=64k

But it seems it is ignored and creates it with 16k pages

 

We also tried to reboot server between file deletion and service restart.

 

 

Did we miss something ?

 

Thanks,

Environment

Percona XtraDB Cluster 5.7

wsrep_provider = 'none'

 

Attachments

1

Smart Checklist

Activity

Show:

Lalit Choudhary November 7, 2019 at 11:09 AM

Hi

Thank you for the report.

Validated as described with PXC 5.7.27.

innodb_page_size=64k

Not only 64k but innodb_page_size with 8k/32k is also failing with a similar error.  We do see this issue in the percona server.

This issue is similar to .

Marking this bug as a duplicate of 

 

La Cancellera Yoann November 5, 2019 at 9:30 AM

Slight edit about steps

Step 2 should be rm /var/lib/mysql/{ibdata1,ib_logfile1,ib_logfile0}

 

This step is more compatible and minimal (MariaDB)

Duplicate

Details

Assignee

Reporter

Affects versions

Priority

Smart Checklist

Created November 4, 2019 at 5:09 PM
Updated March 6, 2024 at 10:02 PM
Resolved November 7, 2019 at 11:16 AM