In MySQL Server 8.0.23 an improvement was made to InnoDB that allows truncation and deletion of all tablespaces to be faster. In fact, making it almost instantaneous as long as AHI is disabled. This is done by allowing pages in the buffer pool to be freed lazily instead of immediately when a tablespace is deleted.…
Category Archives: MySQL
MySQL Shell AdminAPI – What’s new in 8.0.23?
The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.23!
In addition to several bug fixes and minor changes, some significant enhancements regarding monitoring/troubleshooting and performance were included.
MySQL Shell AdminAPI
Cluster diagnostics
Checking how a Cluster is running and, whenever the cluster is not 100% healthy, perform troubleshooting tasks is certainly one of the main tasks of a DBA.…
The MySQL 8.0.23 Maintenance Release is Generally Available
The MySQL Development team is very happy to announce that MySQL 8.0.23 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.23 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
InnoDB Clone and page tracking
First we will talk about some of the other internal users of the technology that underpins the InnoDB Clone. MySQL Enterprise Backup (MEB) is an enterprise offering that provides backup and recovery for MySQL. Among various types of backups available, the following two types are of interest to us:
Full Backup– A backup that backs up the entire MySQL instance – all the tables in each MySQL database.
InnoDB Data Locking – Part 2.5 “Locks” (Deeper dive)
All together now
Let’s now put together all that we’ve learned in InnoDB Data Locking – Part 2 “Locks” about table and record locks to understand following situation:
Auditing Changes to Classified Data Stored in MySQL 8.0
The Challenge
Often with sensitive information, you need to have an audit log. Frequently data such as this will contain a classification level as part of the row, defining policies for how it is handled, audited, etc. In a prior blog I discussed how to audit the selection of classified data.
… MySQL Audit Data Consolidation – Made Simple
In this blog, I am going to demonstrate how to create your own consolidated audit log archive across many mysql instances. In a followup I’ll show how to extend this example by creating a simple hash chain on that archive – so you can prove whether or not its been modified or tainted in any way and if so where.…
The MySQL 8.0.22 Maintenance Release is Generally Available
The MySQL Development team is very happy to announce that MySQL 8.0.22 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.22 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
InnoDB Data Locking – Part 2 “Locks”
In InnoDB Data Locking – Part 1 “Introduction” we’ve described the difficulties Lock System tries to solve using metaphor of people trying to concurrently edit spreadsheets. While it might be useful metaphor to get some intuitions about the problem, to talk about solutions it helps to know at least a little about the “reality” this metaphor maps to.…
Auditing Selection of Classified Data Stored in MySQL 8.0
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.
…