mysql usage: qjg_guest + qjg_connections + qjg_pagenotfound

[ufctemple1]

My sysadmin says this:  

 

"Important! Tables qjg_guest + qjg_connections + qjg_pagenotfound are using over 75% of the mysql usage: 

may be found in ... databases.

Table qjg_connections seems not being used, looks it stopped being accessed last October by a module
Table qjg_guest + qjg_pagenotfound looks being used

It would be important if you could delete old records in order to reduce tables usage. It will improve your site performance."

 

 

Please see the attached screen shot - there appear to be over 750,000 "Guest" records - any harm or caveats to deleting these from mysql?

 

Your help would be most appreciated!

[shacker]

use google analitycs, and use our free module delete connections to clean these tables ande speed up database

[bellini13]

For Clarity, those tables are used to track visitor traffic to your site so that you can see those statistics in your back office.

 

So if you move to using google analytics as Shacker has suggested, then you can disable the collection of stats in the back office and truncate those tables

[ufctemple1]

Any moderators to give their expertise on these tables?

[shacker]

you can disable these modules for stats. also the delete connections module optimize the DB too.

[ufctemple1]

Many thanks @shacker, I'll do that and post back here the results.

[NemoPS]

I'd personally get rid of the tables' content and don't use those stats

[vekia]

instead of these stats use google analytics, 

and if you already use GA, remove redundant stuff from your shop :-)

check this: https://www.prestashop.com/forums/topic/275483-module-database-clean-up-optimize-store-db-speed-up-your-store/

and remove only connections / stats stuff