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…
Category MySQL
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…
