[mysqld]
performance-schema = 0
event_scheduler = 1
open_files_limit = 900000
log_error = /speed/mysql/error_serv.log
datadir = /speed/mysql
default-storage-engine=InnoDB
tmp_table_size = 128M
max_heap_table_size = 128M
max_allowed_packet = 512M
max_connections = 600
max_user_connections = 35
max_connect_errors = 5
query_cache_type = 1
query_cache_size = 256M
query_cache_limit = 1M
interactive_timeout = 80
wait_timeout = 260
connect_timeout = 20
thread_stack = 256k
thread_pool_max_threads = 8
thread_cache_size = 128
transaction-isolation = REPEATABLE-READ
key_buffer_size = 1G
sort_buffer_size = 2M
read_buffer_size = 2M
join_buffer_size = 4M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
table_definition_cache = 712000
table_open_cache = 500000
aria_pagecache_buffer_size = 2G
innodb_file_per_table
innodb_purge_threads = 4
innodb_log_file_size = 3G
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_buffer_pool_size = 24G
innodb_buffer_pool_dump_pct = 90
innodb_max_dirty_pages_pct = 80
innodb_io_capacity = 4000
innodb_io_capacity_max = 8000
innodb_read_io_threads = 6
innodb_write_io_threads = 6
innodb_flushing_avg_loops = 100
innodb_flush_neighbors = 0
innodb_stats_on_metadata = OFF
innodb_random_read_ahead = OFF

in_predicate_conversion_threshold = 99999999
unix_socket = OFF

[safe_mysqld]
open_files_limit = 900000

[mysqldump]
quick
max_allowed_packet = 1G

[mysql]
no-auto-rehash