This is the most important variables to be set in MySQL for performance tuning
Set global thread_cache_size = 4;
Set global query_cache_size = 102410241024;
Set global query_cache_limit=7681024; Set global query_cache_min_res_unit = 2048; Set long_query_time = 5; Set global wait_timeout = 7800; Set global key_buffer_size = 5121024*1024;
Set global table_open_cache = 800;
SET GLOBAL low_priority_updates=1;
SET GLOBAL concurrent_insert=ALWAYS;
SET GLOBAL tmp_table_size = 67108864;
SET GLOBAL max_heap_table_size = 67108864;
SET GLOBAL table_definition_cach
