0

I'm using Mariadb 10.2.16. 3 Node cluster.

Coms counts taken at particular time for all 3 (insert,update,commit).

Com_inserts are in 1.1K 
Com_updates are in 1.6k 
Com_commit are in  10K

When enabling general log, I could see after each selects there is a commit. Would this unnecessary commit can cause any fsync or any flush opertation to the server?

innodb_flush_log_at_txn_commit=0.
6
  • What 3rd party software are you using? – Rick James Sep 29 '20 at 19:25
  • i'm using Mariadb 10.2.16. – Mannoj Sep 30 '20 at 14:15
  • This is probably a Galera issue; I added the tag. – Rick James Sep 30 '20 at 22:57
  • I check 3 Galera clusters -- none had Com_select < Com_commit . But you are seeing that, correct? – Rick James Sep 30 '20 at 23:07
  • 1
    The application connected to the database is doing silly things. MariaDB can only report what it sees. MariaDB won't fsync on commit unless there is things to actually commit, so its overhead, but not IO overhead. – danblack Oct 9 '20 at 4:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.