Oracle recently released the latest MySQL 5.7 branch Development Milestone version (DMR version)-MySQL 5.7.2. This version provides faster connection speeds, higher transaction throughput, higher replication speeds, and memory instruments and other enhancements to achieve higher performance and enhanced manageability.
1. performance and scalability enhancements MySQL 5.7.2 DMR provides: 1. In the Sysbench test for InnoDB read-only queries, the speed can reach 500,000 queries per second, before (250,000) 2. linearly extended to 64 CPU threads 3. Improved replication throughput: the new multi-threaded transactional replication event handler is used in the thread, it can also run complex transactions in parallel work threads.
2. manageability enhancement 1. Improved the online modification function of data tables: You can rename indexes online and expand varchar data types. 2. New Memory instruments: supports tracking of memory allocation and usage in mysqld. 3. Storage program instruments: Provides execution details of internal commands of the storage program. 4. You can use get stacked diagnostics as a new tool, create and clear diagnostic information in the storage program 5. Improve the dynamic control of the trigger: multiple triggers can be applied to an event type in the same table. 6. Real-time execution Analysis 7. Improved JSON Explain Data: you can add parameters such as total query cost, single table query cost, and total data volume to the optimizer for more detailed information.
3. Other 1. MySQL 5.7.2 DMR also provides lossless semi-synchronous replication to ensure that the transaction is committed only to the storage engine and is embodied in the master server only after receiving confirmation from the server. 2. mysqlfabric tool in MySQL Utilities 1.4.0 can be expanded through sharding. 3. Multi-source MySQL replication: allows an slave server (slave) to aggregate data from multiple master servers.
Changes in MySQL 5.7.2: http://dev.mysql.com/downloads/mysql/#downloads