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