Visualization of an unindexed JOIN in Mysql
Check the indexes fo your Mysql tables, kids
Because this happens when you’ve got a rather complicated join over two not even very big tables. Mysql “slow statements” keep ramping up, consuming a lot of cpu time and (more importantly clogging Mysql, so that other statements have to wait quite a while.


















