Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic Select_range_check Yes Both No Select_scan Yes Both No server_id Yes Yes Yes Global Yes server_id_bits Yes Yes Yes Global No server_uuid Yes Global No session_track_gtids Yes Yes Yes Both Yes session_track_schema Yes Yes Yes Both Yes session_track_state_change Yes Yes Yes Both Yes session_track_system_variables Yes Yes Yes Both Yes session_track_transaction_info Yes Yes Yes Both Yes sha256_password_auto_generate_rsa_keys Yes Yes Yes Global No sha256_password_private_key_path Yes Yes Yes Global No sha256_password_proxy_users Yes Yes Yes Global Yes sha256_password_public_key_path Yes Yes Yes Global No shared_memory Yes Yes Yes Global No shared_memory_base_name Yes Yes Yes Global No show_create_table_skip_secondary_engine Yes Yes Yes Session Yes show_create_table_verbosity Yes Yes Yes Both Yes show_old_temporals Yes Yes Yes Both Yes show-slave- auth-info Yes Yes skip- character- set-client- handshake Yes Yes skip_external_locking Yes Yes Yes Global No skip-grant- tables Yes Yes skip-host- cache Yes Yes skip_name_resolve Yes Yes Yes Global No skip- ndbcluster Yes Yes skip_networking Yes Yes Yes Global No skip-new Yes Yes skip_show_database Yes Yes Yes Global No skip_slave_start Yes Yes Yes Global No skip-ssl Yes Yes skip-stack- trace Yes Yes 684