MySQL Engineering Blogs
Optimization to skip index dives with FORCE INDEX.
Index dives are performed during the optimization phase to help decide which index to use. Currently when user specifies FORCE INDEX, optimizer still always calculates cost using index dives. Under some circumstances it is possible to avoid the index dives and this could speed up execution.…
MySQL Adds Fedora 27 Support
Fedora 27 is here, and we congratulate the Fedora community on another rev of one of the most popular Linux distros out there. Continuing our tradition of supporting new Linux distro versions from day one, we have added the following MySQL products to our official MySQL yum repos: MySQL Server...
New optimizer hint for changing the session system variable.
In MySQL 8.0.3, we have introduced a new optimizer hint called SET_VAR. This hint allows to change the value of a system variable for a single query. Earlier, changing a system variable for a single query would require four steps:1) Store current value.…
Contention-Aware Transaction Scheduling Arriving in InnoDB to Boost Performance
Authors: Sunny Bains, Jiamin Huang (University of Michigan) What is Transaction Scheduling? Locking is one of the most popular mechanisms for concurrency control in most database systems, including Oracle MySQL. One major question, however, seems to have been overlooked by all database vendors: Q:...
MySQL 8.0.3: Binary logging and Replication chains are now enabled by default
MySQL 8.0.3 release candidate is out with amazing new replication features, along with changes in couple of replication default options. Thanks to our users for their constant feedback and valuable inputs, MySQL is changing defaults whenever possible to remove configuration overhead for practical...
Efficient JSON Replication in MySQL 8.0
MySQL is not only a relational database, but can also be used as a schemaless/NOSQL document store, or a mix of both. This is realized by the JSON datatype, and is useful for any data that is hard to fit in the ”tabular” format of a traditional table.…
MySQL Enterprise Monitor 4.0.1 has been released
We are pleased to announce that MySQL Enterprise Monitor 4.0.1 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. MySQL Enterprise Monitor is the best-in-class tool for monitoring and...
“Look: I/O thread is waiting for disk space!”
MySQL 8.0.1 introduced a work with replication threads mutexes in order to improve performance. In MySQL 8.0.2 the same work was extended, focusing in usability, and revamped how replication deals with disk-full conditions, improving the responsiveness of both monitoring commands and administrative...
MySQL Community Server
- MySQL Workbench 6.3
- Connector/Net 6.10
- Connector/Net 6.9
- MySQL Cluster 7.5
- MySQL Cluster 7.4
Which backup features do you require for your MySQL database backups?
"The Documents contained within this site may include statements about Oracle's product development plans. Many factors can materially affect Oracle's product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.