[월:] 2020년 08월

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