MySQL Version Comparison Matrix

redirected from: http://weevilgenius.net/2010/04/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

Last edited Aug 12, 2012 at 2:36 AM by adriancs, version 1