All pages
Powered by GitBook
1 of 1

Loading...

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

  • and

  • ,

  • ,

MySQL 3.23

  • (only statement-based, no SSL).

  • Temporary tables

  • Portable tables through different machines

MySQL 4.0

  • enabled by default.

  • Dynamic configuration variables.

  • for MyISAM.

  • .

MySQL 4.1

  • (not optimized).

  • Faster protocol.

  • .

  • support for MyISAM

MySQL 5.0

  • .

MySQL 5.1 (older releases)

  • Partitioning.

  • Storage engines API.

  • Plugins API.

  • New storage engines:

    • HEAP (now called )

    • (which replaced ISAM)

    • InnoDB

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

  • Table comments

  • ...

  • .

  • Multi-table DELETE and UPDATE.

  • .

  • Embedded server.

  • B-TREE for MEMORY tables.

  • Replication over .

  • UTF-8 character set.

  • New storage engines:

  • replication.
    Replication
    FLUSH TABLES, LOGS, PRIVILEGES, HOSTS
    GRANT
    REVOKE
    KILL
    CREATE INDEX
    DROP INDEX
    HIGH_PRIORITY and LOW_PRIORITY
    DELAYED
    SQL_MODE
    InnoDB
    FULLTEXT
    UNION
    Subqueries
    Prepared statements
    GIS
    Views
    Stored Procedures
    Stored Functions
    Triggers
    Events
    User defined functions
    Procedure ANALYSE()
    MEMORY
    MyISAM
    COUNT(DISTINCT)
    TRUNCATE TABLE
    Query cache
    SSL
    ARCHIVE
    CSV
    BLACKHOLE
    XA Transactions
    Row-based and mixed
    bdb

    This page is licensed: CC BY-SA / Gnu FDL