The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

How to change innodb_page_size?

I'm trying to change the innodb_page_size of my MariaDB 10.1.21 X64 installation on Windows.

I know I can only set this on a fresh installation, but I can't figure out how to do a fresh installation with innodb_page_size=4k How can I do this? I tried running mysql_install_db.exe, but it doesn't give me any option to set the innodb page size. Also my MariaDB keeps crashing because the users table was missing, it appears that I need to do more than run mysql_install_db.exe..

Answer

No need for a fresh install.

Just export your data, move or delete the system database (ibdata1) and the log files (ib_logfile0 & ib_logfile1), set innodb_page_size to either 4k or 8k, and restart MariaDB. A new XtraDB instance will be created with the smaller page size. Then you can import your data and run your tests.

Source: https://blogs.oracle.com/mysqlinnodb/entry/innodb_5_6_4_supports

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.