No Image

MySQL Shell Dump & Load part 4: Dump Instance & Schemas

2020-08-07 KENNETH 0

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

No Image

New Consistency for Datafile Locations in MySQL 8.0.21

2020-08-06 KENNETH 0

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

No Image

Improvements to Undo Truncation in MySQL 8.0.21

2020-08-06 KENNETH 0

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

No Image

MySQL Shell Dump & Load part 2: Benchmarks

2020-08-04 KENNETH 0

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

No Image

MySQL Shell Dump & Load part 1: Demo!

2020-08-04 KENNETH 0

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()… Facebook Twitter LinkedIn Source: MySQL Shell Dump & Load part 1: Demo!