Not the answer you need?
Register and ask your own question!

Percona5.6.35 'commit' is slow

linyuelinyue ContributorCurrent User Role Novice
'commit' average total time > 300ms in the slowlog. Though profile, most time is spent on starting .

# [email protected]: test[test] @ [172.18.16.39] Id: 318755049
# Schema: test Last_errno: 0 Killed: 0
# Query_time: 0.304581 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0
# Bytes_sent: 11
# Profile_starting: 0.304570 Profile_starting_cpu: 0.000058 Profile_query_end: 0.000002 Profile_query_end_cpu: 0.000001 Profile_closing_tables: 0.000001 Profile_closing_tables_cpu: 0.000001 Profile_freeing_items: 0.000007 Profile_freeing_items_cpu: 0.000007 Profile_logging_slow_query: 0.000001 Profile_logging_slow_query_cpu: 0.000001
# Profile_total: 0.304581 Profile_total_cpu: 0.000069
SET timestamp=1499270285;
commit;

Other information: CPU 48c idle 90 Disk: pcie ssd iowait not exists

Thank you for your reply.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.