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 | |
| 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
| -rw-r--r-- | files/config/my.cnf.CentOS | 2 | ||||
| -rw-r--r-- | files/config/my.cnf.Debian | 3 | ||||
| -rw-r--r-- | files/config/my.cnf.Gentoo | 2 |
3 files changed, 7 insertions, 0 deletions
diff --git a/files/config/my.cnf.CentOS b/files/config/my.cnf.CentOS index 791f1ba..1be434a 100644 --- a/files/config/my.cnf.CentOS +++ b/files/config/my.cnf.CentOS @@ -47,6 +47,8 @@ thread_cache_size = 4 # set it too high. innodb_buffer_pool_size = 50MB +innodb_file_per_table + query_cache_limit=5M [mysql.server] 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 # diff --git a/files/config/my.cnf.Gentoo b/files/config/my.cnf.Gentoo index d6f8509..d97fb27 100644 --- a/files/config/my.cnf.Gentoo +++ b/files/config/my.cnf.Gentoo @@ -124,6 +124,8 @@ set-variable = innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 +innodb_file_per_table + [mysqldump] quick max_allowed_packet = 16M |