mysql

MySQL 8.0: When to use utf8mb3 over utf8mb4? Long time MySQL users will recognize that there are two varieties of utf8 support in MySQL; utf8mb3 and utf8mb4.  Let me dig a little bit deeper in explaining the history between the two: MySQL 4.1 (2004) was the first version to support character sets and collations. … Source: MySQL 8.0: When to use utf8mb3 over utf8mb4?

MySQL 8.0: It’s doxygen time for MTR Doxygen is a standard tool used for generating software reference documentation. Since the documentation is written within the code, it is relatively easy to keep it up to date. In MySQL 8.0.0, the MySQL source code was documented with Doxygen and now in MySQL 8.0.1, the MySQL Test Framework(MTR) documentation is moved from current infrastructure to Doxygen.… Source: MySQL 8.0: It’s doxygen time for MTR

MySQL InnoDB Cluster in Oracle Public Cloud: A Tutorial – Part 2 In the first part of this series you learned how to setup an InnoDB cluster using Oracle Cloud. In this second part, you are going to learn how and when to use some of the advanced functions available in MySQL Shell.… Source: MySQL InnoDB Cluster in Oracle Public Cloud: A Tutorial – Part 2

MySQL 8.0: GROUPING function Starting with MySQL 8.0.1, the server supports the SQL GROUPING function.  The GROUPING function is used to distinguish between a NULL representing the set of all values in a super-aggregate row  (produced by a ROLLUP operation) from a NULL in a regular row.… Source: MySQL 8.0: GROUPING function

The “Unified Data Dictionary” Lab Release The recent “Unified Data Dictionary Lab Release” quietly delivered an important change to the MySQL server with InnoDB engine: the “InnoDB System Tables” are now officially “decommissioned”. And InnoDB is now deriving its metadata from the new “Transactional Data Dictionary” delivered in 8.0.0 DMR.… Source: The “Unified Data Dictionary” Lab Release