Bug still not resolved for all variables.
show variables like '%spider%';
+---------------------------------------+------------+ | Variable_name | Value | +---------------------------------------+------------+ | spider_auto_increment_mode | 4294967295 | | spider_bgs_first_read | -1 | | spider_bgs_mode | 4294967295 | | spider_bgs_second_read | -1 | | spider_bka_engine | | | spider_bka_mode | 4294967295 | | spider_block_size | 16384 | | spider_bulk_size | 4294967295 | | spider_bulk_update_mode | 4294967295 | | spider_bulk_update_size | 4294967295 | | spider_conn_recycle_mode | 0 | | spider_conn_recycle_strict | 0 | | spider_connect_mutex | OFF | | spider_connect_retry_count | 1000 | | spider_connect_retry_interval | 1000 | | spider_crd_bg_mode | 4294967295 | | spider_crd_interval | 4294967295 | | spider_crd_mode | 4294967295 | | spider_crd_sync | 4294967295 | | spider_crd_type | 4294967295 | | spider_crd_weight | 4294967295 | | spider_direct_dup_insert | 4294967295 | | spider_direct_order_limit | -1 | | spider_first_read | -1 | | spider_force_commit | 0 | | spider_hs_r_conn_recycle_mode | 2 | | spider_hs_r_conn_recycle_strict | 0 | | spider_hs_w_conn_recycle_mode | 2 | | spider_hs_w_conn_recycle_strict | 0 | | spider_init_sql_alloc_size | 4294967295 | | spider_internal_limit | -1 | | spider_internal_offset | -1 | | spider_internal_optimize | 4294967295 | | spider_internal_optimize_local | 4294967295 | | spider_internal_sql_log_off | ON | | spider_internal_unlock | OFF | | spider_internal_xa | OFF | | spider_internal_xa_snapshot | 0 | | spider_local_lock_table | OFF | | spider_lock_exchange | OFF | | spider_low_mem_read | 4294967295 | | spider_max_order | 4294967295 | | spider_multi_split_read | 4294967295 | | spider_net_timeout | 4294967295 | | spider_ping_interval_at_trx_start | 3600 | | spider_quick_mode | 4294967295 | | spider_quick_page_size | -1 | | spider_read_only_mode | 4294967295 | | spider_remote_access_charset | | | spider_remote_autocommit | 4294967295 | | spider_remote_sql_log_off | 4294967295 | | spider_remote_time_zone | | | spider_remote_trx_isolation | 4294967295 | | spider_reset_sql_alloc | 4294967295 | | spider_same_server_link | OFF | | spider_second_read | -1 | | spider_select_column_mode | 4294967295 | | spider_selupd_lock_mode | 4294967295 | | spider_semi_split_read | 4294967295 | | spider_semi_split_read_limit | -1 | | spider_semi_table_lock | 1 | | spider_semi_table_lock_connection | 4294967295 | | spider_semi_trx | ON | | spider_semi_trx_isolation | 4294967295 | | spider_skip_default_condition | 4294967295 | | spider_split_read | -1 | | spider_sts_bg_mode | 4294967295 | | spider_sts_interval | 4294967295 | | spider_sts_mode | 4294967295 | | spider_sts_sync | 4294967295 | | spider_support_xa | ON | | spider_sync_autocommit | ON | | spider_sync_time_zone | OFF | | spider_sync_trx_isolation | ON | | spider_table_init_error_interval | 1 | | spider_udf_ct_bulk_insert_interval | 4294967295 | | spider_udf_ct_bulk_insert_rows | -1 | | spider_udf_ds_bulk_insert_rows | -1 | | spider_udf_ds_table_loop_mode | 4294967295 | | spider_udf_table_lock_mutex_count | 20 | | spider_udf_table_mon_mutex_count | 20 | | spider_use_all_conns_snapshot | OFF | | spider_use_consistent_snapshot | OFF | | spider_use_flash_logs | OFF | | spider_use_handler | 4294967295 | | spider_use_hs_read | 4294967295 | | spider_use_hs_write | 4294967295 | | spider_use_pushdown_udf | 4294967295 | | spider_use_snapshot_with_flush_tables | 0 | | spider_use_table_charset | 4294967295 | +---------------------------------------+------------+ 90 rows in set (0.55 sec)
Bug still not resolved for all variables.
show variables like '%spider%';
+------ ------- ------- ------- ------- -----+- ------- ----+ ------- ------- ------- ------- -----+- ------- ----+ auto_increment_ mode | 4294967295 | bgs_first_ read | -1 | bgs_second_ read | -1 | bulk_update_ mode | 4294967295 | bulk_update_ size | 4294967295 | conn_recycle_ mode | 0 | conn_recycle_ strict | 0 | connect_ mutex | OFF | connect_ retry_count | 1000 | connect_ retry_interval | 1000 | direct_ dup_insert | 4294967295 | direct_ order_limit | -1 | hs_r_conn_ recycle_ mode | 2 | hs_r_conn_ recycle_ strict | 0 | hs_w_conn_ recycle_ mode | 2 | hs_w_conn_ recycle_ strict | 0 | init_sql_ alloc_size | 4294967295 | internal_ limit | -1 | internal_ offset | -1 | internal_ optimize | 4294967295 | internal_ optimize_ local | 4294967295 | internal_ sql_log_ off | ON | internal_ unlock | OFF | internal_ xa_snapshot | 0 | local_lock_ table | OFF | lock_exchange | OFF | multi_split_ read | 4294967295 | ping_interval_ at_trx_ start | 3600 | quick_page_ size | -1 | read_only_ mode | 4294967295 | remote_ access_ charset | | remote_ autocommit | 4294967295 | remote_ sql_log_ off | 4294967295 | remote_ time_zone | | remote_ trx_isolation | 4294967295 | reset_sql_ alloc | 4294967295 | same_server_ link | OFF | select_ column_ mode | 4294967295 | selupd_ lock_mode | 4294967295 | semi_split_ read | 4294967295 | semi_split_ read_limit | -1 | semi_table_ lock | 1 | semi_table_ lock_connection | 4294967295 | semi_trx_ isolation | 4294967295 | skip_default_ condition | 4294967295 | sync_autocommit | ON | sync_time_ zone | OFF | sync_trx_ isolation | ON | table_init_ error_interval | 1 | udf_ct_ bulk_insert_ interval | 4294967295 | udf_ct_ bulk_insert_ rows | -1 | udf_ds_ bulk_insert_ rows | -1 | udf_ds_ table_loop_ mode | 4294967295 | udf_table_ lock_mutex_ count | 20 | udf_table_ mon_mutex_ count | 20 | use_all_ conns_snapshot | OFF | use_consistent_ snapshot | OFF | use_flash_ logs | OFF | use_pushdown_ udf | 4294967295 | use_snapshot_ with_flush_ tables | 0 | use_table_ charset | 4294967295 | ------- ------- ------- ------- -----+- ------- ----+
| Variable_name | Value |
+------
| spider_
| spider_
| spider_bgs_mode | 4294967295 |
| spider_
| spider_bka_engine | |
| spider_bka_mode | 4294967295 |
| spider_block_size | 16384 |
| spider_bulk_size | 4294967295 |
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_crd_bg_mode | 4294967295 |
| spider_crd_interval | 4294967295 |
| spider_crd_mode | 4294967295 |
| spider_crd_sync | 4294967295 |
| spider_crd_type | 4294967295 |
| spider_crd_weight | 4294967295 |
| spider_
| spider_
| spider_first_read | -1 |
| spider_force_commit | 0 |
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_internal_xa | OFF |
| spider_
| spider_
| spider_
| spider_low_mem_read | 4294967295 |
| spider_max_order | 4294967295 |
| spider_
| spider_net_timeout | 4294967295 |
| spider_
| spider_quick_mode | 4294967295 |
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_second_read | -1 |
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_semi_trx | ON |
| spider_
| spider_
| spider_split_read | -1 |
| spider_sts_bg_mode | 4294967295 |
| spider_sts_interval | 4294967295 |
| spider_sts_mode | 4294967295 |
| spider_sts_sync | 4294967295 |
| spider_support_xa | ON |
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_
| spider_use_handler | 4294967295 |
| spider_use_hs_read | 4294967295 |
| spider_use_hs_write | 4294967295 |
| spider_
| spider_
| spider_
+------
90 rows in set (0.55 sec)