MySQL

MySQL 5.6.23

MySQL AB
開源軟體

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

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

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

# Functionality Added or Changed
- Support for the SSL 2.0 and SSL 3.0 protocols has been disabled because they provide weak encryption. Support was added for the TLS 1.1 and TLS 1.2 protocols.
- yaSSL was upgraded to version 2.3.7.
- The valid date range of the SSL certificates in mysql-test/std_data has been extended to the year 2029.
# Bugs Fixed
- InnoDB: A tablespace export operation set the purge state to PURGE_STATE_STOP but the purge thread did not check the purge state until the current purge operation was completed. In the case of a large history list, the tablespace export operation was delayed, waiting for the current purge operation to finish. The purge state is now checked with every purge batch.
- InnoDB: An ALTER TABLE ... ADD INDEX operation raised an assertion due to assertion code that did not allow an online index status of ONLINE_INDEX_ABORTED_DROPPED. The assertion code has been relaxed.
- InnoDB: An error occurred when the push_warning_printf function was invoked during server recovery. This function was previously used to print a warning message to the client. Also, current_thd was NULL when the server was restarted.
- InnoDB: An ALTER TABLE operation that changed the name of a foreign key column resulted in a failure when reloading the foreign key constraint. The previous column name remained in the data dictionary cache instead of being evicted.
- InnoDB: Error messages regarding a size limitation on BLOB or TEXT data inserted in a single transaction have been revised.
- InnoDB: DML operations on a table with full-text search indexes raised an invalid assertion.
- InnoDB: A multiple-table delete operation caused the server to halt.
- InnoDB: A FLUSH TABLES operation raised an assertion.
- InnoDB: With change buffering enabled, a buffered sequence of operations that should not have been buffered resulted in an Unable to purge a record error.
- InnoDB: On non-Windows platforms, os-file_pread and os_file_pwrite functions return -1 when an error occurs. This value was printed in an error message as the number of bytes read or written. Instead of printing the -1 value in the error message, a separate error message indicating a system call failure is now printed. Thanks to David Bennett for the patch.
- InnoDB: A slow shutdown (innodb_fast_shutdown=0) after crash recovery raised an assertion. Slow shutdown did not wait for background rollback operations to finish before proceeding.
- InnoDB: The integer column value was handled incorrectly for the memcached incr and decr commands.
- Partitioning: A failed ALTER TABLE ... TRUNCATE PARTITION statement or a failed TRUNCATE TABLE statement against a partitioned table sometimes left inconsistent metadata in the table cache; subsequent SQL statements reusing this metadata failed, and could in some cases also lead to a failure of the server.
- Replication: If a client thread on a slave executed FLUSH TABLES WITH READ LOCK while the master executed a DML, executing SHOW SLAVE STATUS in the same client became blocked, causing a deadlock. The fix ensures that the read lock is only held during the period that the relay log is being updated and the deadlock is avoided.
- Replication: When an XA transaction was active, executing an internal rollback, for example using the BINLOG statement, resulted in an assertion. The fix ensures that a rollback happens only for a slave when a transaction spans multiple binary log files. Rollback does not happen now if the Format_description comes from the BINLOG statement being executed in the MySQL client.
- Replication: In normal usage, it is not possible for a slave to have more GTIDs than the master. But in certain situations, such as after a hardware failure or incorrectly cleared gtid_purged, the master's binary log could be truncated. This fix ensures that in such a situation, the master now detects that the slave has transactions with GTIDs which are not on the master. An error is now generated on the slave and the I/O thread is stopped with an error. The master's dump thread is also stopped. This prevents data inconsistencies during replication.
- Replication: When using SHOW SLAVE STATUS to monitor replication performance, Seconds_Behind_Master sometimes displayed unexpected lag behind the master. This was caused by Previous_gtids_log_events being written to the slave's relay log with a timestamp behind the master, and then being used to calculate the Seconds_Behind_Master. This fix ensures that events generated on the slave that are added to the relay log and are not used when calculating Seconds_Behind_Master.
- On Ubuntu 14.10, MySQL install operations could fail to reload AppArmor.
- EXPLAIN within an XA transaction could raise an assertion.
- Binary log files created by streaming the binary log from a remote server with mysqlbinlog were given an access mode more permissive than the original files.
- If the audit_log plugin encountered a disk-full error, the server would exit.
- Now, if the file system to which the audit log is being written fills up, a “disk full” error is written to the error log. Audit logging continues until the audit log buffer is full. If free disk space has not been made available by the time the buffer fills, client sessions will hang, and stopping the server at the time of client sessions hanging will result in audit log corruption. To avoid this if client sessions are hung, ensure that free space is available on the audit logging file system before stopping the server.
- For failure to create a temporary table due to being out of file descriptors, the server exited rather than returning an error.
- For some queries that contained a derived table (subquery in the FROM clause), delay of materialization resulted in a suboptimal execution plan due to a less accurate row-count estimate.
- For UPDATE and DELETE statements, the server could exit after attempting to access an uninitialized data structure.
- Starting the server with start service or mysqld_safe could result in failure to use the correct plugin directory.
- FLUSH TABLES on a FEDERATED table failed if the table had been idle longer than the wait_timeout time plus the TCP keepalive time.
- Selecting all columns from INFORMATION_SCHEMA.TABLES did not reopen tables if they were in the table cache, but selecting a subset of those columns under the same conditions did reopen tables.
- If my_write() encountered a disk-full condition, it could return an incorrect error value.
- InnoDB boolean full-text searches incorrectly handled + combined with parentheses; for example, +word1 +(>word2 <word3).
- MySQL failed to compile with GCC 4.9.1 in debug mode.
- For debug builds, the server could exit due to an optimizer failure to allocate enough memory for group references.
- The server no longer logs the following warnings because they are uninformative: Client failed to provide its character set. 'charset' will be used as client character set.
- A file created for an internal temporary table could cause problems if the file was orphaned for some reason and the file name was reused for later queries.

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

  • MySQL Community Edition is a freely downloadable version of the world&#39;s most popular open source database that is supported by an active community of open&nbsp;...
    MySQL
    Download MySQL 5.6.23 - 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
  • The linked OpenSSL library for the MySQL Commercial Server has been updated from version 1.0.1j to version 1.0.1k. Issues fixed in the new version are&nbsp;...
    MySQL
    MySQL 5.6 Release Notes :: Changes in MySQL 5.6.23 (2015-02-02 ...
    https://dev.mysql.com
  • MySQL 5.6.23 By MySQL AB (Open Source) User Rating FileHippo Safety Guarantee Secured by Avira Download This Version (44.73MB) Download Advertisement Advertisement Latest Version MySQL 5.6.35 Older Ve...
    MySQL
    MySQL 5.6.23 - FileHippo.com - Download Free Software
    http://filehippo.com
  • Download MySQL Community Server MySQL open source software is provided under the GPL License. ... (mysql-5.6.35-winx64.zip) MD5: 16209ffd139ee572e9ce895d7cd9975d | Signature We suggest that you use th...
    MySQL
    MySQL :: Download MySQL Community Server
    https://dev.mysql.com
  • MySQL Installer provides an easy to use, wizard-based installation experience for all your MySQL software needs. Included in the product are the latest versions of: MySQL Server MySQL Connectors MySQL...
    MySQL
    MySQL :: Download MySQL Installer
    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
  • MySQL 5.6 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization .....
    MySQL
    MySQL :: MySQL 5.6 Reference Manual :: 23.8 MySQL C API
    https://dev.mysql.com
  • ... 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 (2014-12-01,&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
  • Changes in MySQL 5.6.23 (2015-02-02, General Availability) Security Notes Functionality Added or Changed Bugs Fixed Security Notes The linked OpenSSL library for the MySQL Commercial Server has been u...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.23 (2015-02-02, General Availability)
    http://dev.mysql.com
  • Replication: When replicating from a MySQL 5.7.6 or later server to a MySQL 5.6.23 or earlier server, if the older version applier thread encountered an&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.24 ...
    https://dev.mysql.com
  • Changes in MySQL 5.6.23 (2015-02-02, General Availability) &middot; Changes in MySQL 5.6.22 (2014-12-01, General Availability) &middot; Changes in MySQL 5.6.21&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.29 ...
    https://dev.mysql.com
  • Changes in MySQL 5.6.23 (2015-02-02, General Availability) &middot; Changes in MySQL 5.6.22 (2014-12-01, General Availability) &middot; Changes in MySQL 5.6.21&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.32 ...
    https://dev.mysql.com
  • Changes in MySQL 5.6.23 (2015-02-02, General Availability) &middot; Changes in MySQL 5.6.22 (2014-12-01, General Availability) &middot; Changes in MySQL 5.6.21&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.33 ...
    https://dev.mysql.com
  • Changes in MySQL 5.6.23 (2015-02-02, General Availability) &middot; Changes in MySQL 5.6.22 (2014-12-01, General Availability) &middot; Changes in MySQL 5.6.21&nbsp;...
    MySQL
    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.35 ...
    https://dev.mysql.com
  • MySQL Community Downloads MySQL Community Server (GPL) (Current Generally Available Release: 5.7.17) MySQL Community Server is the world&#39;s most popular open source database. Download ...
    MySQL
    MySQL :: MySQL Community Downloads
    https://dev.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