- 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 column- Progressin 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