rendered paste body[mysqld]
port = 3306
socket = /tmp/mysql.sock
old_passwords=1
thread_concurrency = 8
skip-locking
skip-external-locking
default_table_type=InnoDB
key_buffer = 200M
max_allowed_packet = 6M
table_cache = 800
sort_buffer_size = 1024K
net_buffer_length = 512K
read_buffer_size = 1024K
read_rnd_buffer_size = 1024K
myisam_sort_buffer_size = 8M
set-variable = max_connections=300
set-variable = max_connect_errors=65535
set-variable = max_user_connections=350
set-variable = table_cache=800
set-variable = sort_buffer=2M
set-variable = join_buffer_size=1M
set-variable = record_buffer=2M
set-variable = myisam_sort_buffer_size=20M
set-variable = wait_timeout=14400
set-variable = thread_cache_size=1024
set-variable = back_log=512
set-variable = connect_timeout=30
set-variable = tmp_table_size=10M
set-variable = query_cache_size=32M
set-variable = max_allowed_packet=8M
set-variable = innodb_file_io_threads=4
default-character-set=utf8
default-collation=utf8_czech_ci
max_heap_table_size = 96000000
long-query-time = 1
innodb_file_per_table
innodb_thread_concurrency=8
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size = 500M
innodb_additional_mem_pool_size = 100M
innodb_autoextend_increment = 8
innodb_log_buffer_size = 10M
innodb_log_file_size=50M
innodb_open_files = 600
innodb_table_locks=0
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
[mysql]
no-auto-rehash
[mysqldump]
quick
max_allowed_packet = 64M
[isamchk]
key_buffer = 60M
sort_buffer_size = 60M
read_buffer = 12M
write_buffer = 12M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 12M
write_buffer = 12M
[mysqlhotcopy]
interactive-timeout