The Ultimate Guide to High Availability with MariaDB

Spider Differences Between SpiderForMySQL and MariaDB

You are viewing an old version of this article. View the current version here.

Contents

  1. SQL Syntax
  2. Features

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

Comments

Comments loading...
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.