4GB Database Tabel Size, Why?
By Bruno Alecrim on Wednesday, 23 December 2015
Posted in Technical Issues
Replies 5
Likes 0
Views 483
Votes 0
Hi There, right now we have around 4GB size of just a single discuss_mailq table. Why it is so huge? In our EasyDiscuss forum we have just 320posts and the majority dont even have any image attached. I think something is wrong there. Is it normal?

With Best Regards
Bruno Alecrim
So the code will be this?

"truncate table v1da_discuss_mailq;"

v1da is the table prefix

Thanks
Bruno
Bruno Alecrim
·
Wednesday, 23 December 2015 23:52
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Bruno,

Do you have a lot of users on your site? Is your current configuration for EasyDiscuss sends a notification email to everyone on the site?

Anyhow, you could actually go to the Mail Activities at the back end of EasyDiscuss to purge them all
Mark
·
Wednesday, 23 December 2015 13:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for your reply.

I am trying to go to Email Activities at the backend, and I get 500 error message when access that specific page.
What I need to do Access that page to purge that data?

Bruno
Bruno Alecrim
·
Wednesday, 23 December 2015 22:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Bruno,

Try running the following sql query on phpmyadmin



Replace #__ with your table prefix.
Mark
·
Wednesday, 23 December 2015 23:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Yep that is correct Bruno
Mark
·
Thursday, 24 December 2015 11:00
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post