box / box/Anemometer

Add Database Name

Open
#119 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
1.4k
Forks
306
PR merge metrics
No merged PRs in 30d

Description

O_O[root@example.com:~]# pt-query-digest /var/log/mysql/mysql-slow.log

``` bash
# 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

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.