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 |