mysql

MySQL InnoDB Cluster GA is Available Now! The MySQL Development Team is happy to announce the first GA release of InnoDB Cluster–our integrated, native, full stack HA solution for MySQL. You can see highlights of the changes and improvements made since the RC release here, and you can download the GA packages from our MySQL APT (Ubuntu, Debian) and YUM (Redhat, OEL, Fedora) repositories or from dev.mysql.com.… Source: MySQL InnoDB Cluster GA is Available Now!

MySQL InnoDB Cluster – What’s New in the GA Release We carefully listened to the feedback we got from the last release candidate and incorporated some of the suggested changes. On top of that, we have fixed several bugs to reach the desired maturity state. Here are the highlights of this release!… Source: MySQL InnoDB Cluster – What’s New in the GA Release

MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows MySQL 8.0.1 introduces two new features which allow you to better manage situations where you have tables with hot row contention.  This issue frequently presents itself in scenarios such as worker threads all accessing the same tables trying to find new work, and ecommerce websites trying to keep accurate inventory counts.… Source: MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows

MySQL 8.0: Improved performance with CTE MySQL 8.0 introduces Common Table Expressions (CTE). My colleague Guilhem has written several blog posts on how to use CTEs , and you can also read about it in the MySQL 8.0 Reference Manual. In this blog post, I will focus on how using a CTE instead of a view or a derived table can improve performance.… Source: MySQL 8.0: Improved performance with CTE

The MySQL 8.0.1 Milestone Release is available The MySQL Development team is happy to announce our 8.0.1 development milestone release (DMR), now available for download at dev.mysql.com. (8.0.1 adds features to 8.0.0). The source code is available at GitHub. You can find the full list of changes and bug fixes in the 8.0.1 Release Notes.… Source: The MySQL 8.0.1 Milestone Release is available