mysql

The MySQL 8.0.4 Release Candidate is available The MySQL Development team is very happy to announce that MySQL 8.0.4, the second 8.0 Release Candidate (RC2), is now available for download at dev.mysql.com (8.0.4 adds features to 8.0.3, 8.0.2, 8.0.1 and 8.0.0). The source code is available at GitHub.… Source: The MySQL 8.0.4 Release Candidate is available

Row numbering, ranking: how to use LESS user variables in MySQL queries User variables, even though not part of standard SQL, are great objects in MySQL. They allow to keep some “state” for the life of a session: a session can execute a statement to compute a value, store that value in a user variable, and use it in all next  statements.… Source: Row numbering, ranking: how to use LESS user variables in MySQL queries

MySQL 8.0: Query Optimizer Takes Data Buffering into Account In earlier versions of MySQL, the query optimizer did not distinguish between data that was cached in the database buffer and data that had to be read from disk. The main reason was that the optimizer had no information about whether a table would have to be (partially) read from disk or already was present in the buffer pool.… Source: MySQL 8.0: Query Optimizer Takes Data Buffering into Account

MySQL 8.0 Collations: Migrating from older collations, Part 2 In my blog MySQL 8.0 Collations: Migrating from older collations I showed a query that could identify the values that might break a unique constraint when migrate your data. That query was not very efficient due to the self join of the converted values.… Source: MySQL 8.0 Collations: Migrating from older collations, Part 2