Dan Caballero writes:
We're running Mailman in AWS using and RDS MySQL database. It seems to take unusually long to approve or discard even a few messages.
I assume you are use Postorius for this?
What should be a normal response time for processing as few as 10 messages?
I don't know about MySQL/Maria. All of the production instances I have access to are backed by PostgreSQL. Response using Postorius is not instantaneous, but 2-3 seconds is maximum. Also, I don't think I've seen multiple messages with the same treatment in visit in many months (maybe a year), but I don't recall those "feeling" longer than a single message request.
I've done some testing in the pass running Mailman3 in a Docker container and using a local instance of MariaDB. Even in that situation I still found the processing slow.
I guess since you talk about "10 at once" you have a much larger lists and/or much larger user databases and/or heavier traffic per user and/or more "spam". It would help to know what the scale of your Mailman installation is in those dimensions.
I don't think Mailman's Python code is likely to be the bottleneck, rather it's probably database queries. Have you looked at MySQL's logs for queries related to those operations?
Steve