W3cubDocs

/MariaDB

Spider Differences Between SpiderForMySQL and MariaDB

SQL Syntax

With SpiderForMySQL, the CREATE TABLE statement uses CONNECTION to define spider table variables whereas MariaDB uses COMMENT.

Features

HANDLER 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 in MariaDB
JOIN performance improvement using join_cache_level>1 and join_buffer_size in MariaDB

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/spider-differences-between-spiderformysql-and-mariadb/