BSQ_Stats component melts the mySQL server

BSQ_stat component and module used to be the major tool to track the users of my sites, but Jack just kicked my ass because some of my MySQL processes took almost 100% CPU. Command “show processlists” stated my site is updating the BSQ_stats’s table, and the process seemed to hang and messed up the system. Apparently there’s bug in this component. Anyway, I removed this componets and uses only Google Analytics to track the traffic.

Continue reading