Quick Peek at MySQL 8.0.32Recently Oracle released new versions of their software and there are some things of note. MySQL 8.032 is not a major change but you do need to be aware of some changes just in case they have the potential to send you into the court of Murphy’s Law. So let’s look through the release notes to see what is new, changed, and deprecated.

My own comments are in italics and reflect the views of neither Percona nor anyone else. Percona’s release of ‘32 is in the works as we have to add the features Percona provides such as enterprise features (data masking, connection pooling, RocksDB, and much more).

The following items caught my eye as either interesting or ‘I need to add this to my to-do list’.

No more leading dollar signs for table names

Almost all supported

“The MySQL ST_Transform() function now supports all Cartesian projections, with the exceptions of EPSG 1042 (Local Northing), EPSG 1043 (Local Easting), EPSG 9816 (Tunisia Mining Grid), and EPSG 9826 (Lambert Conic Conformal (West Orientated)).”

So what is wrong with Tunisia Mining Grid – I have all their albums!

EXPLAIN_FORMAT

You can now set a default output format for EXPLAIN.

EXPLAIN ANALYZE still only supports tree format.

Something to look forward to when we see EXPLAIN ANALYZE in JSON or TRADITIONAL, I guess.

Open SSL

Now uses Open SSL version 1.1.1s

Big 5.7 upgrade issue fixed

“Upgrading from MySQL 5.7 to MySQL 8.0 with a very large number of tables in a single database caused the server to consume excessive memory. It was found that, during the process of checking whether tables could be upgraded, we fetched all the data dictionary Table objects upfront, processing each and fetching its name, then performed CHECK TABLE … FOR UPGRADE on the list. Fetching all objects beforehand was not necessary in this case, and contributed greatly to memory consumption.

To correct this problem, we now fetch one Table object at a time in such cases, performing any required checks, fetching its name, and releasing the object, before proceeding with the next one. (Bug #34526001)“

I occasionally ran into folks with the problem who solved it in a variety of less-than-satisfactory ways or decided to stay with 5.7. With the demise of 5.7 on the horizon, this hopefully will be the last issue for some.

Well *!

“Use of a wild card as a column identifier in an INSERT statement was allowed by the parser even though the syntax is not supported, which led to an assert in debug builds and a silent rejection of the statement in release builds. This construction has been removed as a possibility from the grammar and is now handled strictly as a syntax error. “

Summary

With 122 bugs fixed, MySQL 8.0.32 is an evolution of the product that shows some solid engineering from the Oracle MySQL engineers. There is nothing earth-shattering included with this release but it does make for a better database server.

Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments