### This configuration was recommended by Releem. https://releem.com [mysqld] innodb_adaptive_flushing_lwm = 25.000000 ### Previous value : 25.000000 innodb_max_dirty_pages_pct = 70.000000 ### Previous value : 70.000000 innodb_autoextend_increment = 48 ### Previous value : 48 thread_stack = 524288 ### Previous value : 524288 transaction_prealloc_size = 8192 ### Previous value : 8192 thread_cache_size = 48 ### Previous value : 30 max_connections = 2880 ### Previous value : 2400 key_buffer_size = 3359637504 ### Previous value : 3359637504 max_heap_table_size = 301989888 ### Previous value : 201326592 tmp_table_size = 301989888 ### Previous value : 201326592 innodb_buffer_pool_size = 86503325696 ### Previous value : 86503325696 innodb_log_file_size = 86503325696 ### Previous value : 175762309120 innodb_buffer_pool_chunk_size = 1351614464 ### Previous value : 1351614464 join_buffer_size = 8388608 ### Previous value : 262144 table_open_cache = 512000 ### Previous value : 5000 table_definition_cache = 524288 ### Previous value : 2097152 optimizer_search_depth = 0 ### Previous value : 62 thread_pool_size = 64 ### Previous value : 64