Vlad Fedorkov

Performance consulting for MySQL and Sphinx

Health check report example

Download : Installation : Main page : Report explained : Support

Report includes the following sections

  • Main system parameters
  • Today’s entries from MySQL error log file
  • MySQL health metrics
  • Top 5 most resource consuming queries from MySQL slow log

Sample report from test MySQL server
Please check report explanation for details

Health check report for host MHC-QA1
 11:30:18 up 54 days, 17:45,  3 users,  load average: 3.71, 3.76, 3.79

=== disks ===
Filesystem      Size  Used Avail Use% Mounted on
/dev/md2        30G  5.6G   23G   21% /
/dev/md3        50G   24G   24G   51% /store/mysql
/dev/md4        104G   57G   42G  58% /store/mysql-logs
udev            5.9G  4.0K  5.9G   1% /dev
tmpfs           1.2G  288K  1.2G   1% /run
none            5.0M     0  5.0M   0% /run/lock
none            5.9G     0  5.9G   0% /run/shm
cgroup          5.9G     0  5.9G   0% /sys/fs/cgroup
/dev/md1        496M   41M  430M   9% /boot

=== memory ===
             total       used       free     shared    buffers     cached
Mem:         32179      29030       3148          0       4546       9366
-/+ buffers/cache:        777      11230
Swap:         6139          0       6139

=== network ===
Kernel Interface table
Iface   MTU Met   RX-OK RX-ERR RX-DRP RX-OVR    TX-OK TX-ERR TX-DRP TX-OVR Flg
eth0       1500 0   4556484      0      0 0       4997804      0      0      0 BMRU
lo        65536 0  70887450      0      0 0      70887450      0      0      0 LRU

=== MySQL error log ===

=== MySQL counters ===
collecting data for MHC-QA1, passes: 1/3 2/3 3/3 Done!
=========================================================================
Details and explanations: http://astellar.com/mysql-health-check/metrics/
=========================================================================
Values:                                 Uptime  Live#1  Live#2
== Load ==
Questions:                              17,979  26,335  25,896
Queries:                                17,979  26,335  25,896
== Rates ==
Select rate:                            518     716     684
Insert rate:                            96      100     95
Update rate:                            73      73      70
Delete rate:                            1       1       0
R/W rate:                               3       4       4
== MySQL IO pressure ==
Handler_read_rnd                        1,391   1,847   1,711
Innodb_data_writes                      28      27      36
Innodb_data_reads                       1       2       1
Innodb_dblwr_writes                     1       1       1
Innodb_log_writes                       1       1       1
== Key buffer efficiency ==
Key_read_requests                       0       0       0
Key_reads                               0       0       0
== Query-related stats ==
Select_scan                             29      34      32
Select_full_join                        0       0       0
Created_tmp_tables                      0       0       1
Created_tmp_disk_tables                 0       0       0
== MySQL Locking ==
Innodb_log_waits                        0       0       0
Table_locks_waited                      0       0       0
== MySQL connections ==
Threads_created                         0       0       0
Connections                             0       0       1
Aborted_connects                        0       0       0
== Qcache ==
Hits:                   111,899,109
Inserts:                10,191,466
Hits/Selects:           10.43

==== MySQL slow queries report ====

# 3.1s user time, 10ms system time, 22.39M rss, 80.27M vsz
# Current date: Thu Nov 20 11:30:41 2014
# Hostname: MHC-QA1
# Files: /var/lib/mysql/digests/141120.log
# Overall: 15.41k total, 12 unique, 5.01 QPS, 0.00x concurrency __________
# Time range: 2014-11-20 10:39:22 to 11:30:38
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time          526ms     1us     1ms    34us    33us    23us    31us
# Lock time          473us       0    64us       0       0     1us       0
# Rows sent          2.80k       0     312    0.19       0    7.22       0
# Rows examine       2.74k       0     312    0.18       0    7.22       0
# Query size       914.97k       8     282   60.79   59.77    4.24   59.77

# Profile
# Rank Query ID           Response time Calls R/Call V/M   Item
# ==== ================== ============= ===== ====== ===== ===============
#    1 0xA66700C2662E4ADF  0.5126 97.5% 15327 0.0000  0.00 SELECT commands
#    2 0x28FC5B5D583E2DA6  0.0088  1.7%     9 0.0010  0.00 SHOW GLOBAL STATUS
#    3 0x16219655761820A2  0.0033  0.6%    51 0.0001  0.00 SELECT
#    4 0xE3A3649C5FAC418D  0.0004  0.1%     6 0.0001  0.00 SELECT
#    5 0x195CA5873F04E6C1  0.0001  0.0%     3 0.0000  0.00 SELECT
# MISC 0xMISC              0.0003  0.1%    15 0.0000   0.0 <6 ITEMS>

# Query 1: 4.98 QPS, 0.00x concurrency, ID 0xA66700C2662E4ADF at byte 1906850
# Scores: V/M = 0.00
# Time range: 2014-11-20 10:39:22 to 11:30:38
...

Download : Main page : Report explained : Request support

Your email address will not be published. Required fields are marked *

*