[MDEV-27169] Change default values of Spider plugin variables to default values of table variables - Jira

Nayuta Yanagisawa (Inactive) created issue - 2021-12-05 08:09

Nayuta Yanagisawa (Inactive) made changes - 2021-12-05 08:10

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-27106~~ [ ~~MDEV-27106~~ ]

Nayuta Yanagisawa (Inactive) made changes - 2021-12-05 09:03

Status

Open [ 1 ]

In Progress [ 3 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-12-05 10:16

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

Nayuta Yanagisawa (Inactive) made changes - 2021-12-05 10:21

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least:

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Nayuta Yanagisawa (Inactive) made changes - 2021-12-05 10:29

Summary

Change default value of Spider server variables to default value of table variables

Change default values of Spider server variables to default values of table variables

Sergei Golubchik made changes - 2021-12-06 21:22

Workflow

MariaDB v3 [ 128126 ]

MariaDB v4 [ 131856 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-12-07 09:37

Link

This issue relates to MDEV-26365 [ MDEV-26365 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-12-08 05:03

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least:

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Nayuta Yanagisawa (Inactive) made changes - 2021-12-08 05:10

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

||Variable name||Current value || New value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine||"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |

Nayuta Yanagisawa (Inactive) made changes - 2021-12-08 05:10

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

||Variable name||Current value || New value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine||"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

||Variable name||Current value || New value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |

Nayuta Yanagisawa (Inactive) made changes - 2021-12-08 05:10

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

||Variable name||Current value || New value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current value || New value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |

Nayuta Yanagisawa (Inactive) made changes - 2021-12-08 05:13

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current value || New value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|

Nayuta Yanagisawa (Inactive) made changes - 2021-12-08 05:18

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_udf_ct_bulk_insert_interval|-1|?|
|spider_udf_ct_bulk_insert_rows|-1|?|
|spider_udf_ds_bulk_insert_rows|-1|?|
|spider_udf_ds_table_loop_mode|-1|?|
|spider_udf_ds_use_real_table|-1|?|
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Nayuta Yanagisawa (Inactive) made changes - 2021-12-08 14:52

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_udf_ct_bulk_insert_interval|-1|?|
|spider_udf_ct_bulk_insert_rows|-1|?|
|spider_udf_ds_bulk_insert_rows|-1|?|
|spider_udf_ds_table_loop_mode|-1|?|
|spider_udf_ds_use_real_table|-1|?|
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6?|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_udf_ct_bulk_insert_interval|-1|?|
|spider_udf_ct_bulk_insert_rows|-1|?|
|spider_udf_ds_bulk_insert_rows|-1|?|
|spider_udf_ds_table_loop_mode|-1|?|
|spider_udf_ds_use_real_table|-1|?|
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Nayuta Yanagisawa (Inactive) made changes - 2021-12-08 14:55

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6?|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 |
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_udf_ct_bulk_insert_interval|-1|?|
|spider_udf_ct_bulk_insert_rows|-1|?|
|spider_udf_ds_bulk_insert_rows|-1|?|
|spider_udf_ds_table_loop_mode|-1|?|
|spider_udf_ds_use_real_table|-1|?|
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6?|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 ?|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_udf_ct_bulk_insert_interval|-1|?|
|spider_udf_ct_bulk_insert_rows|-1|?|
|spider_udf_ds_bulk_insert_rows|-1|?|
|spider_udf_ds_table_loop_mode|-1|?|
|spider_udf_ds_use_real_table|-1|?|
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Nayuta Yanagisawa (Inactive) made changes - 2021-12-10 04:41

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6?|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 ?|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_udf_ct_bulk_insert_interval|-1|?|
|spider_udf_ct_bulk_insert_rows|-1|?|
|spider_udf_ds_bulk_insert_rows|-1|?|
|spider_udf_ds_table_loop_mode|-1|?|
|spider_udf_ds_use_real_table|-1|?|
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6?|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 ?|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_support_xa|ON|OFF|
|spider_udf_ct_bulk_insert_interval|-1|?|
|spider_udf_ct_bulk_insert_rows|-1|?|
|spider_udf_ds_bulk_insert_rows|-1|?|
|spider_udf_ds_table_loop_mode|-1|?|
|spider_udf_ds_use_real_table|-1|?|
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Nayuta Yanagisawa (Inactive) made changes - 2021-12-11 13:28

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-12-11 13:41

Link

This issue relates to MDEV-27228 [ MDEV-27228 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-12-11 13:48

Link

This issue relates to MDEV-26365 [ MDEV-26365 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-12-11 13:49

Link

This issue is blocked by MDEV-26365 [ MDEV-26365 ]

Nayuta Yanagisawa (Inactive) made changes - 2021-12-14 10:23

Link

This issue blocks ~~MDEV-27258~~ [ ~~MDEV-27258~~ ]

Nayuta Yanagisawa (Inactive) made changes - 2021-12-17 09:26

Fix Version/s		10.9 [ 26905 ]
Fix Version/s	10.8 [ 26121 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-01-24 06:47

Link

This issue is blocked by MDEV-26365 [ MDEV-26365 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-01-24 06:47

Link

This issue is blocked by MDEV-27228 [ MDEV-27228 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-01-26 14:55

Link

This issue relates to MDEV-27228 [ MDEV-27228 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-01-26 14:56

Priority

Major [ 3 ]

Critical [ 2 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-10 13:11

Link

This issue is blocked by MDEV-27228 [ MDEV-27228 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-10 13:16

Fix Version/s		10.7 [ 24805 ]
Fix Version/s		10.8 [ 26121 ]
Fix Version/s	10.9 [ 26905 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-12 10:52

Fix Version/s		10.9 [ 26905 ]
Fix Version/s	10.7 [ 24805 ]
Fix Version/s	10.8 [ 26121 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-16 03:25

Priority

Critical [ 2 ]

Major [ 3 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-21 06:02

Priority

Major [ 3 ]

Critical [ 2 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-21 06:02

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-21 06:15

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/
* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_engine| |"memory" |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6?|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51 ?|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_support_xa|ON|OFF|
|spider_udf_ct_bulk_insert_interval|-1|?|
|spider_udf_ct_bulk_insert_rows|-1|?|
|spider_udf_ds_bulk_insert_rows|-1|?|
|spider_udf_ds_table_loop_mode|-1|?|
|spider_udf_ds_use_real_table|-1|?|
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated (new values are adopted from {{spider_set_connect_info_defaults}}):

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_support_xa|ON|OFF|
|spider_udf_ct_bulk_insert_interval|-1|?|
|spider_udf_ct_bulk_insert_rows|-1|?|
|spider_udf_ds_bulk_insert_rows|-1|?|
|spider_udf_ds_table_loop_mode|-1|?|
|spider_udf_ds_use_real_table|-1|?|
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Nayuta Yanagisawa (Inactive) made changes - 2022-02-21 06:26

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

The default table values are defined in {{spider_set_connect_info_default()}}.

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated (new values are adopted from {{spider_set_connect_info_defaults}}):

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_support_xa|ON|OFF|
|spider_udf_ct_bulk_insert_interval|-1|?|
|spider_udf_ct_bulk_insert_rows|-1|?|
|spider_udf_ds_bulk_insert_rows|-1|?|
|spider_udf_ds_table_loop_mode|-1|?|
|spider_udf_ds_use_real_table|-1|?|
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

_The default table values are defined in {{spider_set_connect_info_default()}}._

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Nayuta Yanagisawa (Inactive) added a comment - 2022-02-21 08:09 - edited

holyfoot Please review: https://github.com/MariaDB/server/commit/b5ee3fd11c4077b9a20b8432090d2e6e752f65aa

Nayuta Yanagisawa (Inactive) added a comment - 2022-02-21 08:09 - edited holyfoot Please review: https://github.com/MariaDB/server/commit/b5ee3fd11c4077b9a20b8432090d2e6e752f65aa

Nayuta Yanagisawa (Inactive) made changes - 2022-02-21 08:09

Assignee	Nayuta Yanagisawa [ JIRAUSER47117 ]	Alexey Botchkov [ holyfoot ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-02-21 08:16

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

_The default table values are defined in {{spider_set_connect_info_default()}}._

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

_The default table values are defined in {{spider_set_connect_info_default()}}._

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|split_read | -1 | 9223372036854775807LL|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Nayuta Yanagisawa (Inactive) made changes - 2022-03-02 11:25

Assignee

Alexey Botchkov [ holyfoot ]

Nayuta Yanagisawa [ JIRAUSER47117 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-03-02 11:25

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Nayuta Yanagisawa (Inactive) added a comment - 2022-03-02 11:26 - edited

I should have updated tests at least.

Nayuta Yanagisawa (Inactive) added a comment - 2022-03-02 11:26 - edited I should have updated tests at least.

Nayuta Yanagisawa (Inactive) made changes - 2022-03-02 12:26

Description

As the first step to deprecate some Spider table options, I need to change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

_The default table values are defined in {{spider_set_connect_info_default()}}._

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|split_read | -1 | 9223372036854775807LL|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

_The default table values are defined in {{spider_set_connect_info_default()}}._

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|split_read | -1 | 9223372036854775807LL|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Nayuta Yanagisawa (Inactive) made changes - 2022-03-02 12:27

Fix Version/s		10.7 [ 24805 ]
Fix Version/s		10.8 [ 26121 ]
Fix Version/s	10.9 [ 26905 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-03-02 12:29

Description

Change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values.

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

_The default table values are defined in {{spider_set_connect_info_default()}}._

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|split_read | -1 | 9223372036854775807LL|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values. Also, deprecate the option value -1 (use table value).

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

_The default table values are defined in {{spider_set_connect_info_default()}}._

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|split_read | -1 | 9223372036854775807LL|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Nayuta Yanagisawa (Inactive) made changes - 2022-03-02 12:32

Link

This issue blocks MDEV-27905 [ MDEV-27905 ]

Nayuta Yanagisawa (Inactive) added a comment - 2022-03-03 07:57 - edited

holyfoot Please review the following patch: https://github.com/MariaDB/server/commit/781741fef15b79262b69b05a5426090290ad9152

Nayuta Yanagisawa (Inactive) added a comment - 2022-03-03 07:57 - edited holyfoot Please review the following patch: https://github.com/MariaDB/server/commit/781741fef15b79262b69b05a5426090290ad9152

Nayuta Yanagisawa (Inactive) made changes - 2022-03-03 07:57

Status

Stalled [ 10000 ]

In Review [ 10002 ]

Nayuta Yanagisawa (Inactive) added a comment - 2022-03-04 05:08

I updated the patch. Sorry for repeating myself.

Nayuta Yanagisawa (Inactive) added a comment - 2022-03-04 05:08 I updated the patch. Sorry for repeating myself.

Nayuta Yanagisawa (Inactive) made changes - 2022-03-04 05:18

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-03-04 05:18

Assignee	Nayuta Yanagisawa [ JIRAUSER47117 ]	Alexey Botchkov [ holyfoot ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Alexey Botchkov added a comment - 2022-03-13 20:03

ok to push.

Alexey Botchkov added a comment - 2022-03-13 20:03 ok to push.

Alexey Botchkov made changes - 2022-03-13 20:03

Assignee	Alexey Botchkov [ holyfoot ]	Nayuta Yanagisawa [ JIRAUSER47117 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-03-14 05:22

Summary

Change default values of Spider server variables to default values of table variables

Change default values of Spider plugin variables to default values of table variables

Nayuta Yanagisawa (Inactive) made changes - 2022-03-14 05:25

Description

Change the default values of the [Spider server variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values. Also, deprecate the option value -1 (use table value).

For example, the current default server value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

_The default table values are defined in {{spider_set_connect_info_default()}}._

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the server variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|split_read | -1 | 9223372036854775807LL|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Change the default values of the [Spider plugin variables|https://mariadb.com/kb/en/spider-server-system-variables/] from -1 (use table value) to the default table values. Also, deprecate the option value -1 (use table value).

For example, the current default plugin value of {{spider_auto_increment_mode}} is -1 (use table value) and the current default table value is 0 (normal mode). Thus, the real default value is 0. I do like to remove this indirection (just set the default server value to 0).

_The default table values are defined in {{spider_set_connect_info_default()}}._

The following documents should be updated at least (MDEV-26365):

* https://mariadb.com/kb/en/spider-server-system-variables/

Here is the list of the plugin variables whose default values should be updated:

||Variable name||Current default value || New default value||
|spider_auto_increment_mode|-1|0|
|spider_bgs_first_read|-1|2 |
|spider_bgs_mode|-1|0 |
|spider_bgs_second_read|-1|100 |
|spider_bka_mode|-1|1 |
|spider_bka_table_name_type|-1|0|
|spider_buffer_size|-1|16000 |
|spider_bulk_size|-1|16000 |
|spider_bulk_update_mode|-1|0|
|spider_bulk_update_size|-1|16000|
|spider_casual_read|-1|0 |
|spider_connect_timeout|-1|6|
|spider_crd_bg_mode|-1|2 |
|spider_crd_interval|-1|51|
|spider_crd_mode|-1|1 |
|spider_crd_sync|-1|0 |
|spider_crd_type|-1|2 |
|spider_crd_weight|-1|2 |
|spider_delete_all_rows_type|-1|1|
|spider_direct_dup_insert|-1|0|
|spider_direct_order_limit|-1|9223372036854775807LL|
|spider_error_read_mode|-1|0|
|spider_error_write_mode|-1|0|
|spider_first_read|-1|0 |
|spider_init_sql_alloc_size|-1|1024 |
|spider_internal_limit|-1|9223372036854775807LL|
|spider_internal_offset|-1|0 |
|spider_internal_optimize|-1|0 |
|spider_internal_optimize_local|-1|0 |
|spider_load_crd_at_startup |-1| 1|
|spider_load_sts_at_startup |-1| 1|
|spider_low_mem_read |-1| 1|
|spider_max_order|-1|32767 |
|spider_multi_split_read|-1|100|
|spider_net_read_timeout|-1|600|
|spider_net_write_timeout|-1|600|
|spider_quick_mode|-1|3 |
|spider_quick_page_byte|-1|10485760|
|spider_quick_page_size|-1|1024|
|spider_read_only_mode|-1|0 |
|spider_reset_sql_alloc|-1|1 |
|spider_second_read|-1|0 |
|spider_select_column_mode|-1|1|
|spider_selupd_lock_mode|-1|1 |
|spider_semi_split_read|-1|2 |
|spider_semi_split_read_limit|-1|9223372036854775807LL|
|spider_semi_table_lock_connection|-1|1|
|spider_skip_default_condition|-1|0|
|spider_skip_parallel_search|-1|0|
|split_read | -1 | 9223372036854775807LL|
|spider_store_last_crd|-1|1 |
|spider_store_last_sts|-1|1 |
|spider_strict_group_by|-1|1 |
|spider_sts_bg_mode|-1|2 |
|spider_sts_interval|-1|10 |
|spider_sts_mode|-1|1 |
|spider_sts_sync|-1|0 |
|spider_use_handler|-1|0 |
|spider_use_table_charset|-1|1 |

Nayuta Yanagisawa (Inactive) made changes - 2022-03-14 06:02

Fix Version/s		10.7.4 [ 27504 ]
Fix Version/s		10.8.3 [ 27502 ]
Fix Version/s	10.7 [ 24805 ]
Fix Version/s	10.8 [ 26121 ]
Resolution		Done [ 10200 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Yuchen Pei made changes - 2023-06-22 06:01

Link

This issue causes ~~MDEV-31524~~ [ ~~MDEV-31524~~ ]

MariaDB Server

Change default values of Spider plugin variables to default values of table variables

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration

Variable name	Current default value	New default value
spider_auto_increment_mode	-1	0
spider_bgs_first_read	-1	2
spider_bgs_mode	-1	0
spider_bgs_second_read	-1	100
spider_bka_mode	-1	1
spider_bka_table_name_type	-1	0
spider_buffer_size	-1	16000
spider_bulk_size	-1	16000
spider_bulk_update_mode	-1	0
spider_bulk_update_size	-1	16000
spider_casual_read	-1	0
spider_connect_timeout	-1	6
spider_crd_bg_mode	-1	2
spider_crd_interval	-1	51
spider_crd_mode	-1	1
spider_crd_sync	-1	0
spider_crd_type	-1	2
spider_crd_weight	-1	2
spider_delete_all_rows_type	-1	1
spider_direct_dup_insert	-1	0
spider_direct_order_limit	-1	9223372036854775807LL
spider_error_read_mode	-1	0
spider_error_write_mode	-1	0
spider_first_read	-1	0
spider_init_sql_alloc_size	-1	1024
spider_internal_limit	-1	9223372036854775807LL
spider_internal_offset	-1	0
spider_internal_optimize	-1	0
spider_internal_optimize_local	-1	0
spider_load_crd_at_startup	-1	1
spider_load_sts_at_startup	-1	1
spider_low_mem_read	-1	1
spider_max_order	-1	32767
spider_multi_split_read	-1	100
spider_net_read_timeout	-1	600
spider_net_write_timeout	-1	600
spider_quick_mode	-1	3
spider_quick_page_byte	-1	10485760
spider_quick_page_size	-1	1024
spider_read_only_mode	-1	0