What is the use of the data in ps_connections_source ? Is it fine to empty the table ?

[USB83]

Hello,

I'm dealing with a website, running 1.6x that has some quite large tables

ps_connections_source : 2,1 Go
ps_connections      : 840 Mo
ps_guest            : 571 Mo
ps_sekeyword        : 120 Mo
ps_cart             : 16 Mo
ps_customer         : 10 Mo
ps_mail             : 9 Mo
  etc ....

My question is what is the need of the 3 or 4 largest tables

connections_source, connections, guest and sekeyword

Is it ok to truncate them from phpmyadmin ?

And concerning the largest one, connections_source, where in the store's backoffice is the data of that table displayed ?
I looked on the stats page, but couldn't find the data stored on this table.

When looking into it on the database, it contains several thousands of seemingly useless data with this sort of entries (+ the date and id_connections_source,  id_connections )

http_referer :
https://l.facebook.com/
http://www.google.com/
https://www.nasa.gov/topics/search?q=www.MyDomain.com/
https://steamcommunity.com/market/search?q=www.MyDomain.com/
https://vk.com/profile.php?redirect=www.MyDomain.com/

request_uri :
www.MyDomain.com/?t259289679994017839679787w139424861688L186760937273y
www.MyDomain.com/?B8268741726p1973275640547Y108480662877326305080533
....

Thanks for the help

[ClassyDevs]

@USB83

This two table keep track from where your visitor comes, which browsers they are using etc.  You need to  clean up this table regularly to keep your database clean and site fast.

Bellow is show you screen shot from my pc

https://pscreenshot.com/i/0bvh20

https://pscreenshot.com/i/KR8A21

 

There are several free or paid module you will find to clean up the database. Which clean other unused table like abandon cart etc.

Hope you understand.

Thank you

[USB83]

@ClassyDevs

Thank you for your answer

Could you please share a link to one of the modules you mentionned ? if there's one that does the job for free, i'd prefer it obviously

Is it wrong to empty/truncate the tables 'manually' using phpmyadmin or cli ?

Thanks again

[ClassyDevs]

Hello, Sorry i have not found any fee yet. You can found in free modul section. It is no problem to remove from phpmyadmin

 

Thank you