We are running versions 12 & 13, currently in the middle of upgrading all our site instances (about 400 of them).
I noticed frappe queries in the rds always waiting for table-level locks (we never specified that on code) and even when we specified “FOR UPDATE” queries, we expected a row level lock on the innodb engine.
Is this a frappe implemented decision on 12 & 13, and have you found it to be the case on more recent versions. This issue has posed a serious problem on the performance of our RDS instance.