Google News
logo
MariaDB - Interview Questions
what are the steps to change Innodb_page_size?
It does need to do anything with a new install. There are steps to follow if you want to change the size. These are :
 
* Firstly, go through your data and export it by moving it or by deleting the database and folders.
* When it is done, fixed innobd_page_size to any of the 4k or 8k
* After that, restart the MariaDB.
* When it is on, there appears a new XtraDB but having smaller page size.
* Now you are free to introduce your data and do what you want to do.

So, in this whole procedure, you don't need to do anything with the new installment.
Advertisement