pt-mysql-summary does not work with MariaDB 10.2.5
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned |
Bug Description
pt-mysql-summary hangs at the Processlist summary stage when connected to MariaDB 10.2.5:
sveta@Thinkie:
# Percona Toolkit MySQL Summary Report #######
# Instances #######
Port Data Directory Nice OOM Socket
===== =======
16000 /home/sveta/
3306 /var/lib/mysql 0 0 /var/run/
3371 /home/sveta/
3373 /home/sveta/
3374 /home/sveta/
3372 /home/sveta/
# MySQL Executable #######
Path to executable | ./bin/mysqld
Has symbols | Yes
Path to executable | /home/sveta/
Has symbols | Yes
Path to executable | /usr/sbin/mysqld
Has symbols | Yes
# Report On Port 16000 #######
# Processlist #######
Command COUNT(*) Working SUM(Time) MAX(Time)
-----
^C2017_
Tested with versions 2.2.20 and 3.0.2
tags: | added: pt120 |
I see no problem like that with 10.2.6 (on Fedora 25) or 10.2.5 (on Ubuntu 14.04) built from source:
openxs@ ao756:~ /dbs/maria10. 2$ pt-mysql-summary --version ao756:~ /dbs/maria10. 2$ pt-mysql-summary --socket= /tmp/mariadb. sock ####### ####### ##
System time | 2017-04-18 09:58:52 UTC (local TZ: EEST +0300) ####### ####### ####### ####### ####### ####### # ======= ======= ===== ==== === ======
/var/lib/ mysql 0 0 dbs/maria10. 2/data 0 0 /tmp/mariadb.sock ####### ####### ####### ####### ####### # dbs/maria10. 2/bin/mysqld ####### ####### ####### ####### #####
User | @localhost
Time | 2017-04-18 12:58:52 (EEST)
Hostname | ao756
Version | 10.2.5-MariaDB Source distribution
Built On | Linux x86_64
Started | 2017-04-18 12:57 (up 0+00:02:21)
Databases | 2
Datadir | /home/openxs/ dbs/maria10. 2/data/
Processes | 1 connected, 1 running
Replication | Is not a slave, has 0 slaves connected
Pidfile | /home/openxs/ dbs/maria10. 2/data/ ao756.pid (exists) ####### ####### ####### ####### ####### ######
pt-mysql-summary 3.0.2
openxs@
# Percona Toolkit MySQL Summary Report #######
# Instances #######
Port Data Directory Nice OOM Socket
===== =======
3307 /home/openxs/
# MySQL Executable #######
Path to executable | /home/openxs/
Has symbols | Yes
Path to executable | /usr/sbin/mysqld
Has symbols | No
# Report On Port 3307 #######
# Processlist #######
Command COUNT(*) Working SUM(Time) MAX(Time) ------- ------- ------- ---- -------- ------- --------- ---------
-----
User COUNT(*) Working SUM(Time) MAX(Time) ------- ------- ------- ---- -------- ------- --------- ---------
-----
Host COUNT(*) Working SUM(Time) MAX(Time) ------- ------- ------- ---- -------- ------- --------- ---------
-----
db COUNT(*) Working SUM(Time) MAX(Time) ------- ------- ------- ---- -------- ------- --------- ---------
-----
State COUNT(*) Working SUM(Time) MAX(Time) ------- ------- ------- ---- -------- ------- --------- ---------
-----
# Status Counters (Wait 10 Seconds) ####### ####### ####### ##### denied_ errors 7000 block_cache_ add 3000 block_cache_ data_hit 10000 block_cache_ data_miss 1250 block_cache_ hit 17500 block_cache_ index_hit 8000 block_cache_ index_miss 1750 block_cache_ miss 3000 bytes_written 7000 compact_ write_bytes 700000 7 memtable_ miss 5000 no_file_ opens 1750 number_ keys_re. ..
Variable Per day Per second 11 secs
Access_
...
Questions 70000 3
Rocksdb_
Rocksdb_
Rocksdb_
Rocksdb_
Rocksdb_
Rocksdb_
Rocksdb_
Rocksdb_bytes_read 125000 1
Rocksdb_
Rocksdb_
Rocksdb_
Rocksdb_
Rocksdb_