ukbaz Posted June 3, 2011 Share Posted June 3, 2011 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now