MySQL Engineering Blogs
Further improvements on INFORMATION_SCHEMA in MySQL 8.0.3
Introduction With the transactional data dictionary in MySQL 8.0, see MySQL 8.0: Data Dictionary Architecture and Design , INFORMATION_SCHEMA is reimplemented as views over data dictionary tables. In an earlier post by Gopal Shankar, MySQL 8.0: Improvements to Information_schema , he...
Docker Compose and App Deployment with MySQL
In this post we show how to use the mysql-server Docker image for local development. We first introduce a simple example app that starts up and tries to connect to a given db until successful. We then show how to start containers for multiple MySQL versions and use our example app to connect to...
MySQL event by Romanian Oracle User Group (RoOUG) & MySQL Community team
Our pleasure to announce that MySQL Community team is present at the RoOUG event with two MySQL talks. Please find the details below: Date: December 12, 2017 Place: Bucharest, Romania (Oracle Romania, Floreasca Park, ground floor GF13) Agenda: 18:30 – 18:40 –...
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...
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.