/tmp/mysql_slow_queries

Permalink
I have just noticed that /tmp/mysql_slow_queries is filled with log files, many per day, containing messages like the following:

# Fri Sep 16 21:44:55 2011
# Query_time: 4.167969  Lock_time: 0.027210 Rows_sent: 0  Rows_examined: 0
use mydb;
insert into PageStatistics (cID, uID, date) values ('439', 0, NOW())
# Fri Sep 16 21:49:59 2011
# Query_time: 2.378320  Lock_time: 0.000081 Rows_sent: 0  Rows_examined: 0
use mydb;
insert into PageStatistics (cID, uID, date) values ('439', 0, NOW())
# Fri Sep 16 21:55:35 2011
# Query_time: 8.922409  Lock_time: 0.000066 Rows_sent: 0  Rows_examined: 0
use mydb;
insert into PageStatistics (cID, uID, date) values ('439', 0, NOW())

PageStatistics has 516,871 records, 31mb. Is this one of the things contributing to very slow performance on my site? if so, how to purge?

I assumed that this was Tony's Traffic & Statistics add-on, but it turns out to be C5 core. Searching for PageStatistics led me to
http://www.concrete5.org/community/forums/chat/should-i-turn-off-st...
and
http://defunctlife.com/2009/08/how-to-disable-concrete5-site-statis...

waterfeller
 

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.