Tagged with "mysql"
sync_binlog, which is, indeed, a counter, and while we discussed that it can be used to tune a MySQL database's durability, we didn't really dig much deeper. Over the next little while, we'll do just that ... read more
LooseScan, and table pullout optimisations, but there's still one more to clover: the
DuplicateWeedoutoptimisation, and then thistle be the last topic we discuss about about subqueries. ... read more
FirstMatchsemi-join optimisation, and while it's pretty simple and fairly straight-forward, some queries may just not benefit from it. ... read more