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

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.…

Container Testing for MySQL Server
Traditionally infrastructure management is a manual task, with sysadmins managing rather static servers. The automation capabilities of modern cloud platforms have changed this way of working: Infrastructure is often described “as code,” e.g. in a git repository, and changes are made by...

MySQL Shell 8.0.12 – What’s New?
Pluggable Password Store This feature which is enabled by default, allows the Shell using an external component “Secret Store”, to persist session passwords in a secure way. Whenever a new session is created while working with the shell in interactive mode, the option to persist the...

Getting Help in MySQL Shell
The MySQL Shell has a collection of commands and APIs that allow performing a variety of tasks on MySQL instances  interactively or through scripts. Although there’s documentation for the JavaScript and Python APIs as well as the User Guide, it comes handy being able to get help about how to...

MySQL @Oracle Developer Community LAD Tour 2018
We are happy to announce that MySQL got an opportunity to be part of the Oracle Developer Community LAD Tour 2018 on the last minute notice. The event is hold on Aug 24 @ Mexico City, Mexico you will can - among other interesting talks - also to find a MySQL talk given by the local Sales...

The MySQL 8.0.12 Maintenance Release is Generally Available
The MySQL Development team is very happy to announce that MySQL 8.0.12, the first 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, most notably the InnoDB instant add column feature. …

MySQL Shell 8.0.12 – storing MySQL passwords securely
MySQL Shell 8.0.12 introduces a new feature which allows users to store and automatically retrieve their MySQL account credentials. This enables them to seamlessly work with various servers without explicitly providing the password for each new connection and create secure unattended scripts which...