MariaDB Question:
Download Job Interview Questions and Answers PDF
Do you know how To Change Innodb_page_size?
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.
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 Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain me how to create a table in MariaDB's database? | Tell me a tool that helps with replication integrity checking? |