Forums

/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