mysql

Bootstrapping the transactional data dictionary In a previous blog post, we discussed how the initialization and restart of the MySQL server has changed between versions 5.6, 5.7 and 8.0. Now, we will take a closer look at MySQL 8.0 to explain in more detail how the transactional data dictionary is bootstrapped.… Source: Bootstrapping the transactional data dictionary

Importing Data from MongoDB to MySQL: BSON Data Types The latest release of the MySQL Shell 8.0.14 (GA) improved the JSON import utility to support the conversion of more BSON data types from the strict mode representation of MongoDB Extended JSON. This removes a previous limitation regarding the import of more complex MongoDB data types to MySQL, making it more reliable.… Source: Importing Data from MongoDB to MySQL: BSON Data Types

What is LOAD DATA and how does it work I would like to highlight a less known MySQL SQL command, analyze how it works and understand some of the decisions that need to be made when using it. Let’s start with the basics: The Reference Manual. It does have a lot to say about LOAD DATA.… Source: What is LOAD DATA and how does it work

Support for LATERAL derived tables added to MySQL 8.0.14 In the just-released MySQL 8.0.14 I added a feature called LATERAL derived tables. The manual describes the syntax and has examples of how the feature can be used to find greatest values in tables. In the present post I’m going to consider a different problem solved by LATERAL: let’s say that we have a bunch of nodes, and want to make a “random graph”, by connecting every node to other nodes.… Source: Support for LATERAL derived tables added to MySQL 8.0.14

The complete list of new features in MySQL 8.0 There are over 250 new features in MySQL 8.0. The MySQL Manual is very good, but verbose. This is a list of new features in short bullet form. We have tried very hard to make sure each feature is only mentioned once.… Source: The complete list of new features in MySQL 8.0