MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.
MySQL delivers enterprise features, including:
- Partitioning to improve performance and management of very large database environments
- Row-based/Hybrid Replication for improved replication security
- Event Scheduler to create and schedule jobs that perform various database tasks
- XPath Support
- Dynamic General/Slow Query Log
- Performance/Load Testing Utility (mysqlslap)
- Improved! Full Text Search (faster, new dev templates)
- Improved! Archive engine (better compression, more features)
- Improved! User session and problem SQL identification
- Improved! MySQL embedded library (libmysqld)
- Additional INFORMATION_SCHEMA objects
- Faster data import operations (parallel file load)
- ACID Transactions to build reliable and secure business critical applications
- Stored Procedures to improve developer productivity
- Triggers to enforce complex business rules at the database level
- Views to ensure sensitive information is not compromised
- Information Schema to provide easy access to metadata
- Pluggable Storage Engine Architecture for maximum flexibility
- Archive Storage Engine for historical and audit data
# Bugs Fixed
* InnoDB: Running REPLACE operations on multiple connections resulted in a hang.
* Replication: The test case main.merge failed when the variables binlog_format was set to “ROW,” as the server tried to get information for table creation for a child table before it was opened. With this fix, the server skips getting information for the table in the situation.
* MySQL did not build with GCC 5.
* The System-V initialization script for RHEL6 or older failed to enable the mysqld service by default.
* Improper host name checking in X509 certificates could permit man-in-the-middle attacks.
* A boolean mode full-text search caused a segmentation fault.
* Concurrent selecting and flushing of a FEDERATED table while killing connections accessing it could result in a server exit.
* Executing GRANT PROXY statements after altering the definition of the mysql.user system table could result in a server exit.
* Certain error messages included part of the SQL statement that produced them, possibly exposing data.
* Character set conversion operations on NULL parameters to prepared statements could cause a server exit.
* For INSERT and UPDATE operations that caused FOREIGN KEY constraint violations, errors were reported rather than warnings when the IGNORE keyword was used.
* Processlist state information was not updated correctly for LOAD DATA INFILE and could show a state different from executing.