# ERP5 buildout my.cnf template based on my-huge.cnf shipped with mysql # The following options will be passed to all MySQL clients [client] user = port = ${configuration:mysql_port} socket = ${configuration:mysql_sock} # 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" port = ${configuration:mysql_port} socket = ${configuration:mysql_sock} datadir = ${configuration:mysql_datadir} pid-file = ${configuration:mysql_pid} log-error = ${configuration:mysql_error_log} log-slow-queries = ${configuration:mysql_slow_query_log} long_query_time = ${configuration:mysql_slow_query_time} 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 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