mysql

MySQL Shell 8.0.13 – What’s New? The MySQL Development team is proud to announce a new version of the MySQL Shell which in addition to the usual bug fixes and enhancements to the existing components,  offers new features we expect are quite useful in your day to day work.… Source: MySQL Shell 8.0.13 – What’s New?

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

MySQL : InnoDB Transparent Tablespace Encryption From MySQL 5.7.11, encryption is supported for InnoDB (file-per-table) tablespaces. This is called Transparent Tablespace Encryption or sometimes referred as Encryption at Rest. This blog post aims to give the internal details of InnoDB Tablespace Encryption. Keyring Plugin : Why What How ?… Source: MySQL : InnoDB Transparent Tablespace Encryption

What is the “(scanning)” variant of a loose index scan? A query plan uses loose index scan if “Using index for group-by” appears in the “Extra”  column of the EXPLAIN output. In some plans though, “Using index for group-by (scanning)” appears. What does “(scanning)” mean and how is it different from the regular loose index scan?… Source: What is the “(scanning)” variant of a loose index scan?

JSON_TABLE – The Best of Both Worlds One of the new JSON functions in MySQL 8.0 is JSON_TABLE. It is also MySQL’s first table function. That is, the return value is not a scalar value, but a result set. JSON_TABLE will convert (part of) a JSON document into a relational table.… Source: JSON_TABLE – The Best of Both Worlds