alp Sat Jul 2 13:20:54 JST 2022

[ushmz]

# 160ms user time, 20ms system time, 31.66M rss, 32.98G vsz
# Current date: Sat Jul  2 13:20:54 2022
# Hostname: kahma
# Files: log/132053/slow.log
# Overall: 8 total, 1 unique, 0.10 QPS, 0.82x concurrency ________________
# Time range: 2022-07-02T04:17:22 to 2022-07-02T04:18:41
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            65s      5s     10s      8s     10s      2s      9s
# Lock time              0       0       0       0       0       0       0
# Rows sent              8       1       1       1       1       0       1
# Rows examine           8       1       1       1       1       0       1
# Query size           123      15      16   15.38   15.25    0.35   14.52

# Profile
# Rank Query ID                            Response time  Calls R/Call V/M
# ==== =================================== ============== ===== ====== ===
#    1 0x59A74D08D407B5EDF9A57DD5A41825CA  65.0183 100.0%     8 8.1273  0.40 SELECT

# Query 1: 0.10 QPS, 0.82x concurrency, ID 0x59A74D08D407B5EDF9A57DD5A41825CA at byte 1660
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.40
# Time range: 2022-07-02T04:17:22 to 2022-07-02T04:18:41
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count        100       8
# Exec time    100     65s      5s     10s      8s     10s      2s      9s
# Lock time      0       0       0       0       0       0       0       0
# Rows sent    100       8       1       1       1       1       0       1
# Rows examine 100       8       1       1       1       1       0       1
# Query size   100     123      15      16   15.38   15.25    0.35   14.52
# String:
# Databases    ratri
# Hosts        192.168.48.1
# Users        ratri
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms
#    1s  ################################################################
#  10s+  ######################################
# EXPLAIN /*!50100 PARTITIONS*/
SELECT SLEEP(10)\G