Old MySQL Versions

MariaDB 5.1 was the first release of MariaDB. It was based on MySQL 5.1.

In a sense, users can think about MySQL 5.0 and older releases (or even older releases of the MySQL 5.1 tree) as old versions of MariaDB.

This page lists the main features that were added in very old MySQL trees, before MariaDB was created. This is done for historical purpose, and can also be useful for users who still run those versions.

MySQL 3.22

• Configuration files

• Compressed protocol

• HAVING

• FLUSH TABLES, LOGS, PRIVILEGES, HOSTS

• GRANT and REVOKE

• KILL

• CREATE INDEX, DROP INDEX

• HIGH_PRIORITY and LOW_PRIORITY, DELAYED

MySQL 3.23

• Replication (only statement-based, no SSL).

• Temporary tables

• Portable tables through different machines

• SQL_MODE

• User defined functions

• Procedure ANALYSE()

• New storage engines:

  • HEAP (now called MEMORY)

  • MyISAM (which replaced ISAM)

  • InnoDB

  • bdb (removed in MySQL 5.1; no version of MariaDB included it)

• COUNT(DISTINCT)

• Table comments

• ...

MySQL 4.0

• InnoDB enabled by default.

• Dynamic configuration variables.

• FULLTEXT for MyISAM.

• UNION.

• TRUNCATE TABLE.

• Multi-table DELETE and UPDATE.

• Query cache.

• Embedded server.

MySQL 4.1

• Subqueries (not optimized).

• Faster protocol.

• Prepared statements.

• GIS support for MyISAM

• B-TREE for MEMORY tables.

• Replication over SSL.

• UTF-8 character set.

• New storage engines:

  • ARCHIVE

  • CSV

  • BLACKHOLE

MySQL 5.0

• Views.

• Stored Procedures

• Stored Functions

• Triggers

• XA Transactions

MySQL 5.1 (older releases)

• Events

• Partitioning.

• Storage engines API.

• Plugins API.

• Row-based and mixed replication.