On Fri, Jan 13, 2023 at 7:33 PM Johannes Rohr <johannes@rohr.org> wrote:

Dear all,

with mailmanweb running, the CPU load of mysqld constantly hovers around 100%

In /var/log/mysql/errors.log I see repeatedly:

2023-01-13 17:22:42 27198 [Warning] Aborted connection 27198 to db: 'mailman_core' user: 'mailman' host: 'localhost' (Got an error reading communication packets) 2023-01-13 17:27:43 29621 [Warning] Aborted connection 29621 to db: 'mailman_core' user: 'mailman' host: 'localhost' (Got an error reading communication packets)

This also seems to affect other services such as dovecot which rely on mysql and at times can't connect to it.

Does anyone have a suggestion what to do about this?

Cheers,

Johannes

The issue could be related to the cron run for archiving, given that MM3 stores the archives in the DB. You could start by looking at tuning your MySQL server instance.

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)