Interviewer And Interviewee Guide

MariaDB Interview Question:

Do you know how To Change Innodb_page_size?

Submitted by: Muhammad
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.
Submitted by: Muhammad

Read Online MariaDB Job Interview Questions And Answers
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.