Public bug reported: I found that the daily cron job was taking many hours. Once it took 20 hours to complete!
In mysql, I added a new index on the `messages` table, on the from_domain column. Now the cronjob takes four minutes, every time it runs. ProblemType: Bug DistroRelease: Ubuntu 20.04 Package: opendmarc 1.3.2-7ubuntu0.1 ProcVersionSignature: Ubuntu 5.15.0-1055.60~20.04.1-aws 5.15.136 Uname: Linux 5.15.0-1055-aws x86_64 ApportVersion: 2.20.11-0ubuntu27.27 Architecture: amd64 CasperMD5CheckResult: skip Date: Sun Mar 17 12:42:19 2024 Ec2AMI: ami-063aa838bd7631e0b Ec2AMIManifest: (unknown) Ec2AvailabilityZone: us-west-1b Ec2InstanceType: t3a.large Ec2Kernel: unavailable Ec2Ramdisk: unavailable ProcEnviron: TERM=xterm PATH=(custom, no user) XDG_RUNTIME_DIR=<set> LANG=en_US.utf8 SHELL=/bin/bash SourcePackage: opendmarc UpgradeStatus: Upgraded to focal on 2021-07-10 (981 days ago) mtime.conffile..etc.default.opendmarc: 2022-08-05T08:39:10.606732 mtime.conffile..etc.opendmarc.conf: 2022-12-13T20:42:56.531125 ** Affects: opendmarc (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug ec2-images focal third-party-packages -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2058152 Title: running the daily cron job is VERY slow To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/opendmarc/+bug/2058152/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs