No Image

MySQL Shell 8.0.24 – What’s New?

2021-04-22 KENNETH 0

MySQL Shell 8.0.24 – What’s New? The MySQL team is proud to announce the general availability of version 8.0.24 of the MySQL Shell. In addition to a considerable number of bugs fixed, the following changes were introduced. Improved Command Line Integration Integrating the shell functionality in DevOps operations is a key feature and this release has introduced a big improvement on this area being the most remarkable improvements the following: No longer need to execute APIs using the –execute (-e) command line argument: all of the data required for any API available in CLI can be defined through command line arguments (including lists). … Facebook Twitter LinkedIn Source: MySQL Shell 8.0.24 – What’s New?

No Image

InnoDB: Converting old atomic code to C++11

2021-04-22 KENNETH 0

InnoDB: Converting old atomic code to C++11 Atomics (or GCC intrinsics) were first introduced in InnoDB (5.0) by a patch  from Mark Callaghan’s team at Google for mutexes and rw-locks. InnoDB code then was written in C.  When the code was ported to C++ ,  part of the 5.6 release, there was no C++ standard for atomics.… Facebook Twitter LinkedIn Source: InnoDB: Converting old atomic code to C++11

No Image

The MySQL 8.0.24 Maintenance Release is Generally Available

2021-04-20 KENNETH 0

The MySQL 8.0.24 Maintenance Release is Generally Available The MySQL Development team is very happy to announce that MySQL 8.0.24 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.24 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories.… Facebook Twitter LinkedIn Source: The MySQL 8.0.24 Maintenance Release is Generally Available

No Image

InnoDB Data Locking – Part 5 “Concurrent queues”

2021-04-19 KENNETH 0

InnoDB Data Locking – Part 5 “Concurrent queues” In this blog series, I’m describing how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, and how this was improved in recent releases. So far we saw that access right currently granted and waiting to be granted are represented as record locks and table locks objects in memory, which we can inspect via performance_schema.data_locks.… Facebook Twitter LinkedIn Source: InnoDB Data Locking – Part 5 “Concurrent queues”

No Image

InnoDB Data Locking – Part 4 “Scheduling”

2021-04-16 KENNETH 0

InnoDB Data Locking – Part 4 “Scheduling” In this blog series, I’m describing how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, and how this was improved in recent releases. As we’ve already seen, the order in which server pretends transactions are happening (the serialization order) is tied to the order in which locks are granted to transactions.… Facebook Twitter LinkedIn Source: InnoDB Data Locking – Part 4 “Scheduling”