what are the steps to change Innodb_page_size?

devquora
devquora

Posted On: Feb 22, 2018

 

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    MariaDB Interview Questions

    What do you understand by the MariaDB?

    MariaDB is developed by MySQL developers. It is a popular public source under GNU GPL which is related to database management technology...

    MariaDB Interview Questions

    Mention some characteristics of MariaDB?

    It has a lot of unique features that make it more useful and wonderful to work over it than MySQL. Some features are:..

    MariaDB Interview Questions

    Which command is used to delete the table in MariaDB’s database?

    The command DROP TABLE is used to delete the table in MariaDB’s database...