mariadb stops logging

General eFa discussion
Post Reply
forhire
Posts: 32
Joined: 10 Jun 2021 16:54

mariadb stops logging

Post by forhire »

For a few weeks I've been having an issue with eFa-4.0.4 randomly not processing mail. I've checked all the normal suspects, dns, unbound, milter-ahead, and etc. Being busy I found that restarting the server clearned the issue for a day or two.

I've now discovered that restarting mariadb fixes the issue. Unfortunately I cannot put my finger on the cause. When I check the status it appears to be running without issue. The logs aren't revealing anything overly telling. I may need to up my debug level.

In any case, I'm running MySQL Version: 5.5.5-10.4.25-MariaDB. Any ideas?
User avatar
shawniverson
Posts: 3683
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: mariadb stops logging

Post by shawniverson »

Take a look at this post. Is MariaDB pegging out at 100% when this happens?

viewtopic.php?p=19809#p19809
forhire
Posts: 32
Joined: 10 Jun 2021 16:54

Re: mariadb stops logging

Post by forhire »

Yes. Good call on the mtalog and mtalog_ids tables being the issue. Looking at the mtalog timestamp it appears the issue started in December. The mtalog and mtalog_ids tables were very large. I pruned my the tables to the last 30 days, optimized, and the original query now runs very quickly. I'm optimistic this will fix the issue. :)
Post Reply