mariadb stops logging

[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?

[shawniverson]

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

viewtopic.php?p=19809#p19809

[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.