Differences between MySQL and MariaDB
Fri, 2016-04-22 08:45 —
Shinguz
max_user_connectionsCan be changed online in MySQL. Cannot be changed in MariaDB if value was set to 0.PERFORMANCE_SCHEMAis enabled in MySQL 5.6 and 5.7 by default. In MariaDB disabled by default.- Replication incompatibilities from MariaDB (Master) to MySQL (Slave)
- MariaDB 10.2.0 still contains XtraDB 5.6. So MySQL 5.7 features cannot be used.
- MariaDB 10.2 Window Functions are missing in MySQL 5.7
SHOW PROCESSLISThas additional columnProgressin MariaDB.- Progress indication in:
mysqldump --progress-reports(default on) for MariaDB. - MariaDB 10.0 on CentOS 7 uses still SysV init script. MySQL 5.6 on CentOS 7 uses SystemD init script.
binlog_row_imageis implemented in MySQL 5.6 and does not exist in MariaDB 10.0.- MariaDB 10.1 and older (containing XtraDB 5.6) does not provide flexible/general tablespaces yet which where introduced by MySQL 5.7.
EXPLAIN FOR CONNCECTIONdoes exist in MySQL 5.7 and does not exist in MariaDB 10.1 or 10.2.
Other sources
tags:

