1select @@global.binlog_optimize_thread_scheduling; 2@@global.binlog_optimize_thread_scheduling 31 4select @@session.binlog_optimize_thread_scheduling; 5ERROR HY000: Variable 'binlog_optimize_thread_scheduling' is a GLOBAL variable 6show global variables like 'binlog_optimize_thread_scheduling'; 7Variable_name Value 8binlog_optimize_thread_scheduling ON 9show session variables like 'binlog_optimize_thread_scheduling'; 10Variable_name Value 11binlog_optimize_thread_scheduling ON 12select * from information_schema.global_variables where variable_name='binlog_optimize_thread_scheduling'; 13VARIABLE_NAME VARIABLE_VALUE 14BINLOG_OPTIMIZE_THREAD_SCHEDULING ON 15select * from information_schema.session_variables where variable_name='binlog_optimize_thread_scheduling'; 16VARIABLE_NAME VARIABLE_VALUE 17BINLOG_OPTIMIZE_THREAD_SCHEDULING ON 18set global binlog_optimize_thread_scheduling=1; 19ERROR HY000: Variable 'binlog_optimize_thread_scheduling' is a read only variable 20set session binlog_optimize_thread_scheduling=1; 21ERROR HY000: Variable 'binlog_optimize_thread_scheduling' is a read only variable 22