From email to myTinyTodo
Usually, I receive a lot of emails, and sometimes I read them on my phone and then… I forgot about them.. (shame on me). On my Linux desktop, I used to use Get Things Gnome for a long time, due…
How to build MySQL 8.0 C API (libmysqlclient)
If you write C applications that need to connect to MySQL, you can use the MySQL C API aka libmysqlclient. The MySQL C API replaces the outdated MySQL-Connector-C. If you want to use MySQL 8.0 as a Document Store with…
MySQL InnoDB Redo Log Archiving
When performing physical backup on system that are heavily used, it can happen that the backup speed cannot keep up with the redo log generation. This can happen when the backup storage is slower than the redo log storage media…
A graph a day, keeps the doctor away ! – Full Table Scans
Full table scans can be problematic for performance. Certainly if the scanned tables are large. The worst case is when full table scans are involved in joins and particularly when the scanned table is not the first one (this was…
MySQL Books: Efficient MySQL Performance
Today, the book I would like to recommend is Efficient MySQL Performance – Best Practices and Techniques, Daniel Nichter, O’Reilly, 2021. I participated (just a bit) in the writing of this book as technical reviewer with Vadim and Fipar. I…
A graph a day, keeps the doctor away ! – MySQL History List Length
This is the second article of the series dedicated to MySQL trending. As I wrote before, understanding your workload and seeing the evolution of it over time can help anticipating problems and work on solutions before the breakdown. This article…
MySQL Books: The MySQL Workshop
This is the first article of a new blog series related to MySQL books. 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…
Migrating from MariaDB to MySQL using MySQL Shell
We are getting many requests for migration from MariaDB to MySQL. Here is a quick guide and steps to follow: On the MariaDB server: Create a logical dump of MariaDB (using MySQL Shell) Create a dedicated user for replication [optional]…
A graph a day, keeps the doctor away ! – MySQL Checkpoint Age
In a previous post, I explained how you can collect and plot metrics using MySQL Shell. This is a new series of article where I will explain how to read and understand some of the generated graphs. Understanding your workload…
MySQL 8.0.29: thank you for the contributions
When it’s time for a new MySQL release, it’s also time to thank our contributors ! Released on April 26th, MySQL 8.0.29 contains several contributions from our awesome Community and on behalf of the entire MySQL Team, I would like…
Poorman’s MySQL monitoring/trending
I could have also called this article When Pandas meet Dolphins in MySQL Shell. Some time ago, I wrote a post related on how to collect initial relevant data when trying to seek help for MySQL. Since then, the MySQL…
Poorman’s MySQL table audit information – part 3
Recently we saw how we can catch audit information using invisible column, JSON data type and triggers in MySQL 8.0: Poorman’s MySQL table audit information Poorman’s MySQL table audit information – part 2 Of course, the creation of these triggers…
