## GENERAL VARIABLES ##
# Leave this to 1GB, we actually popped 512
max_allowed_packet = 1024M
table_open_cache = 100000
open_files_limit = 400000
table_definition_cache = 8000
thread_cache_size = 1800
max_connections=6000
max_heap_table_size=512M
tmp_table_size=512M
concurrent_insert=2
wait_timeout = 150
interactive_timeout = 2000
group_concat_max_len = 65536
log_error_verbosity=2
event_scheduler = 'ON'
max_write_lock_count = 150
skip_external_locking=ON
connect_timeout=20
net_read_timeout=3600
net_write_timeout=3600
range_optimizer_max_mem_size = 0
eq_range_index_dive_limit=5000
skip_name_resolve=ON
## MY ISAM -- We still have a lot of MyISAM tables in the older subsystems. To retire once converted to INNO ##
symbolic-links=1
key_buffer_size = 64G
sort_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 128M
## INNODB PARAMETERS ##
innodb_buffer_pool_size=1120G
innodb_buffer_pool_instances=64
innodb_buffer_pool_chunk_size=1024M
innodb_read_io_threads=64
innodb_write_io_threads=64
optimizer_search_depth=0
innodb_log_file_size=30G
innodb_log_group_home_dir=/var/lib/mysql/
innodb_flush_log_at_trx_commit=2
innodb_flush_method = O_DIRECT
innodb_thread_concurrency=0
innodb_file_per_table=1
innodb_buffer_pool_load_at_startup=ON
innodb_buffer_pool_dump_at_shutdown=ON
innodb_log_buffer_size=1G
innodb_log_compressed_pages=OFF
innodb_concurrency_tickets=25000
innodb_lru_scan_depth=100
innodb_flushing_avg_loops=60
innodb_flush_neighbors=2
innodb_max_dirty_pages_pct_lwm=1
innodb_max_dirty_pages_pct=1
innodb_change_buffer_max_size=50
innodb_stats_on_metadata = OFF
innodb_tmpdir=/localbackup/mysql/tmp/inno/
default_storage_engine = InnoDB
innodb_io_capacity=6000
innodb_io_capacity_max=40000
innodb_stats_on_metadata=OFF
innodb_deadlock_detect=ON
innodb_print_all_deadlocks=ON
transaction-isolation = READ-UNCOMMITTED