XF 2.1 my xf_mail_queue in my database is 45 gb.. whats going on here? thanks for any help.

[Rom]

my xf_mail_queue in my database is 45 gb.. whats going on here? what should I do? thanks for any help.

 

[Paul B]

That table is, as the name suggests, emails which are queued to be sent.

What is the date/cpntent of the oldest entry in the table?

 

[Rom]

That table is, as the name suggests, emails which are queued to be sent.

What is the date/cpntent of the oldest entry in the table?

Hi Brogan,

This is an example of a send date: 1621999945

How do I interpret that?

 

[Paul B]

That's a UNIX time stamp and translates to 26 May 2021.

Is that the oldest entry?
How many rows are there?

Can you see what the contents are?

We have seen issues with the mail queue table filling up before, due to bounces.

 

[Rom]

That's a UNIX time stamp and translates to 26 May 2021.

Is that the oldest entry?
How many rows are there?

Can you see what the contents are?

We have seen issues with the mail queue table filling up before, due to bounces.

1.14 million rows

lets assume that oldest entry is really old because when I try to sort by DESC, phpAdmin just gives me the [Loading...]

 

[Rom]

I just want to clear it out as my board is not really "mail dependent" other than new user emails. Is there a way to disable all emails from the board except for the new user verification email? This clog is probably mostly reactions emails..

 

[Paul B]

Well the quickest resolution would be to truncate the table, but any emails in the queue would be lost, so member won't receive notifications to watched content, conversations, etc.

Reactions don't trigger emails but members can watch content - you can restrict that on a per node basis to disable emails for replies, new posts, etc.

 

[Rom]

Well the quickest resolution would be to truncate the table, but any emails in the queue would be lost, so member won't receive notifications to watched content, conversations, etc.

Reactions don't trigger emails but members can watch content - you can restrict that on a per node basis to disable emails for replies, new posts, etc.

awesome, will the space be reclaimed? after truncation? or do I need to do something else. thanks again.

 

[MisakiTaro]

awesome, will the space be reclaimed? after truncation? or do I need to do something else. thanks again.

Truncating will solve everything. You don't need to do anything after truncating except looking for your SMTP mail provider that causes this problem.

Yes, space will be reclaimed.

 

[Rom]

Truncating will solve everything. You don't need to do anything after truncating except looking for your SMTP mail provider.

Yes, space will be reclaimed.

is this the setting you are referring to stop the emails?

Forum watch notification limit

• New messages
• New threads
• None

 

[MisakiTaro]

is this the setting you are referring to stop the emails?

Forum watch notification limit

• New messages
• New threads
• None

It will only stop forum watchs.

To stop e-mailing, you should do Template Modifications and SQL Queries.

Unmaintained - Turn Off Email Notifications

To turn off email notification for forum watch, edit every node in your board, and set "Forum watch notification limit" to "None". To turn off email notification for thread watch, create these template modifications Template ...

xenforo.com

You may follow that guide.

 

[Rom]

It will only stop forum watchs.

To stop e-mailing, you should do Template Modifications and SQL Queries.

Unmaintained - Turn Off Email Notifications

To turn off email notification for forum watch, edit every node in your board, and set "Forum watch notification limit" to "None". To turn off email notification for thread watch, create these template modifications Template ...

xenforo.com

You may follow that guide.

cool, thanks for your help.

 

[Rom]

It will only stop forum watchs.

To stop e-mailing, you should do Template Modifications and SQL Queries.

Unmaintained - Turn Off Email Notifications

To turn off email notification for forum watch, edit every node in your board, and set "Forum watch notification limit" to "None". To turn off email notification for thread watch, create these template modifications Template ...

xenforo.com

You may follow that guide.

just for clarification, does this "Replace : leave the box empty"

mean this:

<xf:checkbox>


</xf:checkbox>

 

[MisakiTaro]

just for clarification, does this "Replace : leave the box empty"

mean this:

<xf:checkbox>


</xf:checkbox>

You should also delete them.

<xf:checkbox>


</xf:checkbox>

 

[Xon]

I had a 23gb xf_mail_queue table with nothing in it (literally empty).

Except that is 23gb of lz4 compressed table living on zfs, so more like ~40gb if that was living on ext3/ext4.

 

[Rom]

I had a 23gb xf_mail_queue table with nothing in it (literally empty).

Except that is 23gb of lz4 compressed table living on zfs, so more like ~40gb if that was living on ext3/ext4.

yeah I got 41 gbs back on my server when I emptied that table... strange.