Anemometer icon indicating copy to clipboard operation
Anemometer copied to clipboard

Add Database Name

Open MiteshShah opened this issue 9 years ago • 0 comments

O_O[[email protected]:~]# pt-query-digest /var/log/mysql/mysql-slow.log

# Query 1: 0.02 QPS, 0.00x concurrency, ID 0x92F3B1B361FB0E5B at byte 1825
# Scores: V/M = 0.00
# Time range: 2014-10-31 11:16:12 to 11:28:43
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         22      14
# Exec time     63   167ms     4ms    25ms    12ms    19ms     6ms    14ms
# Lock time     17     2ms   116us   284us   168us   204us    43us   176us
# Rows sent     81   8.85k     647     647     647     647       0     647
# Rows examine  65  43.60k   3.11k   3.11k   3.11k   3.11k       0   3.11k
# Rows affecte   0       0       0       0       0       0       0       0
# Bytes sent    94   2.40M 175.84k 175.84k 175.84k 175.84k       0 175.84k
# Query size    10     994      71      71      71      71       0      71
# String:
# Databases    buddypress
# Hosts        localhost
# Last errno   0
# Users        buddypress
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms  ###################################
#  10ms  ################################################################
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `buddypress` LIKE 'wp_options'\G
#    SHOW CREATE TABLE `buddypress`.`wp_options`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'\G

But the database name is not included Anenometer.

https://example.com:22222/db/anemometer/index.php?action=show_query&datasource=localhost&checksum=92F3B1B361FB0E5B

MiteshShah avatar Oct 31 '14 07:10 MiteshShah