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
