mysql

MySQL 8.0: Storing IPv6 In MySQL 8.0.0 we introduced many new features; among those, we extended the bit-wise operations to work with binary data. Because of these changes, storing and manipulating IPv6 addresses can be done in an easier manner. In this blog we will take a look at how can you do this for some of the most common use cases.… Source: MySQL 8.0: Storing IPv6

MySQL 8.0: MTR Configurations to Be Set to Server Defaults Where Possible MySQL Test Run or MTR for short, is a MySQL test program. It was developed to ensure that the MySQL server’s operation is as expected whether it be in terms of testing the functionality of new features or integrity of the old.… Source: MySQL 8.0: MTR Configurations to Be Set to Server Defaults Where Possible

MySQL 8.0: Improving the Test Framework to avoid skipping tests In MySQL 8.0 we have improved the MySQL Test Framework (MTR) by adding a new no-skip option that avoids skipping tests in regression test runs. Before describing this feature in more detail, let me start with an introduction. Introduction In MTR, we have an existing command called skip.… Source: MySQL 8.0: Improving the Test Framework to avoid skipping tests

Making MySQL Better for Operations In the MySQL team, one of our focuses over the last few releases has been improving the usability of the MySQL Server for operations teams.  The results can be seen in a number of areas: Our continued investment in Performance Schema.   … Source: Making MySQL Better for Operations

MySQL 8.0 Labs: Refactoring and Improving the Parser In 8.0 we have introduced another bunch of parser refactoring worklogs: WL#8067 (me): “Refactoring of the CREATE TABLE statement” with its subtasks: WL#8434: Refactoring of partitioning-related stuff. WL#8435: Cleanup and refactoring column definition stuff. WL#8433: Separate DD commands from regular SQL queries in the parser grammar. … Source: MySQL 8.0 Labs: Refactoring and Improving the Parser