No Image

Auditing Selection of Classified Data

2020-09-17 KENNETH 0

Auditing Selection of Classified Data The Challenge Often with sensitive information, you need to have an audit log. Not just that a table had a select run, but that specific cells within the table were accessed.  Frequently data such as this will contain a classification level as part of the row, defining policies for how it is handled, audited, etc. … Facebook Twitter LinkedIn Source: Auditing Selection of Classified Data

No Image

InnoDB Data Locking – Part 1 “Introduction”

2020-09-04 KENNETH 0

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”

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