Enable innodb_file_per_table

[george_zabbix]

Right after installing Mysql on Red Hat, there are files by default

/ var / lib / mysql / ibdata1
/ var / lib / mysql / ib_logfile0
/ var / lib / mysql / ib_logfile1

There is a need to enable the option immediately after installation:

innodb_file_per_table = 1

whether to enable the option, delete the ibdata1, ib_logfile0, ib_logfile1 files and run Mysql

or can you just enable the option and run Mysql?

[LenR]

As long as you enable file_per_table (and restart mysql) before you create the zabbix database, it will be allocated that way.