Spider Differences Between SpiderForMySQL and MariaDB

This page outlines the differences between the standalone SpiderForMySQL distribution and the version integrated into MariaDB Server, including version correspondence and feature availability.

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}