MySQL

MySQL 5.6.24

MySQL AB
開源軟體

MySQL 為目前最流行的資料庫查詢系統。而 MySQL 主要是以速度、耐用性、易用性為目標,廣泛被企業使用。

  • 支援 MS SQL、Excel、MS Access、XML、CSV 等格式,導入至 MySQL。
  • 較不常需要維護,可節省管理成本。
  • 可保護好您資料庫,發現被不明來源複製則會中斷。
  • 可建立業務應用,確保可靠度及安全性。
  • 為 ACID 特性(原子性、一致性、隔離性、持久性),使軟體達到可靠。

軟體資訊
檔案版本 MySQL 5.6.24
檔案名稱 mysql-5.6.24-win32.msi
檔案大小 44.72MB
系統 Windows 9x / 2000 / XP / Vista / Windows 7 / Windows 8 / Windows 10 / Windows 10 64-bit
支援語系 Multiple languages
軟體類型 開源軟體
更新日期 2015-04-08
更新日誌

# Bugs Fixed
- InnoDB: A TRUNCATE TABLE operation on a temporary table raised an assertion. The temporary table object was incompletely constructed when reloaded from SYS_TABLES.
- InnoDB: A full-text phrase search returned an incorrect result. An empty string was handled incorrectly when tokenizing a newly inserted row.
- InnoDB: Optimizing a FULLTEXT index raised an assertion. The last optimized word of a FULLTEXT index is stored in the CONFIG table value column which is defined as CHAR(50). An assertion was raised when the last optimized word was greater than 50 characters in length. The CONFIG table value column is defined as CHAR(200) as of MySQL 5.6.24 and MySQL 5.7.6.
- If your innodb_ft_max_token_size setting is greater than 50, it is recommended that you recreate existing InnoDB FULLTEXT indexes after upgrading to MySQL 5.6.24 or MySQL 5.7.6 to avoid this issue. FULLTEXT indexes created after upgrading to MySQL 5.6.24 or MySQL 5.7.6 are unaffected.
- InnoDB: An InnoDB memcached extra_col_value[] array was freed without checking the allocated flag, causing a server exit.
- InnoDB: A DML operation performed while a flushing operation was in progress raised a memcached-related assertion.
- InnoDB: The memcached process_arithmetic_command raised an assertion. The wrong error code was returned for a nonexistent decr key.
- InnoDB: The expiration time (exptime) defined using the memcached set command was ignored. InnoDB memcached set the expiration time to an interval value instead of a system time value.
- InnoDB: An assertion was raised when the full-text search fts_savepoint_release() function released a named transaction savepoint and all subsequent savepoints. Only the initial savepoint should be released.
- InnoDB: A full-text search optimization operation raised an assertion.
- InnoDB: Due to a regression introduced in MySQL 5.6.20, mysqld stop did not stop the mysqld server process while the InnoDB memcached plugin was active.
- InnoDB: An ALTER TABLE ... RENAME failure on a table with a FULLTEXT index raised an assertion.
- InnoDB: A severe error occurred during the log apply phase of an online ALTER TABLE operation that was converting a table with a UTF-8 charset to ROW_FORMAT=REDUNDANT.
- InnoDB: When dummy tables are created, the autoinc_mutex member of the of the dict_table_t object was created unnecessarily. Similarly, the zip_pad.mutex object of dict_index_t object was created unnecessarily for dummy indexes. To avoid unnecessary mutex contention, autoinc_mutex and zip_pad.mutex objects are now allocated and initialized on the first lock attempt.
- InnoDB: An ALTER TABLE ... RENAME operation raised an invalid assertion. The assertion code used an incorrect transaction object.
- InnoDB: A memcached append operation on an INT column caused a segmentation fault. append operations on INT columns are not supported and are now blocked.
- Partitioning: A number of ALTER TABLE statements that attempted to add partitions, columns, or indexes to a partitioned table while a write lock was in effect for this table were not handled correctly.
- Partitioning: Executing an ALTER TABLE on a partitioned table on which a write lock was in effect could cause subsequent SQL statements on this table to fail.
- Replication: When replicating from a 5.7.6 or later server to a 5.6.23 or earlier server, if the older version applier thread encountered an Anonymous_gtid_log_event it caused an assert. The fix ensures that these new log events added in MySQL 5.7.6 and later do not cause this problem with 5.6.24 and later slaves. If gtid_mode is OFF and the applier thread encounters a Gtid_log_event, the applier thread aborts with an error. If gtid_mode is ON and the applier thread encounters a Anonymous_gtid_log_event, the applier thread aborts with an error.
- Replication: When the automatic_sp_privileges variable is set, the server automatically grants the EXECUTE and ALTER ROUTINE privileges to the creator of a stored routine, if the user does not already have these privileges. When a privileged user creates a procedure with DEFINER as a non privileged user on a master, the current user is considered to be a privileged user and the mysql.procs_priv table is not updated. When such a statement was replicated to slave, the non-privileged DEFINER was considered as the current user on the slave and privileges were being allocated. This caused a difference in the privileges that were being allocated on the master and the slave. The fix ensures that creater of the stored routine is added to the binary log, and the slave now checks first if the user exists before granting privileges. To maintain compatibility with previous versions, the DEFINER is used when the INVOKER is not available. As part of this fix, anonymous users can be used to replicate from master to slave.
- Replication: When using a slave configured to use a special character set such as UTF-16, UTF-32, or UCS-2, the receiver (I/O) thread failed to connect. The fix ensures that in such a situation, if a slave's character set is not supported then default to using the latin1 character set.
- Replication: When gtid_mode=ON and slave_net_timeout was set to a low value, the slave I/O thread could appear to hang. This was due to the slave heartbeat not being sent regularly enough when the dump thread found many events that could be skipped. The fix ensures that the heartbeat is sent correctly in such a situation.
- CMake failed to detect the OpenSSL version properly for recent versions of OpenSSL (the format of the version string changed).
- For execution of prepared statements, no check was made whether an audit log plugin returned an error, so statement success could erroneously be returned.
- Debian packages were missing some dependencies.
- Corrections were made for a number of code issues that resulted in compiler warnings about array bounds, possibly uninitialized variables, and variables being set but not used.
- Following execution of a GRANT ... WITH GRANT OPTION statement, execution of a prepared statement with a view could cause a server exit.
- NULL as an expression was not recognized as a literal for calculation of Performance Schema statement digests.
- A user with a name of event_scheduler could view the Event Scheduler process list without the PROCESS privilege.
- Trying to create a user after dropping columns from the mysql.user table could result in a server exit.
- Ordering by a GROUP_CONCAT() result could cause a server exit.
- A malformed mysql.proc table row could result in a server exit for DROP DATABASE of the database associated with the proc row.
- SHOW GRANTS after connecting using a proxy user could display the password hash of the proxied user.
- Large values of the transaction_prealloc_size system variable could cause the server to allocate excessive amounts of memory. The maximum value has been adjusted down to 128K. A similar change was made for transaction_alloc_block_size. Transactions can still allocate more than 128K if necessary; this change reduces the amount that can be preallocated, as well as the maximum size of the incremental allocation blocks.
- Certain queries on the INFORMATION_SCHEMA.INNODB_FT_CONFIG table could cause a server exit.
- A server exit could occur for queries that compared two rows using the <=> operator and the rows belonged to different character sets.
- Certain InnoDB errors caused stored function and trigger condition handlers to be ignored.
- The optimizer could raise an assertion due to incorrectly associating an incorrect field with a temporary table.
- Audit log filtering was not applied to connection events.
- With audit_log_connection_policy=ERRORS, successful COM_QUIT events were errroneously written to the audit log.
- The value of the Audit_log_events status variable did not equal the sum of the other audit log counters.
- The Audit_log_events_filtered status variable did not increment when audit log events were filtered.
- Many new features were added to the audit log plugin in MySQL 5.6.20, but the version number was not increased. The version has been bumped to 1.1.
- The server could exit due to an optimizer failure to allocate enough memory for resolving outer references.
- If the audit log file was found to be corrupt at server startup, an appropriate error message was not always written. Also, if the plugin is loaded, it will be initialized regardless of whether the log was corrupt, except in the case that renaming the log file fails.
- Creating a FEDERATED table with an AUTO_INCREMENT column using a LIKE clause results in a server exit.
- The group_concat_max_len system variable could be set to its maximum value at runtime, but not in an option file.
- A server warning error message referred to the obsolete table_cache system variable rather than to table_open_cache. Thanks to Daniël van Eeden for the patch to fix some of the instances.
- In the DIGEST_TEXT column of Performance Schema statement events tables, references to system variables of the form @@var_name were stored as @ @ var_name.
- If the WITH_SSL CMake option was specified with an incorrect path to the SSL installation or the path to an unsupported (too old) SSL installation, the option was implicitly changed to the bundled value and yaSSL was used instead. Now CMake exits with an error so the user knows that the option value must be changed.
- mysql_real_connect() could close a file descriptor twice if the server was not running.
- Notification of events for the general log were received by the audit log plugin only of the general query log was enabled. Now notifications are posted regardless of whether the general query log is enabled.

作者 MySQL AB
官網 http://www.mysql.com

  • Title: MySQL 5.6.24 Filename: mysql-5.6.24-win32.msi File size: 44.72MB (46,895,616 bytes) Requirements: Windows 9x / 2000 / XP / Vista / Windows 7 / Windows 8 / Windows 10 / Windows 10 64-bit Languag...
    MySQL
    Download MySQL 5.6.24 - Technical Details - FileHippo.com
    http://filehippo.com
  • MySQL Engineering Blogs Upgrading your MySQL Server Farm MySQL Workbench 6.3.9 GA has been released “The king is dead, long live the king”: Our Paxos-based consensus Give me a MySQL and Make it Snappy...
    MySQL
    MySQL - Official Site
    https://www.mysql.com
  • Changes in MySQL 5.6.24 (2015-04-06, General Availability) ... CONFIG table value column is defined as CHAR(200) as of MySQL 5.6.24 and MySQL 5.7.6.
    MySQL
    MySQL 5.6 Release Notes :: Changes in MySQL 5.6.24 (2015-04-06 ...
    https://dev.mysql.com
  • MySQL 5.6.24 MySQL 5.6.24 By MySQL AB (Open Source) User Rating FileHippo Safety Guarantee Secured by Avira Download This Version (44.72MB) Download Advertisement Advertisement Latest Version MySQL 5....
    MySQL
    MySQL 5.6.24 - FileHippo.com - Download Free Software
    http://filehippo.com
  • MySQL Community Server 5.6 » MySQL Community Server 5.5 » Archived versions » Please report any bugs or inconsistencies you observe to our ...
    MySQL
    MySQL :: Download MySQL Community Server
    https://dev.mysql.com
  • This is the MySQL™ Reference Manual. It documents MySQL 5.6 through 5.6.36, as well as MySQL Cluster releases based on versions 7.3 and 7.4 of NDB through 5.6.35-ndb-7.3.17 and 5.6.35-ndb-7.4.15, resp...
    MySQL
    MySQL :: MySQL 5.6 Reference Manual - MySQL :: Developer Zone
    https://dev.mysql.com
  • ... in MySQL 5.6.25 (2015-05-29, General Availability) &middot; Changes in MySQL 5.6.24 (2015-04-06, General Availability) &middot; Changes in MySQL 5.6.23 (2015-02-02,&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes
    https://dev.mysql.com
  • This document contains release notes for the changes in each release of MySQL 5.6, up through MySQL 5.6.36. For information about changes in a different MySQL series, see the release notes for that se...
    MySQL
    MySQL :: MySQL 5.6 Release Notes - MySQL :: Developer Zone
    https://dev.mysql.com
  • The CONFIG table value column is defined as CHAR(200) as of MySQL 5.6.24 and MySQL 5.7.6. If your innodb_ft_max_token_size setting is greater than 50, it is recommended that you recreate existing Inno...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.24 (2015-04-06, General Availability)
    https://dev.mysql.com
  • Changes in MySQL 5.6.24 (2015-04-06, General Availability) &middot; Changes in MySQL 5.6.23 (2015-02-02, General Availability) &middot; Changes in MySQL 5.6.22&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.26 ...
    https://dev.mysql.com
  • Changes in MySQL 5.6.24 (2015-04-06, General Availability) &middot; Changes in MySQL 5.6.23 (2015-02-02, General Availability) &middot; Changes in MySQL 5.6.22&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.27 ...
    https://dev.mysql.com
  • 2015年12月7日 - Changes in MySQL 5.6.24 (2015-04-06, General Availability) &middot; Changes in MySQL 5.6.23 (2015-02-02, General Availability) &middot; Changes in&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.28 ...
    https://dev.mysql.com
  • Changes in MySQL 5.6.24 (2015-04-06, General Availability) &middot; Changes in MySQL 5.6.23 (2015-02-02, General Availability) &middot; Changes in MySQL 5.6.22&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.29 ...
    https://dev.mysql.com
  • Changes in MySQL 5.6.24 (2015-04-06, General Availability) &middot; Changes in MySQL 5.6.23 (2015-02-02, General Availability) &middot; Changes in MySQL 5.6.22&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.30 ...
    https://dev.mysql.com
  • Changes in MySQL 5.6.24 (2015-04-06, General Availability) &middot; Changes in MySQL 5.6.23 (2015-02-02, General Availability) &middot; Changes in MySQL 5.6.22&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.33 ...
    https://dev.mysql.com
  • Dear MySQL users, MySQL Server 5.6.24, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.24 is recommended for use on production systems. For an overvie...
    MySQL
    MySQL :: MySQL Community Server 5.6.24 has been released
    https://forums.mysql.com
  • MySQL Downloads Oracle MySQL Cloud Service (commercial) Oracle MySQL Cloud Service is built on MySQL Enterprise Edition and powered by Oracle Cloud, providing an enterprise-grade MySQL database servic...
    MySQL
    MySQL :: MySQL Downloads
    https://www.mysql.com
  • MySQL-5.6.24免安装版配置方法,有需要的朋友可以参考下。1. 下载MySQL Community Server 5.6.24 2. 解压MySQL压缩包 将以下载的MySQL压缩包解压到自定义目录下,我的解压目录是: &quot;C:&#92;mysql&quot; 将解压目录下默认文件 my-default.ini 拷贝一份,改名 my.ini
    MySQL
    MySQL-5.6.24免安装版配置方法 - 爱程序网
    http://www.aichengxu.com