From a72ab41660d403f7615eed0e1bf538a3f26cb8da Mon Sep 17 00:00:00 2001
From: mh <mh@immerda.ch>
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.CentOS | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'files/config/my.cnf.CentOS')

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]
-- 
cgit v1.2.3