InnoDB has been the default storage engine for MySQL since version 5.5 (July 2010!). If you are still using MyISAM as the storage engine for your tables, it might be time to consider migrating to InnoDB. InnoDB offers several advantages over MyISAM: <!– wp:list {"className":"","epStylingOptions":{"columnsResponsiveEnabled":false,"columnsHoverEnabled":false,"itemsSpacingResponsiveEnabled":false,"itemsSpacingHoverEnabled":false,"listStyleResponsiveEnabled":false,"listStyleHoverEnabled":false,"listIconResponsiveEnabled":false,"listIconHoverEnabled":false,"columns":{"target":"","responsive":true,"hover":true,"options":[{"custom":true,"control":"ToggleOptions"},{"label":"Columns","control":"Range","attribute":"columns","css":"grid-template-columns","customValue":"repeat({{value}}, …
[Read more]This is the first in a new series of articles about MySQL books that might be included in the library of a MySQL DBA or developer interested in MySQL. Let’s start with MySQL Workshop, a practical guide to working with data and managing databases with MySQL written by Thomas Pettit and Scott Cosentino. The editor […]
In 2023, FOSDEM returned as an in-person conference after being virtual for 2 years. With this comeback, the MySQL Team once again hosted the very popular preFOSDEM MySQL Days, a side event we have been doing since 2018. It was a blast ! It was great to see so many friends of MySQL in person. […]
After having cancelled 2 editions of the preFOSDEM MySQL Days because of the pandemic, we were finally back last week in Brussels for 2 wonderful days dedicated to the Dolphin database developed by Oracle. During this event and for the first time, we, the MySQL Team, decided to reward some members of the MySQL Community […]
The latest MySQL release has been published on January 17th, 2023. MySQL 8.0.32 contains some new features and bug fixes. As usual, it also contains contributions from our great MySQL Community. I would like to thank all contributors on behalf of the entire Oracle MySQL team ! MySQL 8.0.32 contains patches from Facebook/Meta, Alexander Reinert, […]
MySQL Shell 8.0.32 was released last week and includes several bugfixes as well as some new features. Let's look into what was added in this new release. New Features $ cat ~/.my.cnf [client] user=root host=lefred password=lefreptwasswort $ mysqlsh MySQL Shell 8.0.32-commercial Copyright (c) 2016, 2023, Oracle and/or its affiliates. Oracle is a registered trademark of […]
Last year, in March 2022, our MySQL Operator for Kubernetes became Generally Available. Since then, several new features were added to our operator and along with the release of MySQL Server 8.0.32 comes a new release of our MySQL Operator for Kubernetes 8.0.32-2.0.8. The goal of the MySQL Operator for Kubernetes is to provide an easy way […]
On January 17 2023, MySQL Server 8.0.32 was released. It is the latest release of our MySQL 8.0 General Availability Release. The new release introduces a few new features alongside with some deprecations, as well as bugfixes and security fixes. Let’s dive into some detail on these new features and changes MySQL Enterprise Optimizer mysql> […]
In May 2020, I published a Planet for the MySQL Community Pluto Beta. I was satisfied with the result and was considering it done, but I did not invest the time to promote it to release (a non-beta site was running for a few months without being advertised). I finally came to it, and today I am happy to deprecate the beta and announce the release of Planet for the MySQL Community.&
As you know, before FOSDEM, the MySQL Community Team organizes a 2 days conference in Brussels. During these preFOSDEM MySQL Days, attendees will have the opportunity to learn more about their favorite database from Oracle’s MySQL teams and selected professionals from the MySQL community. This popular event is organized for and with the MySQL Community. […]