From 1caaa07190f05cf2e5a535de271f249321f9f8d2 Mon Sep 17 00:00:00 2001
From: mh <mh@immerda.ch>
Date: Thu, 5 Dec 2013 10:47:25 +0100
Subject: some reasonable defaults

---
 files/config/my.cnf.CentOS | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)

diff --git a/files/config/my.cnf.CentOS b/files/config/my.cnf.CentOS
index 1b6ee1a..58090f7 100644
--- a/files/config/my.cnf.CentOS
+++ b/files/config/my.cnf.CentOS
@@ -7,7 +7,11 @@ socket=/var/lib/mysql/mysql.sock
 # clients (those using the mysqlclient10 compatibility package).
 old_passwords=0
 
+character-set-server        = utf8
+skip-name-resolve
+
 bind-address=127.0.0.1
+max_allowed_packet = 10M
 
 # Disabling symbolic-links is recommended to prevent assorted security risks
 symbolic-links=0
@@ -46,12 +50,27 @@ thread_cache_size = 4
 # cause paging in the operating system.  Note that on 32bit systems you
 # might be limited to 2-3.5G of user level memory per process, so do not
 # set it too high.
+innodb_data_home_dir = /var/lib/mysql/data
+innodb_data_file_path = ibdata1:10M:autoextend
+innodb_log_group_home_dir = /var/lib/mysql/
 innodb_buffer_pool_size = 50MB
 
 innodb_file_per_table
 
 query_cache_limit=5M
 
+[mysql]
+no-auto-rehash
+# Remove the next comment character if you are not familiar with SQL
+#safe-updates
+default-character-set=utf8
+
+[mysqlimport]
+default-character-set=utf8
+
+[mysqlshow]
+default-character-set=utf8
+
 [mysql.server]
 user=mysql
 basedir=/usr
@@ -59,3 +78,9 @@ basedir=/usr
 [mysqld_safe]
 log-error=/var/log/mysqld.log
 pid-file=/var/run/mysqld/mysqld.pid
+
+[mysqldump]
+quick
+max_allowed_packet = 16M
+default-character-set=utf8
+
-- 
cgit v1.2.3