> 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/server-usage/storage-engines/spider/spider-differences-between-spiderformysql-and-mariadb.md).

# Spider Differences Between SpiderForMySQL and MariaDB

### SQL Syntax

* With `SpiderForMySQL`, the [CREATE TABLE](/docs/server/server-usage/tables/create-table.md) statement uses `CONNECTION` to define spider table variables whereas MariaDB uses `COMMENT`.

### Features

* [HANDLER](/docs/server/reference/sql-structure/nosql/handler.md) can not be translated to SQL in MariaDB
* Concurrent background search is not yet implemented in MariaDB
* Vertical partitioning storage engine VP is not implemented in MariaDB
* `CREATE TABLE` can use [table discovery](/docs/server/reference/product-development/plugin-development/storage-engines-storage-engine-development/table-discovery.md) in MariaDB
* [JOIN](/docs/server/reference/sql-statements/data-manipulation/selecting-data/joins/join-syntax.md) performance improvement using [join\_cache\_level](/docs/server/server-management/variables-and-modes/server-system-variables.md#join_cache_level)>1`and`[join\_buffer\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#join_buffer_size) in MariaDB

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

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