AWS RDS MySQL some time get slow performance when update table1 set field='any word' where primarykey=1234
Finally was the auto commit as mustaccio told me in a comment:


  Looks like your "sleep connections" are not committing their transactions and thus keeping locks. Revise your application logic.