MySQL "delayed commit ok done" and performance

Viewed 4828

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

1 Answers

This has nothing to do with your code. Check this: http://datavirtualizer.com/delayed-commit-ok-initiated-aurora-mysql/

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.

Related