#PostgreSQLのSlow Queryを改善した話：たった1行の変更でパフォーマンスが劇的に改善したケーススタディ
https://qiita.com/hoatms/items/ca6689d53ef787f435d0?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #PostgreSQL #Laravel #Optimization #slowquery

How to Prevent Slow Query Log From Filling Your Disk

One bad query. Millions of log lines.

#mysql #slowquery #log #howto #production #monitoring

https://www.youtube.com/watch?v=rmbArOL0UYQ

How to Stop Correlated Subqueries From Crushing Your Server

One nested query can run thousands of times.

#mysql #subquery #performance #howto #slowquery #scale

https://www.youtube.com/watch?v=M43v0cPvjaw

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

https://www.youtube.com/watch?v=O0jCjaAsNNA

How to Stop Functions From Disabling Indexes

Wrapping a column kills your index instantly.

#mysql #index #performance #date #howto #slowquery

https://www.youtube.com/watch?v=MA9CIFDHqMY

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

https://www.youtube.com/watch?v=PUJ8KouC1V0

How to Stop ORDER BY RAND From Melting Your Server

RAND forces a full sort on every row.

#mysql #orderbyrand #performance #howto #slowquery #scale

https://www.youtube.com/watch?v=LJC2cMIlCFg