# Spider mysql Database Tables

- [mysql.spider\_link\_failed\_log Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_link_failed_log-table.md): This table logs failures when attempting to establish connections to remote Spider links, helping to diagnose network or configuration issues.
- [mysql.spider\_link\_mon\_servers Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_link_mon_servers-table.md): This table defines the remote servers used for link monitoring in the Spider storage engine, ensuring high availability and failover handling.
- [mysql.spider\_table\_crd Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_table_crd-table.md): The mysql.spider\_table\_crd table stores cardinality statistics for Spider tables, which the optimizer uses to create efficient query plans.
- [mysql.spider\_table\_position\_for\_recovery Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_table_position_for_recovery-table.md): This table records XA transaction positions for Spider tables, essential for recovering distributed transactions after a crash.
- [mysql.spider\_table\_sts Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_table_sts-table.md): The mysql.spider\_table\_sts table holds statistics such as row counts and data length for Spider tables, supporting the optimizer.
- [mysql.spider\_tables Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_tables-table.md): This table stores specific parameters and metadata for Spider tables, defining how they map to remote backend tables.
- [mysql.spider\_xa Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_xa-table.md): The mysql.spider\_xa table tracks the status of XA transactions involving Spider tables, ensuring atomicity across distributed nodes.
- [mysql.spider\_xa\_failed\_log Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_xa_failed_log-table.md): This table logs details of failed XA transactions in the Spider storage engine, providing a record for troubleshooting distributed transaction errors.
- [mysql.spider\_xa\_member Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_xa_member-table.md): The mysql.spider\_xa\_member table lists the member nodes participating in a distributed XA transaction managed by the Spider engine.