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..
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.