MySQL 5.1.47

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

Title: MySQL 5.1.47
Filename: mysql-essential-5.1.47-win32.msi
File size: 39.07MB (40,967,168 bytes)
Requirements: Windows 9x / 2000 / XP / 2003 / Vista / Windows7
Languages: en-US
License: Open Source
Date added: May 20, 2010
Author: MySQL AB
www.mysql.com

Change Log:

# Bugs fixed:

* Important Change: Replication: When invoked, CHANGE MASTER TO and SET GLOBAL sql_slave_skip_counter now cause information to be written to the error log about the slave's state prior to execution of the statement. For CHANGE MASTER TO, this information includes the previous values for MASTER_HOST, MASTER_PORT, MASTER_LOG_FILE, and MASTER_LOG_POS. For SET GLOBAL SQL_SLAVE_SKIP_COUNTER, this information includes the previous values of sql_slave_skip_counter, the group relay log name, and the group relay log position. (Bug#43406, Bug#43407)
* Replication: The failure of a REVOKE statement was logged with the wrong error code, causing replication slaves to stop even when the failure was expected on the master. (Bug#51987)
* Certain path names passed to LOAD_FILE() could cause a server crash. (Bug#53417)
* When reporting a foreign key constraint violation during INSERT, InnoDB could display uninitialized data for the DB_TRX_ID and DB_ROLL_PTR system columns. (Bug#53202)
* InnoDB page splitting could enter an infinite loop for compressed tables. (Bug#52964)
* An overly strict assertion could fail during the purge of delete-marked records in DYNAMIC or COMPRESSED InnoDB tables that contain column prefix indexes. (Bug#52746)
* InnoDB attempted to choose off-page storage without ensuring that there was an “off-page storage” flag in the record header. To correct this, in DYNAMIC and COMPRESSED formats, InnoDB stores locally any non-BLOB columns having a maximum length not exceeding 256 bytes. This is because there is no room for the “external storage” flag when the maximum length is 255 bytes or less. This restriction trivially holds in REDUNDANT and COMPACT formats, because there InnoDB always stores locally columns having a length up to local_len = 788 bytes. (Bug#52745)
* Setting @@GLOBAL.debug to an empty string failed to clear the current debug settings. (Bug#52629)
* A memory leak occurred due to missing deallocation of the comparators array (a member of the Arg_comparator class). (Bug#52124)
* For debug builds, creating a view containing a subquery that might require collation adjustment caused an assertion to be raised. For example, this could occur if some items had different collations but the result collation could be adjusted to the one of them. (Bug#52120)
* Connections waiting for an InnoDB row lock ignored KILL until the row lock wait ended. Now, KILL during lock wait results in “query interrupted” instead of “lock wait timeout exceeded”. (Bug#51920)
* Locking involving the LOCK_plugin, LOCK_global_system_variables, and LOCK_status mutexes could deadlock. (Bug#51591)
* InnoDB fast index creation could incorrectly use a table copy in some cases. (Bug#50946)
* A syntactically invalid trigger could cause the server to crash when trying to list triggers. (Bug#50755)
* InnoDB Plugin checks to see whether a row could possibly exceed the maximum size if all columns are fully used. This produced Row size too large errors for some tables that could be created with the built-in InnoDB. Now the check is only done when innodb_strict_mode is enabled or if the table is dynamic or compressed. (Bug#50495)
* On Windows, the server failed to find a description for Event ID 100. (Bug#48042)
* For updates to InnoDB tables, TIMESTAMP columns could be updated even when no values actually changed. (Bug#47453)
* If the server is started with --skip-grant-tables, plugin loading and unloading should be disallowed, but the server failed to reject INSTALL PLUGIN and UNINSTALL PLUGIN statements. (Bug#46261)
* Storage engine plugins on Windows could've been built with a definition of time_t which was different from the server expectations. The difference could cause affected plugins to crash. In addition, the use of the time_t type in the storage engine API layer has been enforced. (Bug#39802, Bug#40092)
* When using UNINSTALL PLUGIN to remove a loaded plugin, open tables and connections caused mysqld to hang until the open connections had been closed. (Bug#39053)
* 1) In rare cases, if a thread was interrupted during a FLUSH PRIVILEGES operation, a debug assertion occurred later due to improper diagnostic area setup. 2) A KILL operation could cause a console error message referring to a diagnostic area state without first ensuring that the state existed. (Bug#33982)