diff options
author | mh <mh@immerda.ch> | 2012-01-17 22:31:44 +0100 |
---|---|---|
committer | mh <mh@immerda.ch> | 2012-01-17 22:31:44 +0100 |
commit | a72ab41660d403f7615eed0e1bf538a3f26cb8da (patch) | |
tree | 53479a4b62a9a72a0569135dd13349c9b42293d9 /files/config/my.cnf.Debian | |
parent | 8e18c759111c649059d25520afa4dbf2a9c9cf08 (diff) |
add innodb_file_per_table option by default
mysql has one innodb file per default and this can become very
huge, which can trigger various issues [1]. So in general it
is recommended to set the innodb_file_per_table option [2].
[1] http://forums.mysql.com/read.php?35,121880,121886
[2] http://dev.mysql.com/doc/refman/5.0/en/innodb-multiple-tablespaces.html
Diffstat (limited to 'files/config/my.cnf.Debian')
-rw-r--r-- | files/config/my.cnf.Debian | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/files/config/my.cnf.Debian b/files/config/my.cnf.Debian index 1935cfb..e2f1559 100644 --- a/files/config/my.cnf.Debian +++ b/files/config/my.cnf.Debian @@ -98,6 +98,9 @@ skip-bdb # Read the manual for more InnoDB related options. There are many! # You might want to disable InnoDB to shrink the mysqld process by circa 100MB. #skip-innodb + +innodb_file_per_table + # # * Security Features # |