Skip to:
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,
Percona XtraDB Cluster 5.7
wsrep_provider = 'none'
Hi @La Cancellera Yoann
Thank you for the report.
Validated as described with PXC 5.7.27.
innodb_page_size=64k
2019-11-07T10:54:00.246012Z 0 [ERROR] InnoDB: Invalid page size=65536.
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 https://perconadev.atlassian.net/browse/PXC-1970#icft=PXC-1970.
Marking this bug as a duplicate of https://perconadev.atlassian.net/browse/PXC-1970#icft=PXC-1970
Slight edit about steps
Step 2 should be rm /var/lib/mysql/{ibdata1,ib_logfile1,ib_logfile0}
rm /var/lib/mysql/{ibdata1,ib_logfile1,ib_logfile0
This step is more compatible and minimal (MariaDB)
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,