Not the answer you need?
Register and ask your own question!

Change of InnoDB page size at XtraDB Cluster 5.7.18

sigimsigim EntrantLegacy User Role Beginner
Hi,

as our servers (Ubuntu 16.04.1) run on SSDs with 4k blocks (ext4), I tried to change the InnoDB page size from 16K to 4K as suggested in several performance guides. As this is a new server, there is no data which can get lost. I tried it this way:

1. Install XtraDB Cluster (https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/apt.html) and run
service mysql stop

2. Created an own my.cnf with
[mysqld]
innodb-page-size=4k

3. Delete MySQL data with
rm /var/lib/mysql/* -R

4. Initialize new MySQL Instance
mysqld --defaults-file=my.cnf --initialize --user=mysql

This fails with the following error:

[ERROR] InnoDB: Invalid page size=4096

Is there another way to change the innodb-page-size for the XtraDB Cluster? I'm just curious, because this works for Standard MySQL 5.7 Server.

Thanks.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.