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:
polarx_rpc_epoll_group_thread_deadlock_check_interval
polarx_rpc_epoll_group_thread_deadlock_check_interval
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
appliedindex_force_delay
appliedindex_force_delay
auto_savepoint
auto_savepoint
binlog_encryption
binlog_encryption
binlog_rotate_encryption_master_key_at_startup
binlog_rotate_encryption_master_key_at_startup
ccl_max_waiting_count
ccl_max_waiting_count
ccl_queue_bucket_count
ccl_queue_bucket_count
ccl_queue_bucket_size
ccl_queue_bucket_size
ccl_wait_timeout
ccl_wait_timeout
client_endpoint_ip
client_endpoint_ip
cluster_id
cluster_id
commit_pos_watcher
commit_pos_watcher
commit_pos_watcher_interval
commit_pos_watcher_interval
consensus_auto_leader_transfer
consensus_auto_leader_transfer
consensus_auto_leader_transfer_check_seconds
consensus_auto_leader_transfer_check_seconds
consensus_auto_reset_match_index
consensus_auto_reset_match_index
consensus_check_commit_index_interval
consensus_check_commit_index_interval
consensus_check_large_event
consensus_check_large_event
consensus_checksum
consensus_checksum
consensus_configure_change_timeout
consensus_configure_change_timeout
consensus_disable_election
consensus_disable_election
consensus_disable_fifo_cache
consensus_disable_fifo_cache
consensus_dynamic_easyindex
consensus_dynamic_easyindex
consensus_election_timeout
consensus_election_timeout
consensus_flow_control
consensus_flow_control
consensus_force_promote
consensus_force_promote
consensus_force_recovery
consensus_force_recovery
consensus_force_sync_epoch_diff
consensus_force_sync_epoch_diff
consensus_heartbeat_thread_cnt
consensus_heartbeat_thread_cnt
consensus_index_buf_enabled
consensus_index_buf_enabled
consensus_io_thread_cnt
consensus_io_thread_cnt
consensus_large_batch_ratio
consensus_large_batch_ratio
consensus_large_event_limit
consensus_large_event_limit
consensus_large_event_split_size
consensus_large_event_split_size
consensus_large_trx
consensus_large_trx
consensus_large_trx_split_size
consensus_large_trx_split_size
consensus_leader_stop_apply
consensus_leader_stop_apply
consensus_leader_stop_apply_time
consensus_leader_stop_apply_time
consensus_learner_heartbeat
consensus_learner_heartbeat
consensus_learner_pipelining
consensus_learner_pipelining
consensus_learner_timeout
consensus_learner_timeout
consensus_log_cache_size
consensus_log_cache_size
consensus_log_level
consensus_log_level
consensus_max_delay_index
consensus_max_delay_index
consensus_max_log_size
consensus_max_log_size
consensus_max_packet_size
consensus_max_packet_size
consensus_min_delay_index
consensus_min_delay_index
consensus_msg_compress_option
consensus_msg_compress_option
consensus_new_follower_threshold
consensus_new_follower_threshold
consensus_old_compact_mode
consensus_old_compact_mode
consensus_optimistic_heartbeat
consensus_optimistic_heartbeat
consensus_pipelining_timeout
consensus_pipelining_timeout
consensus_prefetch_cache_size
consensus_prefetch_cache_size
consensus_prefetch_fast_fetch
consensus_prefetch_fast_fetch
consensus_prefetch_wakeup_ratio
consensus_prefetch_wakeup_ratio
consensus_prefetch_window_size
consensus_prefetch_window_size
consensus_replicate_with_cache_log
consensus_replicate_with_cache_log
consensus_send_timeout
consensus_send_timeout
consensus_sync_follower_meta_interva
consensus_sync_follower_meta_interva
consensus_worker_thread_cnt
consensus_worker_thread_cnt
consensuslog_revise
consensuslog_revise
cte_max_recursion_depth
cte_max_recursion_depth
default_collation_for_utf8mb4
default_collation_for_utf8mb4
disable_wait_commitindex
disable_wait_commitindex
disabled_storage_engines
disabled_storage_engines
enable_appliedindex_checker
enable_appliedindex_checker
force_revise
force_revise
galaxyx_enable_galaxy_kill_log
galaxyx_enable_galaxy_kill_log
galaxyx_enable_galaxy_session_pool_log
galaxyx_enable_galaxy_session_pool_log
galaxyx_galaxy_worker_threads_per_tcp
galaxyx_galaxy_worker_threads_per_tcp
galaxyx_galaxy_worker_threads_shrink_time
galaxyx_galaxy_worker_threads_shrink_time
galaxyx_max_queued_messages
galaxyx_max_queued_messages
galaxyx_mtr
galaxyx_mtr
galaxyx_port
galaxyx_port
galaxyx_socket_recv_buffer
galaxyx_socket_recv_buffer
galaxyx_socket_send_buffer
galaxyx_socket_send_buffer
gcn_write_event
gcn_write_event
generated_random_password_length
generated_random_password_length
global_query_wait_timeout
global_query_wait_timeout
group_replication_consistency
group_replication_consistency
innodb_btree_sampling
innodb_btree_sampling
innodb_cleanout_disable
innodb_cleanout_disable
innodb_cleanout_max_cleans_on_page
innodb_cleanout_max_cleans_on_page
innodb_cleanout_max_scans_on_page
innodb_cleanout_max_scans_on_page
innodb_cleanout_mode
innodb_cleanout_mode
innodb_cleanout_safe_mode
innodb_cleanout_safe_mode
innodb_cleanout_write_redo
innodb_cleanout_write_redo
innodb_commit_cleanout_max_rows
innodb_commit_cleanout_max_rows
innodb_commit_seq
innodb_current_snapshot_seq
innodb_data_file_purge
innodb_data_file_purge
innodb_data_file_purge_all_at_shutdown
innodb_data_file_purge_all_at_shutdown
innodb_data_file_purge_dir
innodb_data_file_purge_dir
innodb_data_file_purge_immediate
innodb_data_file_purge_immediate
innodb_data_file_purge_interval
innodb_data_file_purge_interval
innodb_data_file_purge_max_size
innodb_data_file_purge_max_size
innodb_dedicated_server
innodb_dedicated_server
innodb_equal_gcn_visible
innodb_equal_gcn_visible
innodb_fatal_semaphore_wait_threshold
innodb_fatal_semaphore_wait_threshold
innodb_global_query_wait_timeout
innodb_global_query_wait_timeout
innodb_lizard_stat_enabled
innodb_lizard_stat_enabled
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
innodb_prepare_seq
innodb_print_data_file_purge_process
innodb_print_data_file_purge_process
innodb_rds_flashback_allow_gap
innodb_rds_flashback_allow_gap
innodb_rds_flashback_enabled
innodb_rds_flashback_enabled
innodb_sample_advise_pages
innodb_sample_advise_pages
innodb_scn_h_interval
innodb_scn_h_interval
innodb_scn_h_keep_days
innodb_scn_h_keep_days
innodb_scn_h_task_enabled
innodb_scn_h_task_enabled
innodb_snapshot_seq
innodb_snapshot_update_gcn
innodb_snapshot_update_gcn
innodb_tcn_block_cache_type
innodb_tcn_block_cache_type
innodb_tcn_cache_level
innodb_tcn_cache_level
innodb_tcn_cache_replace_after_commit
innodb_tcn_cache_replace_after_commit
innodb_transaction_group
innodb_transaction_group
innodb_txn_undo_page_reuse_max_percent
innodb_txn_undo_page_reuse_max_percent
innodb_undo_retention
innodb_undo_retention
innodb_undo_space_reserved_size
innodb_undo_space_reserved_size
innodb_undo_space_supremum_size
innodb_undo_space_supremum_size
innodb_write_non_innodb_gtids
innodb_write_non_innodb_gtids
keyring_operations
keyring_operations
mandatory_roles
mandatory_roles
new_rpc
new_rpc
only_report_warning_when_skip_sequence
only_report_warning_when_skip_sequence
opt_force_index_pct_cached
opt_force_index_pct_cached
opt_indexstat
opt_indexstat
opt_outline_enabled
opt_outline_enabled
opt_performance_point_enabled
opt_performance_point_enabled
opt_tablestat
opt_tablestat
outline_allowed_sql_digest_truncate
outline_allowed_sql_digest_truncate
outline_partitions
outline_partitions
partial_revokes
partial_revokes
password_require_current
password_require_current
performance_point_dbug_enabled
performance_point_dbug_enabled
performance_point_lock_rwlock_enabled
performance_point_lock_rwlock_enabled
polardbx_engine_version
polardbx_engine_version
polarx_rpc_auto_cpu_affinity
polarx_rpc_auto_cpu_affinity
polarx_rpc_enable_epoll_in_tasker
polarx_rpc_enable_epoll_in_tasker
polarx_rpc_enable_kill_log
polarx_rpc_enable_kill_log
polarx_rpc_enable_perf_hist
polarx_rpc_enable_perf_hist
polarx_rpc_enable_tasker
polarx_rpc_enable_tasker
polarx_rpc_enable_thread_pool_log
polarx_rpc_enable_thread_pool_log
polarx_rpc_epoll_events_per_thread
polarx_rpc_epoll_events_per_thread
polarx_rpc_epoll_extra_groups
polarx_rpc_epoll_extra_groups
polarx_rpc_epoll_group_ctx_refresh_time
polarx_rpc_epoll_group_ctx_refresh_time
polarx_rpc_epoll_group_dynamic_threads
polarx_rpc_epoll_group_dynamic_threads
polarx_rpc_epoll_group_dynamic_threads_shrink_time
polarx_rpc_epoll_group_dynamic_threads_shrink_time
polarx_rpc_epoll_group_tasker_extend_step
polarx_rpc_epoll_group_tasker_extend_step
polarx_rpc_epoll_group_tasker_multiply
polarx_rpc_epoll_group_tasker_multiply
polarx_rpc_epoll_group_thread_deadlock_check_interval
polarx_rpc_epoll_group_thread_deadlock_check_interval
polarx_rpc_epoll_group_thread_scale_thresh
polarx_rpc_epoll_group_thread_scale_thresh
polarx_rpc_epoll_groups
polarx_rpc_epoll_groups
polarx_rpc_epoll_threads_per_group
polarx_rpc_epoll_threads_per_group
polarx_rpc_epoll_timeout
polarx_rpc_epoll_timeout
polarx_rpc_epoll_work_queue_capacity
polarx_rpc_epoll_work_queue_capacity
polarx_rpc_force_all_cores
polarx_rpc_force_all_cores
polarx_rpc_galaxy_protocol
polarx_rpc_galaxy_protocol
polarx_rpc_galaxy_version
polarx_rpc_galaxy_version
polarx_rpc_max_allowed_packet
polarx_rpc_max_allowed_packet
polarx_rpc_max_cached_output_buffer_pages
polarx_rpc_max_cached_output_buffer_pages
polarx_rpc_max_epoll_wait_total_threads
polarx_rpc_max_epoll_wait_total_threads
polarx_rpc_max_queued_messages
polarx_rpc_max_queued_messages
polarx_rpc_mcs_spin_cnt
polarx_rpc_mcs_spin_cnt
polarx_rpc_min_auto_epoll_groups
polarx_rpc_min_auto_epoll_groups
polarx_rpc_multi_affinity_in_group
polarx_rpc_multi_affinity_in_group
polarx_rpc_net_write_timeout
polarx_rpc_net_write_timeout
polarx_rpc_request_cache_instances
polarx_rpc_request_cache_instances
polarx_rpc_request_cache_max_length
polarx_rpc_request_cache_max_length
polarx_rpc_request_cache_number
polarx_rpc_request_cache_number
polarx_rpc_session_poll_rwlock_spin_cnt
polarx_rpc_session_poll_rwlock_spin_cnt
polarx_rpc_shared_session_lifetime
polarx_rpc_shared_session_lifetime
polarx_rpc_tcp_fixed_dealing_buf
polarx_rpc_tcp_fixed_dealing_buf
polarx_rpc_tcp_keep_alive
polarx_rpc_tcp_keep_alive
polarx_rpc_tcp_listen_queue
polarx_rpc_tcp_listen_queue
polarx_rpc_tcp_recv_buf
polarx_rpc_tcp_recv_buf
polarx_rpc_tcp_send_buf
polarx_rpc_tcp_send_buf
print_gtid_info_during_recovery
print_gtid_info_during_recovery
rds_audit_log_buffer_size
rds_audit_log_buffer_size
rds_audit_log_connection_policy
rds_audit_log_connection_policy
rds_audit_log_dir
rds_audit_log_dir
rds_audit_log_enabled
rds_audit_log_enabled
rds_audit_log_event_buffer_size
rds_audit_log_event_buffer_size
rds_audit_log_flush
rds_audit_log_flush
rds_audit_log_format
rds_audit_log_format
rds_audit_log_policy
rds_audit_log_policy
rds_audit_log_row_limit
rds_audit_log_row_limit
rds_audit_log_skip
rds_audit_log_skip
rds_audit_log_statement_policy
rds_audit_log_statement_policy
rds_audit_log_strategy
rds_audit_log_strategy
rds_audit_log_version
rds_audit_log_version
rds_version
rds_version
read_lsn
read_lsn
recovery_apply_binlog
recovery_apply_binlog
recovery_apply_binlog_skip_counter
recovery_apply_binlog_skip_counter
recycle_bin
recycle_bin
recycle_bin_retention
recycle_bin_retention
recycle_scheduler
recycle_scheduler
recycle_scheduler_interval
recycle_scheduler_interval
recycle_scheduler_purge_table_print
recycle_scheduler_purge_table_print
regexp_stack_limit
regexp_stack_limit
regexp_time_limit
regexp_time_limit
replica_read_timeout
replica_read_timeout
reset_consensus_prefetch_cache
reset_consensus_prefetch_cache
resultset_metadata
rotate_log_table
rotate_log_table_last_name
rotate_log_table_last_name
rpc_port
rpc_port
sequence_read_skip_cache
session_track_index
session_track_index
sql_require_primary_key
sql_require_primary_key
temptable_use_mmap
temptable_use_mmap
thread_stack_warning
thread_stack_warning
tls_ciphersuites
tls_ciphersuites
tls_version
tls_version
use_secondary_engine
weak_consensus_mode
weak_consensus_mode
drop table t1;
drop table t2;