I have a MySQL database hosted on AWS RDS as my Hangfire database.
I recently upgraded from .net core 2.2 to .net 6 and whilst everything works, the IOPS from Hangfire has increased 10 fold. I can see that it is hangfire causing it as top SQL b y Load by Waits (AAS) shows:
DistributedLock WHERE RESOURCE = ?
DistributedLock ( RESOURCE ,
CreatedAt ) SELECT ?..
at the top.
I’m continuing to explore the issue and will post here if I find the cause/fix.