高性能MySQL：剖析服务器负载（2）[1]

剖析服务器负载（）

剖析报告的后面包含了每种查询的详细报告可以通过查询的ID 或者排名来匹配前面的剖析统计和查询的详细报告下面是排名第一也就是最差的查询的详细报告

# Query : QPS x concurrency ID xBFCFEFF at byte

# This item is included in the report because it matches limit

# Scores: V/M =

# Query_time sparkline: | _^_^_ |

# Time range: :: to ::

# Attribute pct total min max avg % stddev median

# ============ === ======= ======= ======= ======= ======= ======= =======

# Count

# Exec time s us s ms ms ms ms

# Lock time s ms ms us ms us

# Rows sent k

# Rows examine k

# Query size M

# String:

# Databases production

# Hosts

# Users fbappuser

# Query_time distribution

# us

# us #

# us ####################################################

[] []