mysql

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 concurrency.… Facebook Twitter LinkedIn Source: InnoDB Data Locking – Part 1 “Introduction”

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!… Facebook Twitter LinkedIn Source: MySQL Shell Dump & Load part 4: Dump Instance & Schemas

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.… Facebook Twitter LinkedIn Source: New Consistency for Datafile Locations in MySQL 8.0.21

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.… Facebook Twitter LinkedIn Source: Improvements to Undo Truncation in MySQL 8.0.21

MySQL Shell Dump & Load part 2: Benchmarks This is part 2 of the blog post series about MySQL Shell Dump & Load: MySQL Shell Dump & Load part 1: Demo! 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.… Facebook Twitter LinkedIn Source: MySQL Shell Dump & Load part 2: Benchmarks