[Erp5-report] r40934 jm - /erp5/trunk/utils/erp5.recipe.mysqlserver/src/erp5/recipe/mysqlse...

[nobody at svn.erp5.org]

Author: jm
Date: Tue Nov 30 17:48:31 2010
New Revision: 40934

URL: http://svn.erp5.org?rev=40934&view=rev
Log:
erp5.recipe.mysqlserver: clear my.cnf out of useless variables

- ERP5 does not use MyISAM
- use default values when MySQL is able to compute good ones
- replication has not been used so far

Modified:
    erp5/trunk/utils/erp5.recipe.mysqlserver/src/erp5/recipe/mysqlserver/my.cnf.in

Modified: erp5/trunk/utils/erp5.recipe.mysqlserver/src/erp5/recipe/mysqlserver/my.cnf.in
URL: http://svn.erp5.org/erp5/trunk/utils/erp5.recipe.mysqlserver/src/erp5/recipe/mysqlserver/my.cnf.in?rev=40934&r1=40933&r2=40934&view=diff
==============================================================================
--- erp5/trunk/utils/erp5.recipe.mysqlserver/src/erp5/recipe/mysqlserver/my.cnf.in [utf8] (original)
+++ erp5/trunk/utils/erp5.recipe.mysqlserver/src/erp5/recipe/mysqlserver/my.cnf.in [utf8] Tue Nov 30 17:48:31 2010
@@ -22,31 +22,13 @@ log-error = ${mysql_error_log}
 log-slow-queries = ${mysql_slow_query_log}
 long_query_time = ${mysql_slow_query_time}
 bind-address = ${mysql_host}
-skip-locking
-key_buffer = 384M
+
 max_allowed_packet = 128M
-table_cache = 512
-sort_buffer_size = 2M
-read_buffer_size = 2M
-read_rnd_buffer_size = 8M
-myisam_sort_buffer_size = 64M
-thread_cache_size = 8
 query_cache_size = 32M
-# Try number of CPU's*2 for thread_concurrency
-thread_concurrency = 8
-
-# Disable Federated by default
-skip-federated
 
-# Replication Master Server (default)
 # binary logging is required for replication
 log-bin=mysql-bin
 
-# required unique id between 1 and 2^32 - 1
-# defaults to 1 if master-host is not set
-# but will not function as a master if omitted
-server-id	= 1
-
 # Force utf8 usage
 collation_server = utf8_unicode_ci
 character_set_server = utf8
@@ -54,26 +36,8 @@ default-character-set = utf8
 skip-character-set-client-handshake
 ${mysqld-extra-configuration}
 
-[mysqldump]
-quick
-max_allowed_packet = 16M
-
 [mysql]
 no-auto-rehash
-# Remove the next comment character if you are not familiar with SQL
-#safe-updates
-
-[isamchk]
-key_buffer = 256M
-sort_buffer_size = 256M
-read_buffer = 2M
-write_buffer = 2M
-
-[myisamchk]
-key_buffer = 256M
-sort_buffer_size = 256M
-read_buffer = 2M
-write_buffer = 2M
 
 [mysqlhotcopy]
 interactive-timeout