Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Explore Spider-related tables within the mysql database. These system tables store crucial configuration and metadata for the Spider storage engine, essential for distributed deployments.
This table logs failures when attempting to establish connections to remote Spider links, helping to diagnose network or configuration issues.
The mysql.spider_link_failed_log table is installed by the Spider storage engine.
This table uses the Aria storage engine.
It contains the following fields:
This page is licensed: CC BY-SA / Gnu FDL
The mysql.spider_table_crd table stores cardinality statistics for Spider tables, which the optimizer uses to create efficient query plans.
The mysql.spider_table_crd table is installed by the .
This table uses the storage engine.
It contains the following fields:
char(64)
NO
PRI
table_name
char(199)
NO
PRI
key_seq
int(10) unsigned
NO
PRI
0
cardinality
bigint(20)
NO
0
This page is licensed: CC BY-SA / Gnu FDL
db_name
db_name
char(64)
NO
table_name
char(199)
NO
link_id
char(64)
NO
failed_time
timestamp
NO
current_timestamp()
This table defines the remote servers used for link monitoring in the Spider storage engine, ensuring high availability and failover handling.
The mysql.spider_link_mon_servers table is installed by the Spider storage engine.
This table uses the Aria storage engine.
It contains the following fields:
This page is licensed: CC BY-SA / Gnu FDL
db_name
char(64)
NO
PRI
table_name
char(199)
NO
PRI
link_id
char(64)
NO
PRI
sid
int(10) unsigned
NO
PRI
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
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
This table records XA transaction positions for Spider tables, essential for recovering distributed transactions after a crash.
The mysql.spider_table_position_for_recovery table is installed by the Spider storage engine.
This table uses the Aria storage engine.
It contains the following fields:
This page is licensed: CC BY-SA / Gnu FDL
The mysql.spider_xa table tracks the status of XA transactions involving Spider tables, ensuring atomicity across distributed nodes.
The mysql.spider_xa table is installed by the .
This table uses the storage engine.
It contains the following fields:
db_name
char(64)
NO
PRI
table_name
char(199)
NO
PRI
failed_link_id
int(11)
NO
PRI
0
source_link_id
int(11)
NO
PRI
0
file
text
YES
NULL
position
text
YES
NULL
gtid
text
YES
NULL
NO
PRI
0
gtrid_length
int(11)
NO
PRI
0
bqual_length
int(11)
NO
0
data
binary(128)
NO
PRI
status
char(8)
NO
MUL
This page is licensed: CC BY-SA / Gnu FDL
format_id
int(11)
The mysql.spider_xa_member table lists the member nodes participating in a distributed XA transaction managed by the Spider engine.
The mysql.spider_xa_member table is installed by the Spider storage engine.
This table uses the Aria storage engine.
It contains the following fields:
This page is licensed: CC BY-SA / Gnu FDL
The mysql.spider_table_sts table holds statistics such as row counts and data length for Spider tables, supporting the optimizer.
The mysql.spider_table_sts table is installed by the Spider storage engine.
This table uses the Aria storage engine.
It contains the following fields:
This page is licensed: CC BY-SA / Gnu FDL
This table logs details of failed XA transactions in the Spider storage engine, providing a record for troubleshooting distributed transaction errors.
The mysql.spider_xa_failed_log table is installed by the .
This table uses the storage engine.
It contains the following fields:
format_id
int(11)
NO
0
gtrid_length
int(11)
NO
0
bqual_length
int(11)
NO
0
data
binary(128)
NO
MUL
scheme
char(64)
NO
host
char(64)
NO
port
char(5)
NO
socket
text
NO
NULL
username
char(64)
NO
password
char(64)
NO
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
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
db_name
char(64)
NO
PRI
table_name
char(199)
NO
PRI
data_file_length
bigint(20) unsigned
NO
0
max_data_file_length
bigint(20) unsigned
NO
0
index_file_length
bigint(20) unsigned
NO
0
records
bigint(20) unsigned
NO
0
mean_rec_length
bigint(20) unsigned
NO
0
check_time
datetime
NO
0000-00-00 00:00:00
create_time
datetime
NO
0000-00-00 00:00:00
update_time
datetime
NO
0000-00-00 00:00:00
checksum
bigint(20) unsigned
YES
NULL
int(11)
NO
0
gtrid_length
int(11)
NO
0
bqual_length
int(11)
NO
0
data
binary(128)
NO
MUL
scheme
char(64)
NO
host
char(64)
NO
port
char(5)
NO
socket
text
NO
NULL
username
char(64)
NO
password
char(64)
NO
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
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
thread_id
int(11)
YES
NULL
status
char(8)
NO
failed_time
timestamp
NO
current_timestamp()
This page is licensed: CC BY-SA / Gnu FDL
format_id
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:
db_name
This page is licensed: CC BY-SA / Gnu FDL
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