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 COMMENT
clause of the CREATE TABLE
syntax when the Spider storage engine has been installed.
Contents
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 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
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
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.