Spider Table System Variables

You are viewing an old version of this article. View the current version here.

The following variables are only available in the COMMENT clause of the CREATE TABLE syntax when the Spider storage engine has been installed. Global variables can be overloaded at the table level using the DSN parameter such variables are listed in Spider System Variables.

access_balances

  • Description: Connection load balancing integer weight.
  • Default Table Value: 0
  • DSN Parameter Name: abl
  • Description: Number of active backends for load balancing read connections
  • Default Table Value: all backends
  • DSN Parameter Name: alc

database

  • Description: Database name of reference table that exists in remote server.
  • Default Table Value: local table database
  • DSN Parameter Name: database

default_file

  • Description: A config file name that is referred to on connecting to a remote server. If default_group is set, the default value is --defaults-extra-file or --defaults-file. If default_group is not set, the default value is none.
  • Default Table Value: none
  • DSN Parameter Name: dff

default_group

  • Description: A group name in config file that is referred to on connecting to a remote server.
  • Default Table Value: none
  • DSN Parameter Name: dfg

host

  • Description:Host name of remote server.
  • Default Table Value: localhost
  • DSN Parameter Name: host

idx000

  • Description: When MariaDB uses an index on the Spider table for searching, Spider uses this hint for searching the remote table. The index of the remote table is related to the index of the Spider table by this hint. The number represented by 000 is the index id, the number of the index shown by SHOW CREATE TABLE. 000 is PRIMARY KEY. For example, idx000 "force index(PRIMARY)", or the abbreviation idx000 "f PRIMARY".
    • f force index
    • u use index
    • ig ignore index
  • Default Table Value: none

internal_delayed

  • Description: Remote server transmission existence of delayed when insert delayed is executed in local.
    • 0 Doesn't transmit.
    • 1 Transmits.
  • Default Table Value: 0
  • DSN Parameter Name: idl
  • Description: Change status of the remote backend server link.
    • 0 No change to the status.
    • 1 Set OK status.
    • 2 Set RECOVERY status.
    • 3 Set no more in group communication status .
  • Default Table Value: 0
  • DSN Parameter Name: lst

monitoring_bg_interval

  • Description: Interval of background monitoring in microseconds.
  • Default Table Value: 10000000
  • DSN Parameter Name: mbi

monitoring_bg_kind

  • Description: The kind of background monitoring.
    • 0 No monitoring.
    • 1 Connection state is monitored.
    • 2 State of a table without WHERE clause is monitored.
    • 3 State of a table with WHERE clause monitored (currently unsupported).
  • Default Table Value: 0
  • DSN Parameter Name: mbk

monitoring_kind

  • Description: The kind of monitoring.
    • 0 No monitoring
    • 1 Connection state is monitored.
    • 2 State of a table without WHERE clause is monitored.
    • 3 State of a table with WHERE clause monitored (currently unsupported).
  • Default Table Value: 0
  • DSN Parameter Name: mkd

monitoring_limit

  • Description: The limit to the number of records in the monitoring table. Only effective when monitoring_kind is greater than 1.
  • Default Table Value: 1
  • Range: 0 upwards
  • DSN Parameter Name: mlt

monitoring_server_id

  • Description: Define a preferred monitoring @@server_id for each backend failure. Can be used to geo localize backend servers and the first spider monitor node to contact for failover. In case of failure of this monitor, other monitor nodes are contacted. For multiple copy backends a lazy configuration can be set with a single msi instead of one per backend.
  • Default Table Value: server_id
  • DSN Parameter Name: msi

password

  • Description: Remote server password.
  • Default Table Value: none
  • DSN Parameter Name: password

port

  • Description: Remote server port.
  • Default Table Value: 3306
  • DSN Parameter Name: port

priority

  • Description: Priority. The order of execution, for example, locking tables on a remote server, is decided by this.
  • Default Table Value: 1000000
  • DSN Parameter Name: prt

query_cache

  • Description: Passes the option for the query cache when a SELECT is issued to the remote server.
  • Default Table Value: 0
  • DSN Parameter Name: qch

read_rate

  • Description: Calculation rate to calculate the time required when index scanning is executed.
  • Default Table Value: 0.0002
  • DSN Parameter Name: rrt

scan_rate

  • Description: Calculation rate to calculate the time required when table scanning is executed.
  • Default Table Value: 0.0001
  • DSN Parameter Name: srt

server

  • Description: Server name when connection information generated with CREATE SERVER is used.
  • Default Table Value: none
  • DSN Parameter Name: srv

socket

  • Description: Remote server socket.
  • Default Table Value: none
  • DSN Parameter Name: socket

ssl_ca

  • Description: The path name to the certificate authority file.
  • Default Table Value: none
  • DSN Parameter Name: sca

ssl_capath

  • Description: The path name to a directory that contains trusted SSL CA certificates in pem format.
  • Default Table Value: none
  • DSN Parameter Name: scp

ssl_cert

  • Description: The path name to the certificate file.
  • Default Table Value: none
  • DSN Parameter Name: scr

ssl_cipher

  • Description: A list of allowable ciphers to use for SSL encryption.
  • Default Table Value: none
  • DSN Parameter Name: sch

ssl_key

  • Description: The path name to the key file.
  • Default Table Value: none
  • DSN Parameter Name: sky

ssl_verify_server_cert

  • Description: Enable or disable verification of the server's Common Name value in its certificate against the host name used when connecting to the server.
    • 0 Disable verification.
    • 1 Enable verification.
  • Default Table Value: 0
  • DSN Parameter Name: svc

table

  • Description: Destination table name.
  • Default Table Value: Same table name
  • DSN Parameter Name: tbl

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.