[RSS Feed/News] mail_queue (4gb) and reaction_content (2gb) are my biggest two tables

Status
Not open for further replies.

XenForo

Administrative
  • Thread starter
  • Admin
  • #1
On a forum with around 1m posts these are my biggest two tables.

Seems strange that mail queue is twice the size of post and reaction content is the same size.

3993616 /var/lib/mysql/xf/xf_mail_queue.ibd
2117648 /var/lib/mysql/xf/xf_reaction_content.ibd
2011160 /var/lib/mysql/xf/xf_post.ibd
1998860 /var/lib/mysql/xf/xf_ip.ibd

Now I'm running out of space I need to clear some of them, is there something I should be running to clean up some of these tables?

My whole DB gzipped is less...

Read more

ادامه مطلب...
 
Status
Not open for further replies.
Back
Top Bottom