MySQL Forums
Forum List  »  Newbie

innodb_file_per_table
Posted by: Anna Leake
Date: October 18, 2022 07:37PM

Immediately after installing mariaDB, even before creating the base, I want to enable the innodb_per_table parameter. To enable the innodb_per_table parameter on the Internet, there are 3 options:

a) backup the databases (in our case, the database is not yet), delete all the databases except information_schema and mysql (in our case, only the performance_schema database should be deleted), stop mysql, delete the ib_logfile * and ibdata1 files, set the innodb_per_table = 1 parameter, run mysql, run mysql_upgrade to generate a new performance_schema database

b) make a backup of the database, delete all databases except information_schema, performance_schema and mysql (in our case, none need to be deleted), delete the ib_logfile * and ibdata1 files, set the innodb_per_table = 1 parameter, start mysql

c) make a backup of the database, delete all the databases, delete the ib_logfile * and ibdata1 files, set the innodb_per_table = 1 parameter, start mysql.

Can it matter which option to act on?
Will it affect database performance?

newbie

Options: ReplyQuote


Subject
Written By
Posted
innodb_file_per_table
October 18, 2022 07:37PM
November 09, 2022 04:36AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.