MySQL "delayed commit ok done" and performance

Question

I am using AURORA MySQL on AWS. When I run show Processlist I see lots of delayed commit ok done

I want to ask that does it hinder in performance? If Yes, how dO I imrpove it?

I am using PyMySQL, a Python based library and I do use .commit after each INSERTS and UPDATE

Answer 1

This has nothing to do with your code. Check this AWS documentation

It's an internal mechanism used in aurora to do commits. It's specific to aurora. It probably doesn't have much of a performance impact since AWS chose this as the commit mechanism & aurora is touted as being as powerful as MySQL.