Four Hundred Stuff--MySQL 5.4 Brings Scalability, Performance Improvements

Newsletters	Subscriptions	Forums	Safari	Store	Career	Media Kit	About Us	Contact	Search	Home

Volume 9, Number 17 -- April 28, 2009

MySQL 5.4 Brings Scalability, Performance Improvements

Published: April 28, 2009

by Alex Woodie

Sun Microsystems took a moment last week, as it was getting prepared to be eaten by Oracle, to announce a new release of MySQL, the open source relational database management system it bought for $1 billion just over a year ago. MySQL 5.4 brings scalability enhancements for X64 and Chip Multi-threaded (CMT) servers, while general performance enhancements will help users running the software on all types of servers, including IBM Power Systems boxes.

When paired with the InnoDB storage engine, which coincidentally is owned by Oracle, MySQL 5.4 can really scale. With InnoDB powering MySQL, Sun says, the duo can scale up to run on 16-way x86 servers and 64-way CMT servers. (Sun has been moving its SPARC chip architecture toward CMT for the last few years.)

The new database also brings new subquery optimizations and JOIN improvements that can result in up to 90 percent better response times for certain types of analytical queries. "Without any modifications to your applications, MySQL 5.4 will transparently increase the performance and scalability of your applications, to enable them to scale under more demanding user and data processing loads," said Karen Tegan Padir, vice president of Sun's MySQL and Software Infrastructure Group, during the keynote address at last week's MySQL Conference & Expo in Santa Clara, California.

Other improvements were made in the areas of stored procedures, prepared statements access to information schemas, and DTrace support on Sun Solaris.

A preview of MySQL 5.4 is currently available for 64-bit versions of Linux and Solaris 10. Sun also intends to support the new database on IBM i OS, Windows, AIX, HP-UX, Mac OS X, and Free BSD. The general availability date for MySQL 5.4 will be announced later this year.

DB2/400 Storage Engine for MySQL Now Available as Public Beta

Enterprise Features Gain Focus as MySQL 5.1 Nears Release

Sun Casts a $1 Billion Net to Catch MySQL

IBM Details MySQL on System i Offering

MySQL Database Getting Closer Ties to the System i

	Back to the Web Version

TABLE OF CONTENTS

Twitter from an AS/400? Kisco Lets You Do It

nuBridges Pushes 'Tokenization' with New Encryption Tool

BCD Adds Features Throughout App Modernization Suite

Guardium Adds DB2/400 Support to Database Security Tool

Lawson Retrenches as it Reconnects with Customers

News Briefs and Product Shorts:

LANSA Acquires aXes Products; Customers Likely Candidates for RAMP . . . i OS Spool Files Go In, Structured XML Comes Out . . . CCSS Cracks Down on Long-Running Jobs . . . MySQL 5.4 Brings Scalability, Performance Improvements . . . QlikTech Develops a BI Client for iPhone . . .