> 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/mysql-spider_table_position_for_recovery-table.md).

# mysql.spider\_table\_position\_for\_recovery Table

The `mysql.spider_table_position_for_recovery` table is installed by the [Spider storage engine](/docs/server/server-usage/storage-engines/spider.md).

This table uses the [Aria](/docs/server/server-usage/storage-engines/aria.md) storage engine.

It contains the following fields:

| Field            | Type      | Null | Key | Default | Description |
| ---------------- | --------- | ---- | --- | ------- | ----------- |
| 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    |             |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}