MySQL Version Comparison Matrix
Have you ever wondered which version of MySQL supports a particular feature? I certainly have. Here is a table listing various major features and storage engines and which versions of MySQL support them, from 3.23 through 5.1. I have cross linked to the MySQL online manual wherever possible, though there are still some gaps.
| Feature | 3.23 | 4.0 | 4.1 | 5.0 | 5.1 |
|---|---|---|---|---|---|
| Statement based replication | Yes1 | Yes | Yes | Yes | Yes |
| Query Cache | No | Yes | Yes | Yes | Yes |
| Unions | No | Yes | Yes | Yes | Yes |
| Character Sets | No2 | Limited3 | Yes4 | Yes | Yes |
| Subqueries | No | No | Yes | Yes | Yes |
| OpenGIS spatial types | No | No | Yes | Yes | Yes |
| Timezone support | No | No | Yes5 | Yes | Yes |
| Prepared statements (server side) | No | No | Yes6 | Yes | Yes |
| Stored Procedures | No | No | No | Yes | Yes |
| Triggers | No | No | No | Yes | Yes |
| Views | No | No | No | Yes | Yes |
| Server side Cursors | No | No | No | Yes | Yes |
| INFORMATION_SCHEMA | No | No | No | Yes | Yes |
| Row based replication | No | No | No | No | Yes7 |
| Event Scheduler | No | No | No | No | Yes |
| XML/Xpath functions | No | No | No | No | Yes |
| Storage Engine | 3.23 | 4.0 | 4.1 | 5.0 | 5.1 |
| ISAM | Deprecated8 | Deprecated | No | No | No |
| MyISAM | Yes | Yes | Yes | Yes | Yes |
| Memory (Heap) | Yes | Yes | Yes | Yes | Yes |
| Merge | Yes9 | Yes | Yes | Yes | Yes |
| InnoDB | Not standard10 | Yes | Yes | Yes | Yes |
| BDB (BerkeleyDB) | Source only | Source only | Source only | Source only | No |
| Archive | No | No | Yes11 | Yes | Yes |
| CSV | No | No | Yes12 | Yes | Yes |
| Blackhole | No | No | Yes13 | Yes | Yes |
| NDBCluster | No | No | Yes14 | Yes | Separate Product15 |
| Federated | No | No | No | Yes | Yes |
| IBMDB2I | No | No | No | No | Yes16 |
Notes
[1]: Statement-based replication support was added in MySQL 3.23.15
[2]: MySQL 3.23 allows you to set a single character set for the server. The default is latin1. Changing it requires restarting (and possibly recompiling) the server.
[3]: MySQL 4.0 added limited character set support for the MyISAM and MEMORY engines. The character set and collation in this version is a single entity.
[4]: MySQL 4.1 added full character set and collation settings for MyISAM, MEMORY, and InnoDB (in version 4.1.2) engines. See the manual for more details.
[5]: Multiple timezone support added in MySQL 4.1.3
[6]: Non-binary SQL interface for prepared statements added in MySQL 4.1.3
[7]: Row-based replication support was added in MySQL 5.1.5. Mixed format replication was added in MySQL 5.1.8. See the manual for more details.
[8]: Prior to MySQL 3.23, ISAM was the only storage engine available. It was replaced by the improved MyISAM engine in release 3.23.0
[9]: Merge storage engine support was added in MySQL 3.23.25
[10]: InnoDB support has to be manually compiled into the binary for My SQL 3.23.x (or use the MySQL Max binary for that version).
[11]: Archive storage engine support was added in MySQL 4.1.3
[12]: CSV storage engine support was added in MySQL 4.1.4
[13]: Blackhole storage engine support was added in MySQL 4.1.11
[14]: NDBCluster storage engine support was added in MySQL 4.1.3
[15]: NDBCluster engine is not available in standard releases of MySQL 5.1. Use the MySQL Cluster releases instead.
[16]: IBMDB2I storage engine support was added in MySQL 5.1.35
Any chance of an update for mySQL 5.5?
Do you have a comparison for versions adding community vs. enterprise ?
Outstanding effort…!!!!!!
as Donovan Any chance of an update for mySQL 5.5?