create table t1 (test_name text); create table t2 (variable_name text); load data infile "MYSQLTEST_VARDIR/tmp/sys_vars.all_vars.txt" into table t1; insert into t2 select variable_name from performance_schema.global_variables; insert into t2 select variable_name from performance_schema.session_variables; update t2 set variable_name= replace(variable_name, "performance_schema_", "pfs_"); update t2 set variable_name= replace(variable_name, "_history_long_", "_hl_"); update t2 set variable_name= replace(variable_name, "_history_", "_h_"); update t2 set variable_name= replace(variable_name, "_throttle_queries_not_using_indexes", "_throttle_qni"); update t2 set variable_name= replace(variable_name, "lock_order_", "lo_"); select variable_name as `There should be *no* long test name listed below:` from t2 where length(variable_name) > 50; There should be *no* long test name listed below: select variable_name as `There should be *no* variables listed below:` from t2 left join t1 on variable_name=test_name where test_name is null ORDER BY variable_name; There should be *no* variables listed below: activate_all_roles_on_login activate_all_roles_on_login authentication_policy authentication_policy binlog_encryption binlog_encryption binlog_expire_logs_auto_purge binlog_expire_logs_auto_purge binlog_rotate_encryption_master_key_at_startup binlog_rotate_encryption_master_key_at_startup cte_max_recursion_depth cte_max_recursion_depth default_collation_for_utf8mb4 default_collation_for_utf8mb4 disabled_storage_engines disabled_storage_engines explain_format explain_format generated_random_password_length generated_random_password_length group_replication_consistency group_replication_consistency init_replica init_replica init_slave init_slave innodb_dedicated_server innodb_dedicated_server innodb_log_spin_cpu_abs_lwm innodb_log_spin_cpu_abs_lwm innodb_log_spin_cpu_pct_hwm innodb_log_spin_cpu_pct_hwm innodb_log_wait_for_flush_spin_hwm innodb_log_wait_for_flush_spin_hwm keyring_operations keyring_operations log_replica_updates log_replica_updates log_slave_updates log_slave_updates log_slow_replica_statements log_slow_replica_statements log_slow_slave_statements log_slow_slave_statements mandatory_roles mandatory_roles master_verify_checksum master_verify_checksum max_length_for_sort_data max_length_for_sort_data optimizer_max_subgraph_pairs optimizer_max_subgraph_pairs partial_revokes partial_revokes password_require_current password_require_current pseudo_slave_mode regexp_stack_limit regexp_stack_limit regexp_time_limit regexp_time_limit replica_allow_batching replica_allow_batching replica_checkpoint_group replica_checkpoint_group replica_checkpoint_period replica_checkpoint_period replica_compressed_protocol replica_compressed_protocol replica_exec_mode replica_exec_mode replica_load_tmpdir replica_load_tmpdir replica_max_allowed_packet replica_max_allowed_packet replica_net_timeout replica_net_timeout replica_parallel_type replica_parallel_type replica_parallel_workers replica_parallel_workers replica_pending_jobs_size_max replica_pending_jobs_size_max replica_preserve_commit_order replica_preserve_commit_order replica_skip_errors replica_skip_errors replica_sql_verify_checksum replica_sql_verify_checksum replica_type_conversions replica_type_conversions replication_optimize_for_static_plugin_config replication_optimize_for_static_plugin_config replication_sender_observe_commit_only replication_sender_observe_commit_only resultset_metadata rpl_stop_replica_timeout rpl_stop_replica_timeout rpl_stop_slave_timeout rpl_stop_slave_timeout select_into_buffer_size select_into_buffer_size select_into_disk_sync select_into_disk_sync select_into_disk_sync_delay select_into_disk_sync_delay skip_replica_start skip_replica_start skip_slave_start skip_slave_start slave_allow_batching slave_allow_batching slave_checkpoint_group slave_checkpoint_group slave_checkpoint_period slave_checkpoint_period slave_compressed_protocol slave_compressed_protocol slave_exec_mode slave_exec_mode slave_load_tmpdir slave_load_tmpdir slave_max_allowed_packet slave_max_allowed_packet slave_net_timeout slave_net_timeout slave_parallel_type slave_parallel_type slave_parallel_workers slave_parallel_workers slave_pending_jobs_size_max slave_pending_jobs_size_max slave_preserve_commit_order slave_preserve_commit_order slave_skip_errors slave_skip_errors slave_sql_verify_checksum slave_sql_verify_checksum slave_transaction_retries slave_transaction_retries slave_type_conversions slave_type_conversions sql_require_primary_key sql_require_primary_key sql_slave_skip_counter sql_slave_skip_counter statement_id sync_master_info sync_master_info temptable_max_mmap temptable_max_mmap temptable_use_mmap temptable_use_mmap terminology_use_previous terminology_use_previous tls_ciphersuites tls_ciphersuites use_secondary_engine xa_detach_on_prepare xa_detach_on_prepare drop table t1; drop table t2;