#slowquery — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #slowquery, aggregated by home.social.
-
How to Prevent Slow Query Log From Filling Your Disk
One bad query. Millions of log lines.
-
How to Stop Correlated Subqueries From Crushing Your Server
One nested query can run thousands of times.
-
JSON Column Search Takes 47 SECONDS Breaking Black Friday?!
JSON SEARCH NIGHTMARE! Can't index JSON columns in older MySQL! Every product search scans 2 MILLION rows! 47-second queries! Server MELTS on Black Friday! $4.7M revenue LOST! Watch the horror!
#sql #sqldisaster #json #performance #noindex #slowquery #sqlfails #blackfriday #sqlshorts #databasedisaster #sqlwtf #jsonsearch
-
How to Stop Functions From Disabling Indexes
Wrapping a column kills your index instantly.
-
Index On NULL Column Does NOTHING?!
Your performance just DIED! Created an index but queries with NULL are still slow? Indexes IGNORE NULL values! Full table scan on millions of rows! Your index is USELESS! Watch the disaster!
#sql #sqlperformance #index #null #fulltablescan #slowquery #sqlfails #productionbug #sqlshorts #databasedisaster #sqlwtf #indextrap
-
How to Stop ORDER BY RAND From Melting Your Server
RAND forces a full sort on every row.