innodb-file-per-table.cnf 430 B

123456789101112
  1. # https://howto.biapy.com/fr/debian-gnu-linux/serveurs/mysql/installer-et-configurer-mysql-sur-debian
  2. # Use one file by InnoDB table.
  3. # Use Barracuda as InnoDB engine.
  4. # Allow InnoDB large indexs.
  5. # Use Dynamic row format.
  6. # Reduce disk usage, ease disk space reclaiming.
  7. [mysqld]
  8. innodb_file_per_table = 1
  9. innodb_file_format=Barracuda
  10. innodb_large_prefix=1
  11. ; Option below only for MariaDB 10.2
  12. ;innodb_default_row_format=DYNAMIC