Using BETWEEN instead of LIMIT and OFFSET proved to be a simple optimization to a troublesome slow MySQL query.
MySQL Tip: Drop All Tables (With PostgreSQL Bonus)
Certain DBALs and ORMs don’t provide a functional reset method to clear out schema cruft before rebuilding tables (I’m looking at you, Django). Others like SilverStripe tip toe around your schema, appending-never-deleting, so nothing ever gets flat out broken by a rebuild. That behavior is OK with me because their scope usually…
MySQL Quick Tip
If you need to monitor a MySQL server in order to see what is happening, but you haven’t developed any monitoring solutions you can use this to grab information from the mysql server. How to grab the status and show how many “Com_inserts” are happening every 10 seconds: > mysqladmin…
Concatenating Subqueries with Multiple Results in MySQL
ERROR: Subquery returns more than 1 row Error Code: 1242 The "Subquery returns more than 1 row" error may indicate that your data is not normalized properly especially if your data relationships are supposed to be one-to-one. However, if you have data with one-to-many relationships like items in multiple categories…