I have been asked to release some statistics about the number of held messages per list. List the lists with the most held messages. Since we already deleted a bunch i'm restoring data just for that.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | • JohnLewis | T110438 Evaluate lists with large moderation queues | |||
| Resolved | Dzahn | T110609 publish statistics about number of held messages per list |
Event Timeline
Comment Actions
command to get stats, in /var/lib/mailman/data/ or /var/lib/mailman/restore/var/lib/mailman/data/ respectively:
find . | sed -e "s/pckg" -e "s/[0-9]g" -e "s/\.//g" | sort | uniq -c | sort -nr | less
Comment Actions
@sodium:/var/lib/mailman/restore/var/lib/mailman/data#
find . | sed -e "s/pck//g" -e "s/[0-9]//g" | sort | uniq -c | sort -nr | sed -e "s/\.\/heldmsg-//g" -e "s/\.//g" > held_msg_stats_mailman.txt
@sodium:/var/lib/mailman/restore/var/lib/mailman/data# head -n 30 held_msg_stats_mailman.txt
67983 wikinews-l- 64086 wikiru-l- 44096 maps-l- 39310 wikimedia-in-amd- 39233 wikifa-l- 37536 wiktionary-l- 27291 wikimediabe-l- 25565 wikimediake- 24387 wikimedia-in-wb- 22665 education- 22473 libraries- 20654 wikisk-l- 19894 wikifi-l- 18612 wikiia-l- 14318 wikilb-l- 10472 wiktionarypt-l- 10249 exyu-tech- 8508 wikiskan-l- 7650 wikiru-a- 5672 wikihe-l- 5018 wikimedianz-l- 4649 wikiquality-l- 4342 wikiversity-l- 2885 wikibooksde-l- 2566 wikiml-l- 2238 juriwiki-l- 2031 wikica-l- 1942 mailman- 1698 wikimedia-california- 1571 infobg-l-
Comment Actions
Resolved in my opinion. Now let's look at these lists and figure why they have tens of thousands of emails in moderation.