Spider Differences Between SpiderForMySQL and MariaDB
Contents
SQL Syntax
- With
SpiderForMySQL
, the CREATE TABLE statement usesCONNECTION
to define spider table variables whereas MariaDB usesCOMMENT
.
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 MariaDBJOIN
performance improvement usingjoin_cache_level>1
andjoin_buffer_size
in MariaDB
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.