mysql.spider_tables Table

This table stores specific parameters and metadata for Spider tables, defining how they map to remote backend tables.

The mysql.spider_tables table is installed by the Spider storage engine.

This table uses the Aria storage engine.

It contains the following fields:

Field	Type	Null	Key	Default	Description
db_name	char(64)	NO	PRI
table_name	char(199)	NO	PRI
link_id	int(11)	NO	PRI	0
priority	bigint(20)	NO	MUL	0
server	char(64)	YES		NULL
scheme	char(64)	YES		NULL
host	char(64)	YES		NULL
port	char(5)	YES		NULL
socket	text	YES		NULL
username	char(64)	YES		NULL
password	char(64)	YES		NULL
ssl_ca	text	YES		NULL
ssl_capath	text	YES		NULL
ssl_cert	text	YES		NULL
ssl_cipher	char(64)	YES		NULL
ssl_key	text	YES		NULL
ssl_verify_server_cert	tinyint(4)	NO		0
monitoring_binlog_pos_at_failing	tinyint(4)	NO		0
default_file	text	YES		NULL
default_group	char(64)	YES		NULL
dsn	char(64)	YES		NULL
filedsn	text	YES		NULL
driver	char(64)	YES		NULL
tgt_db_name	char(64)	YES		NULL
tgt_table_name	char(64)	YES		NULL
link_status	tinyint(4)	NO		1
block_status	tinyint(4)	NO		0
static_link_id	char(64)	YES		NULL

_{This page is licensed: CC BY-SA / Gnu FDL}