Using a FLIR thermal camera to improve the taste uniformity of a tea-infused cake

Making a layer cake is a serious task. There are... layers... of complexity to it. Make a mistake, miss a step, and the whole thing can turn into a disaster. 

Quick look: Voltage drift / instability on Ruideng RD6006 power supply

This post is a quick record of voltage drift / variations I noticed during recent experiments with using a MOSFET as a voltage-controlled resistor, where the MOSFET's Gate-Source voltage was driven by the Ruideng RD6006(W) DC-DC power supply.

TL-21 Kelvin clip test lead upgrade for DER EE E-5000 LCR meter

There's no shortage of blog posts and videos describing TL-21 probe upgrade for the extremely popular DER EE E-5000 LCR meter. With that said, this post will is somewhat repetitive, but hey, I already took the pictures, so why not share.

For impatient readers, this is what the finished job looks like:

Measuring NiMH vs Li-Ion voltage sag at small loads with ESP32

This article is a brief excerpt from my experience with using Nickel Metal Hydride (NiMH) and Lithium-ion (Li-ion) cells for powering home sensors running the ESP32 Wi-Fi microcontroller.

Measuring breadboard wiring resistance: how bad is bad?

This article is a brief record of my early breadboard wiring adventures, because learning things the hard way is fun! You may also read the related post if you wish:

NiMH vs Li-Ion voltage sag under small loads

The story of MySQL Bug #86664

This is a story about why it's a good idea to test and verify the behavior of new software releases, even if the change log says that a particular bug was already fixed.

Database proof-of-concept & migration best practices

This post tries to answer some of the most popular questions I receive from customers, regarding the best practices for database proof-of-concept and migration projects.

Quick look: Performance impact of General and Slow Query Logging

General query logs and slow query logs remain one of the most popular sources of auditing and diagnostic information in MySQL databases. Customers often ask about the cost of general and slow query logging so I went googling for existing research I could point them to. The data I found was not quite what I hoped for, which is why I decided to do some more testing.

MySQL 8.0 Information Schema performance improvements

FRM-less, transactional data dictionary is arguably the most significant feature change announced MySQL 8.0 development release. The server still has two separate dictionaries (MySQL, InnoDB) but the infamous FRM files are finally being replaced with transactional, InnoDB-based storage.

While this is interesting for various reasons, this particular post will focus on the impact this change has on data dictionary performance.

Investigating InnoDB FULLTEXT cache performance issues in MySQL <5.6.30

I'm not a huge fan of the InnoDB FULLTEXT feature and I admit I wasn't too keen to play with it in the past. Apparently, the feeling is mutual and so FULLTEXT issues haven't popped up in too many projects I worked on... until last week.

This post describes the troubleshooting process of a FULLTEXT cache performance issue. Quite inconspicuous at the beginning, it proved to be a lot of fun in the end.

Ready, Set, GDB!