Spider Server System Variables

The following variables are available when the Spider storage engine has been installed.

See Server System Variables for a complete list of system variables and instructions on setting them.

spider_auto_increment_mode

• Description: The auto increment mode.
  • -1 The table parameter is adopted.
  • 0 Normal mode. Uses a count that Spider gets from the remote server with an exclusive lock for the auto increment value. Slow. Switch to quick mode if you use Spider tables with the table partitioning feature and the auto increment column is first column of index.
  • 1 Quick mode. Uses an internal Spider count for the auto increment value. Fast, but it is possible for duplicates to occur if you update the same table from multiple Spider and self tables.
  • 2 Set zero value. Auto increment value is given by the remote server. Sets zero value even if you set a value to the auto increment column. Sets zero value after choosing an inserted partition if you use a table with the table partitioning feature.
  • 3 The auto increment value is given by the remote server, if you set an auto increment column to a null value. The auto increment value is given by the local server, if you set a zero value to the auto increment column. Rather use spider_reset_auto_increment=2 or 3 if you want to use an auto increment column on the remote server.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: 0

spider_bgs_first_read

• Description: Number of first read records when background search is used.
  • -1 The table parameter is adopted.
  • 0 Records are usually retrieved.
  • 1 or more Number of records.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: 2

spider_bgs_mode

• Description: Background search mode,
  • -1 The table parameter is adopted.
  • 0 Background search is disabled.
  • 1 Background search is used if search with no lock.
  • 2 Background search is used if search with no lock or shared lock.
  • 3 Background search is used regardless of the lock.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: 0

spider_bgs_second_read

• Description: Number of second read records when background search is used.
  • -1 The table parameter is adopted.
  • 0 Records are usually retrieved.
  • 1 or more Number of records.
• Scope: Global, Session
• Dynamic: Yes
• Default Session Value: -1
• Default Table Value: 100

spider_bka_engine

• Description: The temporary table engine when the bka_mode table parameter is 1. The table parameter default is memory.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: Memory

spider_bka_mode

• Description: The internal action for using multi_split_read=0.
  • -1 The table parameter is adopted.
  • 0 Use "union all".
  • 1 Use temporary table if it is judged acceptable.
  • 2 Same as 1. Avoiding replication delay.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: 1

spider_block_size

• Description: Pseudosize of block used in mysql. Can usually be left unchanged.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: 16384

spider_bulk_access_free

• Description: Free mode of bulk access resources.
  • -1 The table parameter is adopted.
  • 0 in reset
  • 1 in close
• Data Type: numeric
• Default Session Value: -1
• Introduced: Spider 3.0

spider_bulk_size

• Description: Size in bytes of insert query generated at bulk insert.
  • -1 The table parameter is adopted.
  • 0 or more: Size of buffer.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: 16000

spider_bulk_update_mode

• Description: Bulk update and delete mode. If spider_bgs_mode or spider_split_read are changed from their default settings, Spider treats this parameter setting as 2.
  • -1 The table parameter is adopted.
  • 0 Send "update" and "delete" statements one by one.
  • 1 Send collected multiple "update" and "delete" statements.Collected statements are sent one by one.
  • 2 Send collected multiple "update" and "delete" statements. Collected statements are sent together.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: 0

spider_bulk_update_size

• Description: Size in bytes of the "update" and "delete" query generated at bulk update.
  • -1 The table parameter is adopted.
  • 0 or more Size of buffer.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: 16000

spider_conn_recycle_mode

• Description: Connection recycle mode.
  • 0 Disconnect.
  • 1 Recycles by all sessions.
  • 2 Recycles in the same session.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: 0

spider_conn_recycle_strict

spider_connect_mutex

spider_connect_retry_count

spider_connect_retry_interval

spider_connect_timeout

spider_crd_bg_mode

spider_crd_interval

spider_crd_mode

spider_crd_sync

spider_crd_type

spider_crd_weight

spider_direct_dup_insert

spider_direct_order_limit

spider_error_read_mode

spider_error_write_mode

spider_first_read

spider_force_commit

spider_general_log

spider_init_sql_alloc_size

spider_internal_limit

spider_internal_offset

spider_internal_optimize

spider_internal_optimize_local

spider_internal_sql_log_off

spider_internal_unlock

spider_internal_xa

spider_internal_xa_snapshot

spider_local_lock_table

spider_lock_exchange

spider_log_result_errors

spider_low_mem_read

spider_max_order

spider_multi_split_read

spider_net_read_timeout

spider_net_write_timeout

spider_ping_interval_at_trx_start

spider_quick_mode

spider_quick_page_size

spider_read_only_mode

spider_remote_access_charset

spider_remote_autocommit

spider_remote_default_database

spider_remote_sql_log_off

spider_remote_time_zone

spider_remote_trx_isolation

spider_reset_sql_alloc

spider_same_server_link

spider_second_read

spider_select_column_mode

spider_selupd_lock_mode

spider_semi_split_read

spider_semi_split_read_limit

spider_semi_table_lock

spider_semi_table_lock_connection

spider_semi_trx

spider_semi_trx_isolation

spider_skip_default_condition

spider_split_read

spider_sts_bg_mode

• Description: Mode of table statistic at background. Background confirmation is enabled by default at the table level, one thread per partition is created to maintain table status. Disable when sts_interval=0, effective as default: sts_interval is 10.
  • -1 The table parameter is adopted.
  • 0 Background confirmation is disabled.
  • 1 Background confirmation is enabled.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: 1

spider_sts_interval

• Description: Time interval of table statistic. Set to 0 to always get the newest information from remote servers.
  • -1 The table parameter is adopted.
  • 1 or more Interval in second table state confirmation.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: 10

spider_sts_mode

• Description: Mode for table statistic The show command is used at the table level default.
  • -1,0 The table parameter is adopted.
  • 1 The show command is used.
  • 2 The information schema is used.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: 1

spider_sts_sync

• Description: Table statistic synchronization in partitioned table.
  • -1 The table parameter is adopted.
  • 0 No synchronization.
  • 1 Table state is synchronized when opening a table, no more synchronization later.
  • 2 Synchronization.
• Scope: Global, Session
• Dynamic: Yes
• Data Type: numeric
• Default Session Value: -1
• Default Table Value: 0

spider_support_xa

spider_sync_autocommit

spider_sync_time_zone

spider_sync_trx_isolation

spider_table_init_error_interval

spider_udf_ct_bulk_insert_interval

spider_udf_ct_bulk_insert_rows

spider_udf_ds_bulk_insert_rows

spider_udf_ds_table_loop_mode

spider_udf_ds_use_real_table

spider_udf_table_lock_mutex_count

spider_udf_table_mon_mutex_count

spider_use_all_conns_snapshot

spider_use_consistent_snapshot

spider_use_default_database

spider_use_flash_logs

spider_use_handler

spider_use_pushdown_udf

spider_use_snapshot_with_flush_tables

spider_use_table_charset