

InnoDB: With the innodb fileper_table setting enabled, a DROP TABLE operation could cause a crash, due to a race condition that depended on the timing of pending I/O requests.InnoDB: If a CREATE TABLE statement failed due to a disk full error, some memory allocated during the operation was not freed properly.InnoDB: An online DDL operation for an InnoDB table incorrectly reported an empty value ('') instead of the correct key value when it reported a duplicate key error for a unique index using an index prefix.This optimization affects only transactions with isolation level equal to or less strict than READ COMMITTED it does not apply to transactions using REPEATABLE READ or SERIALIZABLE isolation level. This fix reduces the excessive locking by releasing the locks of unmatched rows. Important Change: InnoDB: A DML statement using the index merge access method could lock many rows from the table, even when those rows were not part of the final result set.This enhancement primarily affects read operations for BLOB columns in compressed tables. Performance: InnoDB: The timing values for low-level InnoDB read operations were adjusted for better performance with fast storage devices, such as SSD.The SHOW AUTHORS and SHOW CONTRIBUTORS statements are now deprecated in MySQL 5.5 and have been removed in MySQL 5.6.MySQL is the world's most popular open source database, so it's easy to find high-quality, skilled staff. Millions of Trained and Certified Developers. MySQL is available on more than twenty different platforms including major Linux distributions, Mac OS X, UNIX and Microsoft Windows.


By providing ready access to source code, MySQL's approach ensures freedom, thereby preventing lock-in to a single company or platform.Ĭross-Platform Support.

Its unique multi-storage engine architecture gives corporate customers the flexibility they need with a database management system unmatched in speed, compactness, stability, and ease of deployment.įreedom from Platform Lock-in. MySQL's architecture makes it extremely fast and easy to customize. MySQL AB provides early versions of all its database server software to the community to allow for several months of "battle testing" by the open source community before it deems them ready for production use.Įase of Use and Deployment.
