File: slow013_report_outliers.txt

package info (click to toggle)
percona-toolkit 3.2.1-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, bullseye, forky, sid, trixie
  • size: 68,916 kB
  • sloc: perl: 241,287; sql: 22,868; sh: 19,746; javascript: 6,799; makefile: 353; awk: 38; python: 30; sed: 1
file content (56 lines) | stat: -rw-r--r-- 2,240 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56

# ########################################################################
# Report grouped by user
# ########################################################################

# Item 1: 2 QPS, 0.15x concurrency, ID 0x628E12FCDECDAA2D4F1658C9B243995F at byte 174
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.15
# Time range: 2008-11-27 08:51:20 to 08:51:21
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         40       2
# Exec time     99   149ms     5us   149ms    75ms   149ms   106ms    75ms
# Lock time    100    70us       0    70us    35us    70us    49us    35us
# Rows sent    100     226       0     226     113     226  159.81     113
# Rows examine 100     226       0     226     113     226  159.81     113
# Query size    50      38      11      27      19      27   11.31      19
# String:
# Databases    test
# Hosts        10.1.12.201
# Query_time distribution
#   1us  ################################################################
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
mytopuser

# Item 2: 0 QPS, 0x concurrency, ID 0x83EBF533997B1B1B8F4C76E92F07EABE at byte 600
# This item is included in the report because it matches --outliers.
# Scores: V/M = 0.00
# Time range: all events occurred at 2008-11-27 08:51:21
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         60       3
# Exec time      0    97us    15us    67us    32us    66us    24us    14us
# 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    50      38       6      16   12.67   15.25    4.48   15.25
# String:
# Databases    abc
# Hosts        10.1.250.19
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us
#   1ms
#  10ms
# 100ms
#    1s
#  10s+
foo_app