‘commit’ average total time > 300ms in the slowlog. Though profile, most time is spent on starting .
User@Host: 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.