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/