my.cnf.in 1.86 KB
Newer Older
1 2 3 4 5 6 7 8 9 10
# ERP5 buildout my.cnf template based on my-huge.cnf shipped with mysql
# The MySQL server
[mysqld]
# ERP5 by default requires InnoDB storage. MySQL by default fallbacks to using
# different engine, like MyISAM. Such behaviour generates problems only, when
# tables requested as InnoDB are silently created with MyISAM engine.
#
# Loud fail is really required in such case.
sql-mode="NO_ENGINE_SUBSTITUTION"

11 12 13 14
# Workaround for https://bugs.launchpad.net/maria/+bug/985828
# that causes wrong result in Resource_zGetInventoryList etc.
optimizer_switch = derived_merge=off

15
skip-show-database
16
%(networking)s
17 18 19 20
socket = %(socket)s
datadir = %(data_directory)s
pid-file = %(pid_file)s
log-error = %(error_log)s
21 22
slow_query_log
slow_query_log_file = %(slow_query_log)s
23
long_query_time = 1
24 25 26
max_allowed_packet = 128M
query_cache_size = 32M

27
plugin-load = ha_mroonga.so;ha_sphinx.so;handlersocket.so
28

29 30
# By default only 100 connections are allowed, when using zeo
# we may have much more connections
31
max_connections = 1000
32

33 34 35 36 37 38
# 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

39 40 41
# very important to allow parallel indexing
innodb_locks_unsafe_for_binlog = 1

42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
# 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

# Force utf8 usage
collation_server = utf8_unicode_ci
character_set_server = utf8
skip-character-set-client-handshake

[mysql]
no-auto-rehash
socket = %(socket)s

[mysqlhotcopy]
interactive-timeout