Spider Differences Between SpiderForMySQL and MariaDB

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.