[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