| Возможности |
MariaDB 5.5 |
MariaDB 10.0 |
MySQL 5.5 |
MySQL 5.6 |
| Disk access optimizations |
| Index Condition Pushdown (ICP) |
Да |
Да |
- |
Да |
| Disk-sweep Multi-range read (DS-MRR) |
Да |
Да |
- |
Да |
| DS-MRR with Key-ordered retrieval |
Да |
Да |
- |
- |
| Index_merge / Sort_intersection |
Да |
Да |
- |
- |
| Cost-based choice of range vs. index_merge |
Да |
Да |
- |
- |
| ORDER BY ... LIMIT |
- |
Да |
- |
Да |
| Use extended (hidden) primary keys for innodb/xtradb |
Да |
Да |
- |
- |
| Join optimizations |
| Batched key access (BKA) |
Да |
Да |
- |
Да |
| Block hash join |
Да |
Да |
- |
- |
| User-set memory limits on all join buffers |
Да |
Да |
- |
- |
| Apply early outer table ON conditions |
Да |
Да |
- |
- |
| Null-rejecting conditions tested early for NULLs |
Да |
Да |
- |
- |
| Subquery optimizations |
| In-to-exists |
Да |
Да |
Да |
Да |
| Semi-join |
Да |
Да |
- |
Да |
| Materialization |
Да |
Да |
- |
Да |
| NULL-aware Materialization |
Да |
Да |
- |
- |
| Cost choice of materialization vs. in-to-exists |
Да |
Да |
- |
Да |
| Subquery cache |
Да |
Да |
- |
- |
| Fast explain with subqueries |
Да |
Да |
- |
- |
| EXISTS-to-IN |
- |
Да |
- |
- |
| Optimization for derived tables / views |
| Delayed materialization of derived tables / materialized views |
Да |
Да |
- |
Да |
| Instant EXPLAIN for derived tables |
Да |
Да |
- |
Да |
| Derived Table with Keys optimization |
Да |
Да |
- |
Да |
| Execution control |
| LIMIT ROWS EXAMINED rows_limit |
Да |
Да |
- |
- |
| Optimizer control (optimizer switch) |
| Systematic control of all optimizer strategies |
Да |
Да |
- |
+/- |
| EXPLAIN improvements |
| Explain for DELETE, INSERT, REPLACE, and UPDATE |
- |
+/- |
- |
Да |
| EXPLAIN in JSON format |
- |
- |
- |
Да |
| More detailed and consistent EXPLAIN for subqueries |
Да |
Да |
- |
- |
