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 concurrency.…
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 throughput up to 3GB/s!…
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 settings: datadir, innodb_data_home_dir, innodb_undo_directory & innodb_directories.…
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.…
MySQL Shell Dump & Load part 3: Load Dump
Introduced in MySQL Shell 8.0.21, the new MySQL Shell Dump and Load utilities has as its main goal to minimize the time needed to create and restore logical dumps of large data sets.
Through heavy parallelization and other techniques, we were able to reduce the time needed for these tasks by an order of magnitude compared to previous dump utilities.…
MySQL Shell Dump & Load part 2: Benchmarks
This second part about the new MySQL Shell Dump & Load utilities aims to demonstrate the performance while also comparing it with various other logical dump and load tools available: mysqldump
, mysqlpump
& mydumper
.
To make the numbers more meaningful, I used several real world production datasets that are available online: stackoverflow.com…
MySQL Shell Dump & Load part 1: Demo!
MySQL Shell 8.0.21 includes some exciting new utilities to create a logical dump and do a logical restore, with a focus on ease of use, performance and integration. In MySQL Shell 8.0.17, we already introduced a multi-threaded CSV import utility util.importTable()
…
What’s New in MySQL Shell 8.0.21
The MySQL team is proud to announce the general availability of version 8.0.21 of the MySQL Shell.
MySQL Shell Logical Dump and Load Utilities
A new suite of logical dump utilities was introduced in MySQL Shell 8.0.21.
util.dumpInstance(), util.dumpSchemas() and util.loadDump()…
Hiding instances on MySQL InnoDB Cluster/ReplicaSet
MySQL Router is a core component of InnoDB Cluster/ReplicaSet that enables the automatic routing of client traffic to the right instances of your database architecture. Router can automatically adapt to topology changes, however, there are some scenarios on which one would certainly benefit from having the possibility to tag an instance with a certain attribute that indicates a specific behavior change to Router’s default behavior.…
MySQL Shell AdminAPI – What’s new in 8.0.21?
The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.21!
As always, we have listened to the growing community of users and introduced a very useful feature for any production deployment of MySQL InnoDB Cluster or ReplicaSet.…