> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables.md).

# Spider mysql Database Tables

{% columns %}
{% column %}
{% content-ref url="/pages/RM9NjX1J9qeykhyXxN3h" %}
[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)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This table logs failures when attempting to establish connections to remote Spider links, helping to diagnose network or configuration issues.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/AIbdz2VtfBxWmaxdurZX" %}
[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)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This table defines the remote servers used for link monitoring in the Spider storage engine, ensuring high availability and failover handling.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/vqLDnCAOgxXm2c947weO" %}
[mysql.spider\_table\_crd Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_table_crd-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.spider\_table\_crd table stores cardinality statistics for Spider tables, which the optimizer uses to create efficient query plans.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/zCR0mPVams8kEcbTGQCq" %}
[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)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This table records XA transaction positions for Spider tables, essential for recovering distributed transactions after a crash.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/1YCLkptaMN9rC5iv2nwi" %}
[mysql.spider\_table\_sts Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_table_sts-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.spider\_table\_sts table holds statistics such as row counts and data length for Spider tables, supporting the optimizer.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/RiodJkVld9lSfN4tZOsQ" %}
[mysql.spider\_tables Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_tables-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This table stores specific parameters and metadata for Spider tables, defining how they map to remote backend tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/WLAq3GeKtqwKTXrm5Ke7" %}
[mysql.spider\_xa Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_xa-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.spider\_xa table tracks the status of XA transactions involving Spider tables, ensuring atomicity across distributed nodes.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/NUcijcV8YhGPIbSwWWEH" %}
[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)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This table logs details of failed XA transactions in the Spider storage engine, providing a record for troubleshooting distributed transaction errors.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/6SKXBHtspPuhiYlhLJAW" %}
[mysql.spider\_xa\_member Table](/docs/server/reference/system-tables/the-mysql-database-tables/spider-mysql-database-tables/mysql-spider_xa_member-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The mysql.spider\_xa\_member table lists the member nodes participating in a distributed XA transaction managed by the Spider engine.
{% endcolumn %}
{% endcolumns %}