# Spider mysql Database Tables

- [mysql.spider\_link\_failed\_log Table](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.