🐬 MySQL 8.0.31 Boosted Index Building Speed

MySQL comes with some massive improvements in the database competition with PostgreSQL

MySQL is a popular relational database engine developed currently by Oracle. If you are not up to date, just a reminder: Sun bought MySQL for $1 billion in 2008, and two years later Oracle bought Sun for $7,4 billion.

That surprising turn of events didn't seem to impact MySQL development. The latest version is 8.0.31 and it comes packed with features and bug fixes. Here are the three most interesting ones:

Faster InnoDB Index Building

With that release MySQL supports parallel index builds specifically by multithreaded B-tree feeding.

Nested Order By And Limit

You can now write nested queries in accordance with SQL standard. In the Parenthesized Query Expressions you will find the details about how the new nesting will behave.

Intersect and Except

The two new clauses make it easier to find common rows between tables, or contrary ,to…