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

[nobody at svn.erp5.org]

Author: jm
Date: Tue Nov 30 17:49:05 2010
New Revision: 40936

URL: http://svn.erp5.org?rev=40936&view=rev
Log:
erp5.recipe.mysqlserver: optimize (or suggest optimization) InnoDB for ERP5

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=40936&r1=40935&r2=40936&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:49:05 2010
@@ -26,6 +26,21 @@ bind-address = ${mysql_host}
 max_allowed_packet = 128M
 query_cache_size = 32M
 
+innodb_locks_unsafe_for_binlog = 1
+
+# The following are important to configure and depend a lot on to the size of
+# your database and the available resources.
+#innodb_buffer_pool_size = 4G
+#innodb_log_file_size = 256M
+#innodb_log_buffer_size = 8M
+
+# Some dangerous settings you may want to uncomment if you only want
+# performance or less disk access. Useful for unit tests.
+#innodb_flush_log_at_trx_commit = 0
+#innodb_flush_method = nosync
+#innodb_doublewrite = 0
+#sync_frm = 0
+
 # Uncomment the following if you need binary logging, which is recommended
 # on production instances (either for replication or incremental backups).
 #log-bin=mysql-bin