Great article! Where you ever able to find out about that huge difference between MariaDB and MySQL on the select count(1)?

Also, did you replicate that particular behavior later on by trying indexes / partitions, etc? I was wondering if the database configuration would tilt the scales in a different way. Even if it didn’t, that huge difference is intriguing…