### This configuration was recommended by Releem. https://releem.com [mysqld] thread_cache_size = 192 ### Previous value : 96 key_buffer_size = 8388608 ### Previous value : 2147483648 max_heap_table_size = 612368384 ### Previous value : 404750336 tmp_table_size = 612368384 ### Previous value : 404750336 myisam_sort_buffer_size = 8388608 ### Previous value : 134216704 join_buffer_size = 8388608 ### Previous value : 8388608 table_open_cache = 51200 ### Previous value : 51200 table_definition_cache = 524288 ### Previous value : 2097152 innodb_buffer_pool_size = 86503325696 ### Previous value : 107803049984 optimizer_search_depth = 0 ### Previous value : 0 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 innodb_log_file_size = 32212254720 ### Previous value : 32212254720 thread_pool_size = 64 ### Previous value : 64 innodb_data_file_buffering = 1 ### Previous value : 1