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 (inc ..read more

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 ..read more

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 ..read more

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 ..read more

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 ..read more

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. In InnoDB Data Locking – Part 1 “Introduction” I’ve introduced basic concepts required to understand current post: databases, tables, rows (like files on a shared drive, spreadsheets inside a file, and rows inside a spreadsheet) serializability of transactions (ability to explain states observed over time with a convincing story about relative order of parallel operations) time ..read more

MySQL Firewall is an enterprise security solution providing ease of mind while protecting your database from rogue queries. Sometimes granting wide-style access privileges may feel a bit too generous, and leaves you wondering whether you could do something more. Join us as we explore Firewall, and (in particular) using Group profiles.… Facebook Twitter LinkedIn ..read more

The MySQL team is proud to announce the general availability of version 8.0.23 of the MySQL Shell. In addition to a considerable number of bugs fixed, the following changes were introduced. Improved Import Table The importTable utility continues getting better, the following enhancements: Multiple file import: it is now supported to load a defined set of files into the same table, glob patterns can be used to determine the files to be loaded. … Facebook Twitter LinkedIn ..read more

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.… Facebook Twitter LinkedIn ..read more

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.… Facebook Twitter LinkedIn ..read more