List of Variables to be set in MySQL for performance tuning

Set global thread_cache_size = 4;
Set global query_cache_size = 1024*1024*1024;
Set global query_cache_limit=768*1024;
Set global query_cache_min_res_unit = 2048;
Set long_query_time = 5;
Set global wait_timeout = 7800;
Set global key_buffer_size = 512*1024*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_cache = 1024;