Steve,
thank you for your comments.
Am 29.06.22 um 06:33 schrieb Stephen J. Turnbull:
Since my migration from mm2 to mm3 I see what I consider high loads and excessive i/o and memory usage.
This isn't informative enough to guess whether this is unusual for Mailman 3 or not.
I agree. As it turns out, in the first row, accessing the hyperkitty archive over http consumes a lot of ressources. My guess is that frequent loading and querying the sqlite database is the main cause.
[...] If you go the MySQL route, be aware that a while back there were some issues with record size and with Unicode. I'm not sure the versions you specify have those fixed. You can fix them yourself by tweaking the MySQL configuration; ask us if you prefer this, somebody will help (sorry, I don't remember details and need to go to a meeting).
A pointer to these fixes would help me ... as well as a hint how the "loaddata" crash could be mitigated.
Thanks again for your time.
Moritz