emGee Software Solutions Custom Database Applications

Share this

MySQL Server Blog

News from the MySQL Server Team
Updated: 1 week 18 hours ago

MySQL : InnoDB Transparent Tablespace Encryption

Thu, 10/04/2018 - 00:12

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 ?

Categories: Web Technologies

What is the “(scanning)” variant of a loose index scan?

Wed, 09/26/2018 - 04:01

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

Categories: Web Technologies

JSON_TABLE – The Best of Both Worlds

Sun, 09/16/2018 - 01:25

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

Categories: Web Technologies

MySQL Shell 8.0.12 – What’s New?

Wed, 08/29/2018 - 08:50
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 password for the session will be made available.…

Categories: Web Technologies

Getting Help in MySQL Shell

Wed, 08/29/2018 - 08:49

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 use specific elements of the application while working with it, this is what the centralized help system does.…

Categories: Web Technologies

The MySQL 8.0.12 Maintenance Release is Generally Available

Fri, 07/27/2018 - 11:10

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

Categories: Web Technologies

MySQL Shell 8.0.12 – storing MySQL passwords securely

Fri, 07/27/2018 - 05:00

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 do not need to include plain text passwords.…

Categories: Web Technologies

MySQL Guide to Ports

Mon, 07/09/2018 - 12:44

There could be from one to over ten ports used within your MySQL ecosystem.  It really depends on what you have enabled, which components you are using, how your applications connect, and other characteristics of your environment.

From a security point, these ports need to be opened just wide enough to allow the various components  that should communicate to talk while blocking out anything else trying to hack its way in – the goal being to enforce the security principle of “least privilege”. …

Categories: Web Technologies

MySQL 8.0: Support for BLOBs in TempTable engine

Thu, 07/05/2018 - 20:27

In some cases, the server creates internal temporary tables while processing statements. These tables could be stored in memory or on disk – the first option is preferred but there exist some limitations. One of such restrictions was presence of TEXT or BLOB columns in the table; as in-memory storage engines (MEMORY and TempTable) did not supported these types server had to use the on-disk engine (InnoDB or MyISAM).…

Categories: Web Technologies

Audit Log’s JSON format logging

Thu, 07/05/2018 - 00:08

Blood, sweat, tears and the JSON format logging is finally supported by the Audit Log plugin. This comes in pair with the feature that allows to read log events, which could be useful for rapid analysis of the audit log trail without the need of accessing the files directly.…

Categories: Web Technologies

Upgrading to MySQL 8.0 with Spatial Data

Mon, 07/02/2018 - 02:54

The big change from MySQL 5.7 to 8.0 when it comes to spatial data, is the support for multiple spatial reference systems and geographic computations. This means that the SRIDs of geometries actually have meaning and affect computations. In 5.7 and earlier, however, the SRIDs are ignored, and all computations are Cartesian.…

Categories: Web Technologies

Detecting Incompatible Use of Spatial Functions before Upgrading to MySQL 8.0

Thu, 06/28/2018 - 10:01

There are many changes to spatial functions in MySQL 8.0:

The first two are failing cases.…

Categories: Web Technologies