long_query_time was an integer in MySQL 5.0, so one second became the conventional slow-query threshold and stayed there out of habit. It has taken a float since 5.1.…
The rows column in an EXPLAIN is read as a measurement — “this query looked at 8,412 rows”. It is the optimiser’s guess, derived from index statistics, and…
Two pages read the same column and only one of them was right. Dumping, rewriting and reloading 52,000 rows without turning every accent into a question mark.
CodeIgniter’s Active Record resets itself after every get(), which is what you want almost always and a nuisance exactly once per paginated listing: the total and the page…