InnoDB Data Locking – Part 1 “Introduction”
In this blog series, I’d like to introduce you gently to the topic on which I was working last 2 years, which is improving how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, while in reality there is a lot of...

Migrate from on premise MySQL to MySQL Database Service
If you are running MySQL on premise, it's maybe the right time to think about migrating your lovely MySQL database somewhere where the MySQL Team prepared a comfortable place for it to stay running and safe. This awesome place is MySQL Database Service in OCI. For more information about what...

MySQL Database Service - Webinar Series
We have scheduled a series of several live webinars about MySQL Database Service, the only service 100% developed, managed and supported by the MySQL Team.   Our webinars will cover a full introduction to the new service.  We will discuss the business benefits of using the MySQL Database...

Introducing the MySQL Database Service
The MySQL team is thrilled to introduce the MySQL Database Service in the Oracle Cloud Infrastructure (OCI), the only service 100% developed, managed, and supported by the MySQL Team. For those not familiar with MySQL Database Service, it is the same MySQL you know and use, now available in the...

MySQL Shell Dump & Load part 4: Dump Instance & Schemas
MySQL Shell 8.0.21 comes with two utilities which can be used to perform logical dumps of all the schemas from an instance (util.dumpInstance()) or selected schemas (util.dumpSchemas()). These tools offer major performance improvements over the mysqldump utility, some of our benchmarks show a...

New Consistency for Datafile Locations in MySQL 8.0.21
When you create a general tablespace in MySQL 8.0, you can choose the directory where the associated datafile is created. CREATE TABLESPACE tablespace_name ADD DATAFILE ‘/my/table/space/dir’; However, that directory must be known to InnoDB. Known directories are defined by the following...

Improvements to Undo Truncation in MySQL 8.0.21
Undo Tablespaces can be truncated either implicitly or explicitly in MySQL 8.0. Both methods use the same mechanism. This mechanism could cause periodic stalls on very busy systems while an undo tablespace truncate completes. This problem has been fixed in MySQL 8.0.21.…

Top Blog Posts about MySQL 8.0.21
As with any new releases, MySQL 8.0.21 introduces many new improvements and updates, many of which deserve their own blog post for a deep dive into the new features.  Among the notable changes are: Account Management Notes, JSON Notes, Authentication Notes and changes related to InnoDB,...