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.
Contents
- access_balances
- active_link_count
- database
- default_file
- default_group
- host
- idx000
- internal_delayed
- link_status
- monitoring_bg_interval
- monitoring_bg_kind
- monitoring_kind
- monitoring_limit
- monitoring_server_id
- password
- port
- priority
- query_cache
- read_rate
- scan_rate
- server
- socket
- ssl_ca
- ssl_capath
- ssl_cert
- ssl_cipher
- ssl_key
- ssl_verify_server_cert
- table
access_balances
- Description: Connection load balancing integer weight.
- Default Table Value:
0
- DSN Parameter Name:
abl
active_link_count
- 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 isnone
. - 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 bySHOW CREATE TABLE
.000
is PRIMARY KEY. For example,idx000 "force index(PRIMARY)"
, or the abbreviation.
f
force indexu
use indexig
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
link_status
- 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 monitoring1
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.
0
No option passed.1
sql_cache option is passed.2
sql_no_cache option is passed.
- 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.