MySQL 5.7.4 doubled query performance

MySQL5.7.4 development version released: dev. mysql. comdownloadsmysql # downloads has a long history. The main purpose of MySQL is to be able to run on a single-processor core commercial server. Today, users of a MySQL change may not pay attention to the release of MySQL 5.7.4 development edition.

: Http://dev.mysql.com/downloads/mysql/#downloads

From a long history, MySQL aims to run on a single-processor core commercial server. One change in MySQL users may not notice today, that is, Oracle has begun to rebuild MySQL code, making it a lot of modular. Such as the software parser, the optimization and replication functions are rewritten in a modular form.
The query performance of this version is greatly improved, doubled from MySQL 5.6. for details, see Change History.

The new version of MySQL can reach 512000 read-only QPS per second on the test platform, while MySQL 5.6 can only reach 250000 QPS at most. This performance improvement is achieved through its Memcached plug-in. At the same time, this version has also been improved in other aspects of the database, such as reducing the time for establishing database connections, thanks to Facebook's contribution. In addition to performance improvement, there are also many improvements in other aspects. For more information, see here.

MySQL features

• It is written in C and C ++ and tested using multiple compilers to ensure source code portability.
• Supports multiple operating systems, including AIX, BSDi, FreeBSD, HP-UX, Linux, Mac OS, Novell Netware, NetBSD, OpenBSD, OS/2 Wrap, Solaris, SunOS, and Windows.
• Provides APIs for multiple programming languages. These programming languages include C, C ++, C #, Delphi, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl.
• Supports multithreading, making full use of CPU resources, and supporting multiple users.
• The optimized SQL query algorithm effectively improves the query speed.
• It can be used as a separate application in the client server network environment, and can also be embedded into other software as a library.
• Supports multiple languages. common codes such as Chinese GB 2312, BIG5, and Japanese Shift_JIS can be used as data table names and data column names.
• Provides multiple database connection methods, such as TCP/IP, ODBC, and JDBC.
• Provides management tools for managing, checking, and optimizing database operations.
• It can process large databases with tens of millions of records.

Chinese MySQL documentation: http://tool.oschina.net/apidocs/apidoc? Api = mysql-5.1-zh

MySQL documentation: http://tool.oschina.net/apidocs/apidoc? Api = mysql-5.5-en