MariaDB Question:

Do you know how To Change Innodb_page_size?

Tweet Share WhatsApp

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.

Download MariaDB PDF Read All 55 MariaDB Questions
Previous QuestionNext Question
Explain me how to create a table in MariaDB's database?Tell me a tool that helps with replication integrity checking?