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

COMMIT command on pt-query-digest

diego10.arg@gmail.com[email protected] EntrantInactive User Role Beginner
Hello everyone,

First of all thanks for your time.

I have been using pt-query-digest to optimize some queries on my App and after the lastest changes, I end up with the following results:
# 1565.7s user time, 5.7s system time, 173.72M rss, 325.88M vsz
# Current date: Thu Sep 22 20:04:56 2016
# Hostname: centos6-64
# Files: /var/lib/mysql/centos6-64-slow.log
# Overall: 5.50M total, 2.67k unique, 63.62 QPS, 0.20x concurrency _______
# Time range: 2016-09-21 19:30:00 to 2016-09-22 19:29:59
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time         16960s     1us     12s     3ms    16ms    36ms   224us
# Lock time           520s       0   743ms    94us   176us     1ms    44us
# Rows sent          4.04M       0  28.58k    0.77    0.99   24.78       0
# Rows examine       1.47G       0   2.61M  287.82  174.84   7.36k       0
# Query size         1.40G       6  14.64k  272.73  755.64  647.70   76.28

# Profile
# Rank Query ID           Response time    Calls   R/Call V/M   Item
# ==== ================== ================ ======= ====== ===== ==========
#    1 0x813031B8BBC3B329 10221.3411 60.3%  378094 0.0270  0.03 COMMIT
#    2 0xE604EE106818FA0B   745.0663  4.4%     344 2.1659  1.05 SELECT 
...
# Query 1: 4.38 QPS, 0.12x concurrency, ID 0x813031B8BBC3B329 at byte 2083111980
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.03
# Time range: 2016-09-21 19:30:00 to 2016-09-22 19:29:59
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          6  378094
# Exec time     60  10221s    11us      2s    27ms    61ms    29ms    18ms
# Lock time      0       0       0       0       0       0       0       0
# Rows sent      0       0       0       0       0       0       0       0
# Rows examine   0       0       0       0       0       0       0       0
# Query size     0   2.16M       6       6       6       6       0       6
# String:
# Databases    XXXX... (41949/11%)... 43 more
# Hosts        localhost
# Users        XXXX
# Query_time distribution
#   1us
#  10us  #
# 100us  #
#   1ms  ###
#  10ms  ################################################################
# 100ms  #
#    1s  #
#  10s+
commit\G


I was wondering if anyone could enlighten me about this.

Thanks in advance!
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.