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.The default value is the same name of local database name

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