mysql

MySQL 8.0 Labs – Descending Indexes in MySQL Starting with the 8.0 optimizer labs release the MySQL server now supports descending indexes. As I will detail in this post, this new feature can be used to eliminate the need for sorting results, and lead to performance improvements in a number of queries.… Source: MySQL 8.0 Labs – Descending Indexes in MySQL

MySQL 8.0 Data Dictionary: Background and Motivation Just as you use a database like MySQL to store your application data, MySQL must also store its meta data (schema names, table definitions etc) somewhere. Traditionally this meta data storage has been split between many different locations (.FRM, .PAR, .OPT, .TRN and .TRG files).… Source: MySQL 8.0 Data Dictionary: Background and Motivation

MySQL 8.0 Labs: JSON aggregation functions In MySQL 5.7 we introduced JSON functionality into the MySQL Server. This work included the introduction of a JSON data type, virtual columns and a set of approximately 20 SQL functions that allow you to manipulate and search JSON data on the server side.… Source: MySQL 8.0 Labs: JSON aggregation functions

Connector/Python 2.1 Connector/Python 2.1 (2.1.4 GA, published on Thursday, 06 Oct 2016) Source: Connector/Python 2.1

MySQL 8.0: Scaling and Performance of INFORMATION_SCHEMA Overview MySQL 8.0 comes with the new design of INFORMATION_SCHEMA subsystem. The blog MySQL 8.0: Improvements to Information_schema provides an overview of the improvements we made. This blog focuses mainly to demonstrate performance of the INFORMATION_SCHEMA in MySQL 8.0, giving us an idea on the kind of performance gain that one can expect.… Source: MySQL 8.0: Scaling and Performance of INFORMATION_SCHEMA