Deleting records from pagestatistics table
Permalink 3 users found helpful
My pagestatistics table is growing. What's the most efficient way to keep it small in size?
Is there a direct way to clear this table from the Dashboard?
I am thinking of regularly running a cron job to delete entries less than a particular date. Are there other tables in the database that are related to pagestatistics table or can I independently delete records from this table? Is it safe to truncate or should I just delete older entries or it does not matter?
Is there a direct way to clear this table from the Dashboard?
I am thinking of regularly running a cron job to delete entries less than a particular date. Are there other tables in the database that are related to pagestatistics table or can I independently delete records from this table? Is it safe to truncate or should I just delete older entries or it does not matter?
![JohntheFish](/files/avatars/51576.jpg)
Some addons analyse page statistics. Other than that, you can truncate it to whatever length you like, but don't delete it unless you first turn off c5's use of the statistics or you will get write errors.
Thanks a million. I had a 4 year old website that I needed to move server on and this record was causing my DB to be over 25MB and not import via phpMyAdmin.
Manually deleted the records and changed the setting to not track and server move was a doddle.
Thanks John.
Manually deleted the records and changed the setting to not track and server move was a doddle.
Thanks John.
That's ancient. Have a look at Extreme Clean.
Available for 5.6. In the prb for 5.7+
Available for 5.6. In the prb for 5.7+