January 10, 2021 | Technical
Weird case of MySQL index that doesn’t function correctly

I created an index on one field, which the database was dumped for backup. The operation took 5 hours, which is odd for the amount of data (156 million rows) Queries not working as it should I ran the new code using the new index, and it seems very slow—doing a select on the index…
Read more
August 7, 2020 | Technical
Twenty Ways To Optimize MySQL for Faster Insert Rate

If you’re following my blog posts, you read that I had to develop my own database because MySQL insert speed was deteriorating over the 50GB mark. That’s why I tried to optimize for faster insert rate. The application was inserting at a rate of 50,000 concurrent inserts per second, but it grew worse, the speed…
Read more
April 16, 2020 | Technical
Why would I want to build a database?

If you know a thing or two about databases, the mere thought of writing a database should set off alarm bells, and if you had asked me 3 years ago I would have probably told you to drop it – why write a database? With so many good free open source databases on the market,…
Read more