MySQL Users Conference 2009 - Day Two Another Big Announcement
By George Trujillo on Apr 21, 2009
The Continuing Disruption in the Database Industry:
Everyone recognizes the tremendous growth and adoption of the MySQL Database Server in the marketplace. On the second day of the MySQL Users Conference 2009 in Santa Clara, CA , the power of combining Sun expertise with MySQL innovation has been shown to the IT industry. Today Sun Microsystems introduces the MySQL 5.4 performance release. Sun and MySQL teams have addressed all the doomsayers and analysts spreading FUD with an exciting new version of MySQL. This release includes some excellent patches from the user community showing the continuing importance of the MySQL user community.
Key Features of the MySQL 5.4 Release
Performance benchmarks have shown MySQL 5.4 to run up to 60% faster than 5.1. Some of the key new features of this performance and scalability release include:
- Architecture enhancements to support significant increase in scalability supporting up to 16-way x86 servers and 64-way CMT servers.
- Improved default configuration out of the box. Default parameters are much better initial values.
- Significantly improved locking concurrency capability with InnoDB.
- Improved metadata with enhancements to INFORMATION_SCHEMA.
- Key performance additions to subqueries and joins improving performance up to 90% for some queries.
- Enhanced diagnostics with Dtrace runtime monitoring.
- Expanded SHOW ENGINE INNODB STATUS output.
- Performance optimizations to leverage MySQL on Solaris.
- New performance status variables.
- Configurable read (INNODB_READ_IO_THREADS) and write threads (INNODB_WRITE_IO_THREADS) allow MySQL to leverage hardware capability.
- Significantly enhanced I/O with InnoDB.
- Improvement of stored procedures with SIGNAL and RESIGNAL additions.