MySQL Features Timeline

This timeline shows as of what version MySQL features were added, removed and changed. This is a work in progress so many features are missing. The MySQL manual is the authoritative source for all feature additions, removals and changes. To add a feature, contact me.

MySQL versionFeatures
 AddedChanged
5.4.2
5.1.38  
5.1.33  
5.1.31
  • Questions in SHOW STATUS includes only statements sent to the server by clients and no longer includes statements executed within stored programs, unlike the Queries variable
5.1.24  
5.1.12
5.1.8  
5.1.7  
5.1.6  
5.1.5  
5.1
  • BDB storage engine removed
5.0.76  
5.0.72
  • Questions in SHOW STATUS includes only statements sent to the server by clients and no longer includes statements executed within stored programs, unlike the Queries variable
5.0.32  
5.0.19  
5.0.13
  • GREATEST() returns NULL if any argument is NULL instead of if all arguments are NULL
  • LEAST() returns NULL if any argument is NULL instead of if all arguments are NULL
5.0.7
5.0.5
  • BIT data type support added to MEMORY, InnoDB, BDB, and NDBCLUSTER storage engines
5.0.3
5.0.2
  • HAVING can refer to columns in the SELECT list and outer subqueries, in addition to columns in GROUP BY and aggregate functions (SQL standard)
5.0.1
  • SHOW COLUMNS shows views
5.0
  • ISAM storage engine removed
4.1.11
4.1.8  
4.1.4
  • CVS storage engine
  • SHOW PROCESSLIST displays Rolling back in the State column
  • 4.1.2
    • ENGINE to CREATE TABLE, synonym for TYPE
    4.1.1  
    4.1
    • COMMENT for CREATE TABLE made operational (allowed but ignored in earlier versions)
    • PASSWORD() hash value length increased from 16 to 41 bytes
    • Character column lengths interpreted in character units instead of bytes
    • HEAP storage engine renamed MEMORY, but HEAP still works
    • SHOW FULL COLUMNS displays any per-column collation and comments
    4.0.18
    • ENGINE to CREATE TABLE, synonym for TYPE
    4.0.15
    4.0.14
    4.0.2
    4.0.1
    4.0
    3.23.23