EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

SQL Industry News

MySQL News

12/23/2005
MySQL 5.1.4-alpha released.

MySQL 5.1.4, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages and mirror sites.

Note that not all mirror sites may be up to date at this point in time - if you can't find this version on some mirror, please try again later or choose another download site.

This is the second public alpha release of the current MySQL 5.1 development branch, providing an insight to upcoming features. While some of these are still under heavy development, this release includes the following new features and changes (in comparison to the current MySQL 5.0 production release):

  • Partitioning, which allows distributing portions of individual tables across a file system, according to rules set when the table is created.
  • Plugin API for loading and unloading various components at runtime without restarting the server.
  • Updated Instance manager.
  • Improved performance for Boolean full text searches.
  • VARCHAR fields using in MySQL Cluster tables are now variable sized.

Please refer to our bug database for more details about the individual bugs fixed in this version.

Changes in release 5.1.4:

Functionality added or changed:

  • It is now possible to build the server such that MyISAM tables can support up to 128 keys rather than the standard 64. This can be done by configuring the build using the option --with-max-indexes=N, where N<=128 is the maximum number of indexes to permit per table.
  • The bundled BDB library was upgraded to version 4.4.16.
  • Added the cp1250_polish_ci collation for the cp1250 character set.
  • Added the myisam_use_mmap system variable.
  • Added the --bdb-data-direct and --bdb-log-direct server options.

Bugs fixed:

  • BDB: A DELETE, INSERT, or UPDATE of a BDB table could cause the server to crash where the query contained a subquery using an index read.
  • A left join on a column that having a NULL value could cause the server to crash.
  • It was not possible to reorganize a partition reusing a discarded partition name. Now, for example, you can create a table such as this one:
    CREATE TABLE t1 (a INT)
         PARTITION BY RANGE (a) (
         PARTITION p0 VALUES LESS THAN (10),
         PARTITION p1 VALUES LESS THAN (20),
         PARTITION p2 VALUES LESS THAN MAXVALUE
    );
    
    and then repartition it as shown here:
    ALTER TABLE t1 REORGANIZE PARTITION p2 INTO (
         PARTITION p2 VALUES LESS THAN (30)
    );
    
    Previously, attempting to do so would produce the error All partitions must have unique names in the table.
  • NDB Cluster: The --ndb option for perror did not function.
  • The BLACKHOLE storage engine did not handle transactions properly: Rolled-back transactions were written to the binary log. Now they are not.
  • NDB Cluster: Using ORDER BY primary_key_column when selecting from a table having the primary key on a VARCHAR column caused a forced shutdown of the cluster.
  • SELECT queries that began with an opening parenthesis were not being placed in the query cache.

Additional notes:

We have upgraded the compiler suite used to build MySQL on Windows from Visual Studio 6.0 to Visual Studio .Net 2003. This change has become necessary as we have become aware of problems with the old compiler. We are sorry for the inconvenience to those who compile on Windows from source, but had no better choice.

And many more...

Source: dev.mysql.com

twitterfacebook