Skip to content

Latest commit

 

History

History
13 lines (9 loc) · 940 Bytes

README.md

File metadata and controls

13 lines (9 loc) · 940 Bytes
Raw

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