my.cnf.in 1.51 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11
# 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]
port = ${configuration:mysql_port}
socket = ${configuration:mysql_sock}
12 13 14
datadir = ${configuration:mysql_datadir}
pid-file = ${configuration:mysql_pid}
log-error = ${configuration:mysql_error_log}
15 16
skip-locking
key_buffer = 384M
17
max_allowed_packet = 128M
18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69
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


[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