By Sunny on Thursday, 04 August 2016
Posted in Technical Issues
Replies 1
Likes 0
Views 319
Votes 0
Hi Mark,

We have are doing housekeeping and maintenance, during this we noticed that for easysocial database two tables are very large:

*_social_notifications : 80mb
*_social_mailer : 70 mb

wanted to know if we can manually empty *_social_mailer table as i believe its a log of mails sent?

Also for *_social_notifications, does it store all notifications even after they are read? is it safe to empty this table?

Also for Easy Blog, i've opened another thread here , on the same issue of database table size.

regards
Hi Sunny,
wanted to know if we can manually empty *_social_mailer table as i believe its a log of mails sent?
This table stores all mails from the site including sent and pending mails. You can empty this table in the backend by managing the Email Activity page of EasySocial if you do not need them any longer. We have other managing options like "Mark as Pending" if you want mails to be sent again.
Also for *_social_notifications, does it store all notifications even after they are read? is it safe to empty this table?
This table store all notifications, read and unread. Unread notifications will be state=0 in the database. Do take note that if you clear this table, users will be not able to view read and unread notifications from their notifications page.
·
Thursday, 04 August 2016 17:05
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post