MySQL 5.7: 3x Faster

The MySQL Database powers the most demanding Web, E-commerce and Online Transaction Processing (OLTP) applications. It is a fully integrated transaction-safe, ACID compliant database with full commit, rollback, crash recovery and row level locking capabilities. MySQL delivers the ease of use, scalability, and performance that has made MySQL the world's most popular open source database. Some of the world's most trafficked websites like Facebook, Google, Twitter, Uber, and rely on MySQL for their business critical applications.

MySQL 5.7 includes significant performance and high availability improvements enabling the next generation of web, embedded and Cloud applications.

MySQL Database 5.7 delivers:

  • New! JSON Support using a native binary format for efficient processing & storage
  • New! Multi-source Replication enabling a replication slave to receive transactions from multiple sources simultaneously
  • New! Optimizer Cost Model resulting in better query performance
  • New! Query Rewrite Plugin to specify how certain queries that arrive at the server should be rewritten
  • New! Sys Schema providing easy to understand views with insights into MySQL health
  • New! GIS Spatial Extensions for mobile applications and location based services
  • New! InnoDB Transparent Page Level Compression with support for Zlib and LZ4
  • New! InnoDB Native Partitioning reducing memory requirements by up to 90%
  • Improved! 3x faster with read-only performance of 1.6 million queries/second on Linux
  • Improved! InnoDB Native Full Text Search with better performance and support for Chinese, Japanese, and Korean
  • Improved! Performance Schema with better instrumentation and lower overhead
  • Improved! Security through safer initialization, enhanced data encryption, better password handling and more
  • Improved! Replication enhancements including GTIDs, semi-synchronous replication, performance schema tables, and dynamic replication filters
  • Reliability requiring little or no intervention to achieve continuous uptime
  • Ease of use with "3 minutes from download to development" installation and configuration
  • Low administration with very little database maintenance required
  • Replication providing flexible topologies for scale-out and high availability
  • Partitioning to improve performance and management of very large database environments
  • ACID Transactions to build reliable and secure business critical applications
  • Stored Procedures to improve developer productivity
  • Triggers to enforce complex business rules at the database level
  • Views to ensure sensitive information is not compromised
  • Information Schema to provide easy access to metadata
  • Pluggable Storage Engine Architecture for maximum flexibility

Additional Resources