Spider Table System Variables

The following variables are only available in COMMENT clause of the CREATE TABLE syntax when the Spider storage engine has been installed.

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 at connecting to 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 at connecting to 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 MySQL use index on the Spider table for searching, Spider use this hint for searching remote table. Index of remote table is related to index of the Spider table by this hint. "000" is index id. index id is number of the index that at "show create table". "000" is PRIMARY KEY. You can use this parameter like 'idx000 "force index(PRIMARY)"'. And this hint can use following abbreviation. like '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 It doesn't transmit.
  • 1 It transmits.
• Default Table Value: 0
• DSN Parameter Name: idl

link_status

• Description: Change status of the remote backend server link.
  • 0 No change 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.(microsecond)
• Default Table Value: 10000000
• DSN Parameter Name: mbi

monitoring_bg_kind

• Description: The kind of background monitoring.
  • 0 It doesn't monitor.
  • 1 It monitors state of connection.
  • 2 It monitors state of a table without where clause.
  • 3 It monitors state of a table with where clause.(not supported yet)
• Default Table Value: 0
• DSN Parameter Name: mbk

monitoring_kind

• Description: The kind of monitoring.
  • 0 It doesn't monitor.
  • 1 It monitors state of connection.
  • 2 It monitors state of a table without where clause.
  • 3 It monitors state of a table with where clause.(not supported yet)
• Default Table Value: 0
• DSN Parameter Name: mkd

monitoring_limit

• Description: The limititation of records at monitoring table. (Only when monitoring_kind is bigger than 1, it is effective.) 0 or more : Number of limitation.
• Default Table Value: 1
• DSN Parameter Name: mlt

monitoring_server_id

• Description:* The server_id of monitoring MySQL server.
• Default Table Value: server_id
• DSN Parameter Name: msi

password

• Description: Password of remote server.
• Default Table Value: none
• DSN Parameter Name: password

port

• Description: Port of remote server.
• Default Table Value: 3306
• DSN Parameter Name: port

priority

• Description: Priority. The order of execution such as lock tables to a remote server is decided by this.
• Default Table Value: 1000000
• DSN Parameter Name: prt

query_cache

• Description: Giving option for query cache when SQL(SELECT) is issued to remote server.
  • 0 It doesn't give it.
  • 1 The sql_cache is given.
  • 2 The sql_no_cache is given.
• 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

Socket of remote server.

• 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