Hi,
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:
DELETE FROM DistributedLock
WHERE RESOURCE = ?
INSERT INTO DistributedLock
( RESOURCE , CreatedAt
) SELECT ?..
at the top.
I’m continuing to explore the issue and will post here if I find the cause/fix.