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