MySQL Left Join First Row
Recently, we had a MySQL Query Peg 8 CPU due to a sudden increase in records from data migration. This data migration provided a reference table to link equipment to a location and DateTime.
For some records, that was two or three records; for some, it was a couple of