MySQL Shell 8.0.19 – What’s New?

January 13, 2020MySQLRene Ramirez

The MySQL Development team is proud to announce version 8.0.19 of the MySQL Shell, with the following features:

Admin API
- MySQL InnoDB ReplicaSet
- MySQL Router Management Functions
- Metadata Upgrade
- Router Management Functions
Shell JavaScript Plugins: require() function enhancements.
Upgrade Checker Updates

MySQL InnoDB ReplicaSet

Similar to MySQL InnoDB Cluster (based on Group Replication), this release of the Shell introduces the MySQL InnoDB Replicaset which provides an easy to use management solution for MySQL Replication.…

MySQL Shell AdminAPI – What’s new in 8.0.19?

January 13, 2020DevOps, High Availability, MySQL, ShellMiguel Araújo

The MySQL Development Team is thrilled to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.19!

This release sets the bar higher, by introducing a new integrated solution based on a very well known Replication technology – MySQL InnoDB ReplicaSet!…

The all new MySQL InnoDB ReplicaSet

January 13, 2020DevOps, High Availability, MySQL, Router, ShellKenny Gryp

Following MySQL InnoDB Cluster as our first, fully integrated MySQL High Availability solution based on Group Replication, MySQL Shell 8.0.19 includes MySQL InnoDB ReplicaSet which delivers another complete solution, this time based on MySQL Replication.

The basic idea for InnoDB ReplicaSet is to do the same for classic MySQL Replication as InnoDB Cluster did for Group Replication.…

The MySQL 8.0.19 Maintenance Release is Generally Available

January 13, 2020MySQLGeir Hoydalsvik

The MySQL Development team is very happy to announce that MySQL 8.0.19 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.19 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…

Antijoin in MySQL 8

December 18, 2019Benchmarking, MySQL, Optimizer, SQLGuilhem Bichot

In MySQL 8.0.17, we made an observation in the well-known TPC-H benchmark for one particular query. The query was executing 20% faster than in MySQL 8.0.16. This improvement is because of the “antijoin” optimization which I implemented. Here is its short mention in the release notes:

“The optimizer now transforms a WHERE condition having NOT IN (subquery), NOT EXISTS (subquery), IN (subquery) IS NOT TRUE, or EXISTS (subquery) IS NOT TRUE internally into an antijoin, thus removing the subquery.”…

Hash join in MySQL 8

November 13, 2019MySQL, OptimizerErik Frøseth

For a long time, the only algorithm for executing a join in MySQL has been variations of the nested loop algorithm. With the release of MySQL 8.0.18, the server can now execute joins using hash join. This blog post will have a look at how it works, when it is used, and how it compares to the old join algorithms in MySQL in terms of performance.…

InnoDB : Tablespace Space Management

November 8, 2019MySQLMayank Prasad

A user defined table and its corresponding index data, in InnoDB, is stored in files that have an extension .ibd. There are two types of tablespaces, general (or shared) tablespace and file-per-table. For shared tablespaces, data from many different tables and their corresponding indexes may reside in a single .ibd…

MySQL Keyring now speaks Hashicorp Vault

October 21, 2019Enterprise, MySQL, Plugins, SecurityHashicorp Vault, keyringIvan Švaljek

As an intro to his performance act, an “old school” entertainer Victor Borge once famously asked the audience: “Do you care for piano music?“, which was greeted by a crowd, only to be immediately followed by a self-ironic punch line – “Too bad.”…

Pages: 1 2 3

MySQL EXPLAIN ANALYZE

October 17, 2019MySQL, Optimizer, Performance, SQLNorvald H. Ryeng

MySQL 8.0.18 was just released, and it contains a brand new feature to analyze and understand how queries are executed: EXPLAIN ANALYZE.

What is it?

EXPLAIN ANALYZE is a profiling tool for your queries that will show you where MySQL spends time on your query and why.…

MySQL Shell 8.0.18 – What’s New?

October 16, 2019MySQLRene Ramirez

The MySQL Development team is proud to announce a new version of the MySQL Shell with the following major improvements:

Migration to Python 3
Built-in thread reports
Ability to use an external editor
Ability to execute system commands within the shell
Admin API Improvements:
- New options to log all the SQL used on the different operations
- Support for IPv6 in InnoDB Clusters
- New function to reset the InnoDB Cluster recovery accounts
General maintenance and bug fixing

Python 3 Migration

Due to the coming end-of-life (EOL) for Python 2.7

…

MySQL Server Blog

News from the MySQL Server Team