For the complete documentation index, see llms.txt. Markdown versions of documentation pages are available by appending .md to page URLs.
Skip to content

Spider mysql Database Tables

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.

This table defines the remote servers used for link monitoring in the Spider storage engine, ensuring high availability and failover handling.

The mysql.spider_table_crd table stores cardinality statistics for Spider tables, which the optimizer uses to create efficient query plans.

This table records XA transaction positions for Spider tables, essential for recovering distributed transactions after a crash.

The mysql.spider_table_sts table holds statistics such as row counts and data length for Spider tables, supporting the optimizer.

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

The mysql.spider_xa table tracks the status of XA transactions involving Spider tables, ensuring atomicity across distributed nodes.

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_member table lists the member nodes participating in a distributed XA transaction managed by the Spider engine.

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

Last updated

Was this helpful?