#slowquery — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #slowquery, aggregated by home.social.
-
#PostgreSQLのSlow Queryを改善した話：たった1行の変更でパフォーマンスが劇的に改善したケーススタディ
https://qiita.com/hoatms/items/ca6689d53ef787f435d0?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items -
#PostgreSQLのSlow Queryを改善した話：たった1行の変更でパフォーマンスが劇的に改善したケーススタディ
https://qiita.com/hoatms/items/ca6689d53ef787f435d0?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items -
How to Prevent Slow Query Log From Filling Your Disk
One bad query. Millions of log lines.
-
How to Prevent Slow Query Log From Filling Your Disk
One bad query. Millions of log lines.
-
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.
-
How to Stop Correlated Subqueries From Crushing Your Server
One nested query can run thousands of times.
-
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
-
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
-
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.
-
How to Stop Functions From Disabling Indexes
Wrapping a column kills your index instantly.
-
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
-
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
-
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
-
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
-
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.
-
How to Stop ORDER BY RAND From Melting Your Server
RAND forces a full sort on every row.
-
How to Stop ORDER BY RAND From Melting Your Server
RAND forces a full sort on every row.