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.
mysql-slow-statement

del.icio.us:Visualization of an unindexed JOIN in Mysql digg:Visualization of an unindexed JOIN in Mysql spurl:Visualization of an unindexed JOIN in Mysql wists:Visualization of an unindexed JOIN in Mysql simpy:Visualization of an unindexed JOIN in Mysql newsvine:Visualization of an unindexed JOIN in Mysql blinklist:Visualization of an unindexed JOIN in Mysql furl:Visualization of an unindexed JOIN in Mysql reddit:Visualization of an unindexed JOIN in Mysql fark:Visualization of an unindexed JOIN in Mysql blogmarks:Visualization of an unindexed JOIN in Mysql Y!:Visualization of an unindexed JOIN in Mysql smarking:Visualization of an unindexed JOIN in Mysql magnolia:Visualization of an unindexed JOIN in Mysql segnalo:Visualization of an unindexed JOIN in Mysql gifttagging:Visualization of an unindexed JOIN in Mysql

Leave a Reply