MySQL is a multithreaded, Structured Query Language (SQL) database server. SQL is the most popular database language in the world. MySQL performs very high performance, runs very fast, and is very easy to use. is a very well-held database.
MySQL 5.6 is the new product line. Yesterday, the FTP has been released 5.6.10 download. You can notice that the previous ALPHA,BETA,RC words were removed. Follow the previous practice. (5.5 starting from 5.5.8 GA) Maybe this is the first GA version of 5.6. NOTE: ga-general availability, usually available, refers to the version that can be used in the production environment.
The other product lines are 5.5.30,5.1.68,5.0.96.
5.6 new features include security enhancements, INNODB enhancements, partition enhancements, replication and log enhancements, optimization enhancements, conditional processing, data type changes, host caches, OpenGIS, and more.
Two years after MySQL 5.5 was released, Oracle announced the release of the MySQL 5.6 official version, with the first official release number 5.6.10. In MySQL 5.5, InnoDB was used as the default storage engine, while 5.6 modified the InnoDB engine to provide full-text indexing capabilities, making InnoDB suitable for a variety of applications.
In addition, the performance boost for subqueries is one of the main tasks of MySQL 5.6, with a semi-join (semi-joins) and materialized processing to increase the execution speed of subqueries in 5.6, which means that you do not need to manually replace SQL statements containing subqueries with join operations. In addition, most operations that modify data structures, such as ALTER TABLE, can be executed online, avoiding long-time hangs of the database. The EXPLAIN statement supports execution plan information for the Update/delete/insert statement. Other optimizations for queries include eliminating table scans when using very small limit values.
In terms of replication, MySQL line-oriented replication supports the new row image control, which records only modified columns instead of all the columns in the row, which can save a lot of processing power for some data that contains BLOGs fields, so this improvement not only saves disk space but also improves performance. In addition, "Index Condition pushdown" is a new optimization measure that makes the query attempt to use the indexed field first, and then the WHERE condition.
MySQL 5.6 also introduces a NoSQL interface that provides a memcached-compatible API that gives applications direct access to the InnoDB storage engine. Maintaining consistency with relational database engines is maintained on the ground floor. At the same time, the underlying InnoDB engine also enhances the persistence optimization statistics, multithreading elimination, and the provision of more system tables and monitoring data.
MySQL's product manager, Tomas Ulin, explains the open source community's criticism of Oracle's patch policy, saying: "This is a process of continuous verification, we provide security patches every three months, but most users don't update so often." Users of the community version complained that Oracle did not provide a detailed description of the CVE numbers in the release notes, and they simply pointed to the error code inside Oracle. The company will not post these details.
Official website http://www.mysql.com/
Detailed Description: http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html
Introduction article: Http://dev.mysql.com/tech-resources/articles/mysql-5.6-rc.html
Upgrade Guide: http://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html
MySQL 5.6.11 GA Released, this version mainly on the RPM package in the installation process made some changes, other than bug fixes there are some tools to modify the command.
Also released are MySQL Installer 5.6.11
Update for details http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-11.html
http://www.mysql.com/downloads/mysql/
Download page: http://dev.mysql.com/downloads/mysql/
Official Downloads
Http://mysql.online.bg/Downloads/MySQL-5.1/mysql-5.1.72-win32.msi
Http://mysql.online.bg/Downloads/MySQL-5.1/mysql-5.1.72-winx64.msi
Official Downloads
Http://mirrors.dotsrc.org/mysql/Downloads/MySQL-5.6/mysql-5.6.19-win32.msi
Http://mirrors.dotsrc.org/mysql/Downloads/MySQL-5.6/mysql-5.6.19-winx64.msi