Latest article
Home >> Database >> A Feature Comparison of MariaDB and MySQL
A Feature Comparison of MariaDB and MySQL

A Feature Comparison of MariaDB and MySQL

ตารางเปรียบเทียบ Feature ของ MariaDB verion 5.5 & 10 และ MySQL 5.5 & 5.6

FEATURE MYSQL 5.5 MARIADB 5.5 MYSQL 5.6 MARIADB 10
Multi-source replication tick
Flexible Parallell slave replication tick
Parallel slave repliction per Schema  tick

tick 1)

Global Transaction ID (GTID)

  tick  2)

 tick
Sharding through Spider tick
Table Partitioning Improvements  tick tick
Engine Independent Statistics tick
Sub-query and join optimizations  tick  tick tick
Histogram Statistics for non-indexed columns tick
Fusion-IO optimizations  tick tick
Improved threadpool

tick 3)

 tick

tick 3)

tick
Improved Performance Schema  tick tick
Improved InnoDB Storage Engine  tick tick
TokuDB Storage Engine  tick tick
CONNECT Storage Engine tick
Sequence Storage Engine tick
Cassandra Storage Engine tick
Dynamic Columns tick
Virtual Columns  tick tick
Handlersocket interface  tick tick
memcached interface  tick
Table discovery tick
SHUTDOWN command tick
KILL QUERY ID tick
Online ALTER TABLE  tick tick
ALTER TABLE progress report  tick tick
SHOW EXPLAIN for tick
Per thread memory statistics tick
Roles tick
Audit plugin

   tick 3)

tick
PAM Plugin

tick    3)

 tick

    tick3)

tick

  1. Can be achieved by setting separate domains for each schema
  2. GTID in MySQL 5.6 is tied to a server UUID and note flexible like the one in MariaDB 10
  3. Only available in the Enterprise version not the Community Edition

Ref: MariaDB

Incoming search terms:

  • https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1826 -LTTIXbBCEhttbn216di0PsNfwLk1TI4IY9B1PsZHOhb7BaLRiY5ZC75f0rYTYMa f4dccbd23b32d2bcca0bc366bcac77b6072b81e9&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme
  • yhs-fullyhosted_003
The following two tabs change content below.
Error: Unable to create directory wp-content/uploads/2018/11. Is its parent directory writable by the server?
I'm interested in: Database: MySQL and MariaDB, WebScaleSQL, SQL Tuning, Database sharding Search engine: Elasticsearch Web: Apache tuning, web optimization and SEO Platform: log platform
Error: Unable to create directory wp-content/uploads/2018/11. Is its parent directory writable by the server?
Facebook Iconfacebook like buttonTwitter Icontwitter follow button
Copy Protected by Chetan's WP-Copyprotect.