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>1andjoin_buffer_size in MariaDB

_{This page is licensed: CC BY-SA / Gnu FDL}