Anemometer
Anemometer copied to clipboard
Add Database Name
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