Role in IT decision-making process:Align Business & IT GoalsCreate IT StrategyDetermine IT NeedsManage Vendor RelationshipsEvaluate/Specify Brands or VendorsOther RoleAuthorize PurchasesNot Involved

Work Phone:

Company:

Company Size:

Industry:

Street Address

City:

Zip/postal code

State/Province:

Country:

Occasionally, we send subscribers special offers from select partners. Would you like to receive these special partner offers via e-mail?YesNo

Your registration with Eweek will include the following free email newsletter(s):News & Views

By submitting your wireless number, you agree that eWEEK, its related properties, and vendor partners providing content you view may contact you using contact center technology. Your consent is not required to view content or use site features.

By clicking on the "Register" button below, I agree that I have carefully read the Terms of Service and the Privacy Policy and I agree to be legally bound by all such terms.

Preview of MySQL Ready for Download

The latest alpha release of the open-source database is in line to pick up stored procedures and more speed.

MySQL AB last week released an alpha preview of the latest version of its flagship open-source database, MySQL 5.0.

The company will announce pricing and release dates when MySQL 5.0 is formally announced in early January, a spokeswoman said. MySQLs site lists potential new features, including stored procedures based on the SQL-99 framework, which is similar to Oracle PL/SQL. According to documentation on the site, the SQL-99 framework accommodates external languages and provides compatibility with PL/SQL and T-SQL, for example.

Other planned features include elementary cursor support, the ability to specify explicitly that an RTREE index be created for MyISAM tables and dynamic length rows for HEAP tables.

In a move that promises to enhance standards compliance, improve portability and ease migration, the new release may include true VARCHAR support. This enhancement will support columns longer than 255 characters with no stripping of trailing whitespace.

Further reading

If planned enhancements are implemented, MySQL 5.0 should also be speedier than previous releases. One enhancement will affect the SHOW COLUMNS FROM table_name command, which is used by the MySQL client to enable expanded column names. A targeted enhancement for 5.0 is that the command opens only the definition file as opposed to the whole table. In addition, DELETE on MYISAM tables should be able to use record cache. Better in-memory (HEAP) tables will also resize rows dynamically and handle rows faster with less copying.

Based on the planned enhancements list, MySQL 5.0 will gain better internationalization features as well. When using the SET CHARACTER SET command, the software will translate the whole query instead of translating only strings. Such translated characters can be used in database, table and column names.

Finally, Version 5.0 is slated to resolve an issue with the RENAME TABLE command. In the current version of the database, using this command in an active MERGE table renders the table vulnerable to corruption.

Although Version 5.0 is still in alpha, Uppsala, Sweden-based MySQL does recommend the products Standard binaries for most users. MySQL has incorporated the InnoDB storage engine—an open-source transactional storage engine from Innobase Oy Inc., of Helsinki, Finland—into those binaries. A Max version also includes features such as the Berkeley DB storage engine and other features that havent yet undergone thorough testing, including OpenSSL support, user-defined functions and BIG_TABLE support. Future versions of Standard binaries will include those features after they have matured and are stable, according to MySQLs site.

The MySQL site warns that Debug binaries now include extra debug information that is not intended for general consumption, because the extra code may slow down database instances.

Editors note: This story was updated to reflect the fact that new features are based on plans detailed on MySQLs site and have not as yet been verified by the company.