Skip to content

Latest commit

 

History

History

spider-differences-between-spiderformysql-and-mariadb

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 

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