some reasonable defaults

1 files changed, 25 insertions, 0 deletions

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
+