Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic Com_show_table_status Yes Both No Com_show_tables Yes Both No Com_show_triggers Yes Both No Com_show_variables Yes Both No Com_show_warnings Yes Both No Com_shutdown Yes Both No Com_signal Yes Both No Com_slave_start Yes Both No Com_slave_stop Yes Both No Com_stmt_close Yes Both No Com_stmt_execute Yes Both No Com_stmt_fetch Yes Both No Com_stmt_prepare Yes Both No Com_stmt_reprepare Yes Both No Com_stmt_reset Yes Both No Com_stmt_send_long_data Yes Both No Com_truncate Yes Both No Com_uninstall_component Yes Global No Com_uninstall_plugin Yes Both No Com_unlock_tables Yes Both No Com_update Yes Both No Com_update_multi Yes Both No Com_xa_commit Yes Both No Com_xa_end Yes Both No Com_xa_prepare Yes Both No Com_xa_recover Yes Both No Com_xa_rollback Yes Both No Com_xa_start Yes Both No completion_type Yes Yes Yes Both Yes Compression Yes Session No Compression_algorithm Yes Global No Compression_level Yes Global No concurrent_insert Yes Yes Yes Global Yes connect_timeout Yes Yes Yes Global Yes Connection_control_delay_generated Yes Global No connection_control_failed_connections_threshold Yes Yes Yes Global Yes connection_control_max_connection_delay Yes Yes Yes Global Yes connection_control_min_connection_delay Yes Yes Yes Global Yes 650