InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
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. 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. |
|