No Image

InnoDB Data Locking – Part 2.5 “Locks” (Deeper dive)

2020-11-23 KENNETH 0

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: mysql> BEGIN; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM t FOR SHARE; +—-+ | id | +—-+ | 5 | | 10 | | 42 | +—-+ 3 rows in set (0.00 sec) mysql> DELETE FROM t WHERE id=10; Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t VALUES (4); Query OK, 1 row affected (0.00 sec) mysql> SELECT INDEX_NAME,LOCK_TYPE,LOCK_DATA,LOCK_MODE FROM performance_schema.data_locks … Facebook Twitter LinkedIn Source: InnoDB Data Locking – Part 2.5 “Locks” (Deeper dive)

No Image

Auditing Changes to Classified Data Stored in MySQL 8.0

2020-11-18 KENNETH 0

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. … Facebook Twitter LinkedIn Source: Auditing Changes to Classified Data Stored in MySQL 8.0

No Image

MySQL Audit Data Consolidation – Made Simple

2020-11-04 KENNETH 0

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.… Facebook Twitter LinkedIn Source: MySQL Audit Data Consolidation – Made Simple

No Image

What’s New in MySQL Shell 8.0.22

2020-10-20 KENNETH 0

What’s New in MySQL Shell 8.0.22 MySQL Shell 8.0.22 has just been released and is now available for download. In addition to bug fixes and minor changes described in the Release Notes, some more significant enhancements were also included. Dump and Load Utilities importTable: Custom Data Transformations The importTable utility now supports applying arbitrary data transformations to imported data.… Facebook Twitter LinkedIn Source: What’s New in MySQL Shell 8.0.22

No Image

The MySQL 8.0.22 Maintenance Release is Generally Available

2020-10-19 KENNETH 0

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.… Facebook Twitter LinkedIn Source: The MySQL 8.0.22 Maintenance Release is Generally Available