Server System Variable Reference 704 Name Cmd-Line Option File System Var Var Scope Dynamic lower_case_file_system Yes Global No lower_case_table_names Yes Yes Yes Global No mandatory_roles Yes Yes Yes Global Yes master_info_repository Yes Yes Yes Global Yes master_verify_checksum Yes Yes Yes Global Yes max_allowed_packet Yes Yes Yes Both Yes max_binlog_cache_size Yes Yes Yes Global Yes max_binlog_size Yes Yes Yes Global Yes max_binlog_stmt_cache_size Yes Yes Yes Global Yes max_connect_errors Yes Yes Yes Global Yes max_connections Yes Yes Yes Global Yes max_delayed_threads Yes Yes Yes Both Yes max_digest_length Yes Yes Yes Global No max_error_count Yes Yes Yes Both Yes max_execution_time Yes Yes Yes Both Yes max_heap_table_size Yes Yes Yes Both Yes max_insert_delayed_threads Yes Both Yes max_join_size Yes Yes Yes Both Yes max_length_for_sort_data Yes Yes Yes Both Yes max_points_in_geometry Yes Yes Yes Both Yes max_prepared_stmt_count Yes Yes Yes Global Yes max_relay_log_size Yes Yes Yes Global Yes max_seeks_for_key Yes Yes Yes Both Yes max_sort_length Yes Yes Yes Both Yes max_sp_recursion_depth Yes Yes Yes Both Yes max_user_connections Yes Yes Yes Both Yes max_write_lock_count Yes Yes Yes Global Yes mecab_rc_file Yes Yes Yes Global No metadata_locks_cache_size Yes Yes Yes Global No metadata_locks_hash_instances Yes Yes Yes Global No min_examined_row_limit Yes Yes Yes Both Yes myisam_data_pointer_size Yes Yes Yes Global Yes myisam_max_sort_file_size Yes Yes Yes Global Yes myisam_mmap_size Yes Yes Yes Global No myisam_recover_options Yes Yes Yes Global No myisam_repair_threads Yes Yes Yes Both Yes myisam_sort_buffer_size Yes Yes Yes Both Yes myisam_stats_method Yes Yes Yes Both Yes