From a72ab41660d403f7615eed0e1bf538a3f26cb8da Mon Sep 17 00:00:00 2001 From: mh Date: Tue, 17 Jan 2012 22:31:44 +0100 Subject: 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 --- files/config/my.cnf.Gentoo | 2 ++ 1 file changed, 2 insertions(+) (limited to 'files/config/my.cnf.Gentoo') 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 -- cgit v1.2.3