Jump to content

mySql slow queries V 1.3.2


Recommended Posts

Hi - am getting repeated slow queries from stats module showing up in logs

# Query_time: 2.078395  Lock_time: 0.000162 Rows_sent: 0  Rows_examined: 840449
SET timestamp=1307096780;
DELETE FROM `ps_connections_page`
           WHERE id_connections IN (
               SELECT `id_connections`
               FROM `ps_connections`
               WHERE date_add < LAST_DAY(DATE_SUB(NOW(), INTERVAL 1 WEEK))
           );



Is there a fix for this? I still want to keep stats running, will turning off Data mining for statistics module fix this but still allow other statistics to work, apart from ps_connections etc?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...