By Paul Murray on Tuesday, 21 June 2016
Posted in General
Likes 0
Views 501
Votes 0
Hi Stackideas

This is kind of related to this here:

http://stackideas.com/forums/reducing-the-size-of-myphp-database-eb-blog-revisions
http://stackideas.com/forums/reducing-the-size-of-myphp-database-es-stream-trash

Siteground have given me until Friday to get this under control.


finalbug_NOT-REAL-NAME fbug_easyblog_revisions 363.59
finalbug_NOT-REAL-NAME fbug_social_stream_item 102.53
finalbug_NOT-REAL-NAME fbug_social_mailer 96.76
finalbug_NOT-REAL-NAME fbug_finder_terms 55.44
finalbug_NOT-REAL-NAME fbug_social_notifications 24.36
finalbug_NOT-REAL-NAME fbug_finder_links 16.17
finalbug_NOT-REAL-NAME fbug_finder_links_terms8 9.08
finalbug_NOT-REAL-NAME fbug_finder_links_terms0 7.09
finalbug_NOT-REAL-NAME fbug_finder_links_termse 7.08
finalbug_NOT-REAL-NAME fbug_finder_links_terms4 5.14
finalbug_NOT-REAL-NAME fbug_social_points_history 4.43
finalbug_NOT-REAL-NAME fbug_social_privacy_items 4.21
finalbug_NOT-REAL-NAME fbug_social_stream 3.88
finalbug_NOT-REAL-NAME fbug_admintools_filescache 3.52
finalbug_NOT-REAL-NAME fbug_easyblog_post 3.44
finalbug_NOT-REAL-NAME fbug_social_fields_data 3.12


Please what is the Social mailer and why does it take up nearly 100MB

Since I installed ES it has sent maybe 100 mails to new users joining.
Apart from this Nichts, Nada, Niente, Nothing, Rien, Nix!

Please help me get to the bottom of this.
I will stop here and not post any post any more MyPHP Data base requests for help.

Do I need to do something like this but for Social Mail?

http://stackideas.com/forums/db-query-to-delete-stream-items-for-specific-user

thanks

Paul
The social mailer stores all e-mails that are pending to be dispatched out. If all the e-mails under the mail activities are already marked as sent, you could truncate it by running the following query,

truncate table fbug_social_mailer;

Alternatively you could run the following query to remove records which are already sent,

delete from fbug_social_mailer where `state`='1';

Perhaps we should add a settings in 2.0 to auto purge sent items.
·
Wednesday, 22 June 2016 12:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Mark

This is a huge help thanks as it means that I do not have to upgrade my hosting plan.
Having some way to control this with out going into the myPHP admin would be great.
Some of us are still afraid of entering myPHP queries

thanks

Paul
·
Wednesday, 22 June 2016 14:46
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

You are most welcome.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.
·
Thursday, 23 June 2016 17:01
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post