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
pt-mysql-summary 3.0.2
openxs@ao756:~/dbs/maria10.2$ pt-mysql-summary --socket=/tmp/mariadb.sock
# Percona Toolkit MySQL Summary Report ####################### System time | 2017-04-18 09:58:52 UTC (local TZ: EEST +0300)
# Instances ##################################################
Port Data Directory Nice OOM Socket
===== ========================== ==== === ====== /var/lib/mysql 0 0
3307 /home/openxs/dbs/maria10.2/data 0 0 /tmp/mariadb.sock
# MySQL Executable ###########################################
Path to executable | /home/openxs/dbs/maria10.2/bin/mysqld
Has symbols | Yes
Path to executable | /usr/sbin/mysqld
Has symbols | No
# Report On Port 3307 ######################################## 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)
# 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) ##########################
Variable Per day Per second 11 secs
Access_denied_errors 7000
...
Questions 70000 3
Rocksdb_block_cache_add 3000
Rocksdb_block_cache_data_hit 10000
Rocksdb_block_cache_data_miss 1250
Rocksdb_block_cache_hit 17500
Rocksdb_block_cache_index_hit 8000
Rocksdb_block_cache_index_miss 1750
Rocksdb_block_cache_miss 3000
Rocksdb_bytes_read 125000 1
Rocksdb_bytes_written 7000
Rocksdb_compact_write_bytes 700000 7
Rocksdb_memtable_miss 5000
Rocksdb_no_file_opens 1750
Rocksdb_number_keys_read 5000
Rocksdb_number_sst_entry_put 2500
Rocksdb_number_superversion_acquires 1250
Rocksdb_wal_bytes 7000
Rocksdb_wal_synced 600
Rocksdb_write_self 600
Rocksdb_write_wal 600
Rows_read 15000
Rows_sent 4000000 45 60
Rows_tmp_read 3500000 45 60
Select_scan 10000
Syncs 1250
Table_locks_immediate 12500
Threads_created 600
Uptime 90000 1 1
# Table cache ################################################ Size | 431 Usage | 2%
# Key Percona Server features ################################
Table & Index Stats | Disabled
Multiple I/O Threads | Enabled
Corruption Resilient | Not Supported
Durable Replication | Not Supported
Import InnoDB Tables | Not Supported
Fast Server Restarts | Not Supported
Enhanced Logging | Disabled
Replica Perf Logging | Enabled
Response Time Hist. | Not Supported
Smooth Flushing | Not Supported
HandlerSocket NoSQL | Not Supported
Fast Hash UDFs | Unknown
# Percona XtraDB Cluster ##################################### wsrep_on | OFF
# Plugins ####################################################
InnoDB compression | ACTIVE
# Query cache ################################################ query_cache_type | OFF Size | 1,0M Usage | 1% HitToInsertRatio | 0%
# Schema #####################################################
Specify --databases or --all-databases to dump and summarize schemas
# Noteworthy Technologies #################################### SSL | No
Explicit LOCK TABLES | No
Delayed Insert | No
XA Transactions | No
NDB Cluster | No
Prepared Statements | No
Prepared statement count | 0
# InnoDB ##################################################### Version | 5.7.14
Buffer Pool Size | 128,0M
Buffer Pool Fill | 4%
Buffer Pool Dirty | 0%
File Per Table | ON Page Size | 16k
Log File Size | 2 * 48,0M = 96,0M
Log Buffer Size | 16M
Flush Method |
Flush Log At Commit | 1
XA Support | ON Checksums | ON Doublewrite | ON
R/W I/O Threads | 4 4
I/O Capacity | 200
Thread Concurrency | 0
Concurrency Tickets | 5000
Commit Concurrency | 0
Txn Isolation Level | REPEATABLE-READ
Adaptive Flushing | ON
Adaptive Checkpoint |
# MyISAM #####################################################
Key Cache | 128,0M Pct Used | 20% Unflushed | 0%
# Security ################################################### Users |
Old Passwords | OFF
# Binary Logging #############################################
# Noteworthy Variables #######################################
Auto-Inc Incr/Offset | 1/1
default_storage_engine | InnoDB flush_time | 0 init_connect | init_file | sql_mode | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION join_buffer_size | 256k sort_buffer_size | 2M read_buffer_size | 128k
read_rnd_buffer_size | 256k bulk_insert_buffer | 0,00
max_heap_table_size | 16M tmp_table_size | 16M max_allowed_packet | 16M thread_stack | 292k log | log_error | /home/openxs/dbs/maria10.2/data/ao756.err log_warnings | 2 log_slow_queries |
log_queries_not_using_indexes | OFF log_slave_updates | OFF
# Configuration File ######################################### Config File | /etc/my.cnf
[mysqld_safe]
thp-setting = never
pid_file = /var/lib/mysql/ao756.pid
[mysql]
connect_timeout = 2
[mysqld]
server_id = 1
innodb_file_format = Barracuda
table_open_cache = 1156
table_open_cache_instances = 1
log_bin
gtid_mode = ON
enforce_gtid_consistency
log_slave_updates
# Memory management library ##################################
jemalloc is not enabled in MySQL config for process with ID 11088
grep: /proc/1829/environ: Permission denied
jemalloc is not enabled in MySQL config for process with ID 1829
# The End ####################################################
So, it may have something more to do with testing environment than MariaDB 10.2.x itself.
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_read 5000 number_ sst_entry_ put 2500 number_ superversion_ acquires 1250 immediate 12500 ####### ####### ####### ####### ####### ######
Size | 431
Usage | 2% ####### ####### ####### #### ####### ####### ####### ####### ##
wsrep_ on | OFF ####### ####### ####### ####### ####### ####### ### ####### ####### ####### ####### ####### ######
query_ cache_type | OFF
Size | 1,0M
Usage | 1%
HitToInsertRa tio | 0% ####### ####### ####### ####### ####### ####### #### ####### ####### ####### ####### #
SSL | No ####### ####### ####### ####### ####### ####### ####
Version | 5.7.14
Page Size | 16k
Checksums | ON
Doublewrite | ON ####### ####### ####### ####### ####### ####### ####
Pct Used | 20%
Unflushed | 0% ####### ####### ####### ####### ####### ####### ##
Users | ####### ####### ####### ####### ####### ### ####### ####### ####### ####### #### storage_ engine | InnoDB
flush_ time | 0
init_ connect |
init_ file |
sql_ mode | STRICT_ TRANS_TABLES, ERROR_FOR_ DIVISION_ BY_ZERO, NO_AUTO_ CREATE_ USER,NO_ ENGINE_ SUBSTITUTION
join_ buffer_ size | 256k
sort_ buffer_ size | 2M
read_ buffer_ size | 128k rnd_buffer_ size | 256k
bulk_insert_ buffer | 0,00 heap_table_ size | 16M
tmp_ table_size | 16M
max_allowed_ packet | 16M
thread_ stack | 292k
log |
log_error | /home/openxs/ dbs/maria10. 2/data/ ao756.err
log_ warnings | 2
log_slow_ queries | not_using_ indexes | OFF
log_slave_ updates | OFF ####### ####### ####### ####### ######
Config File | /etc/my.cnf
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_
Rocksdb_
Rocksdb_
Rocksdb_wal_bytes 7000
Rocksdb_wal_synced 600
Rocksdb_write_self 600
Rocksdb_write_wal 600
Rows_read 15000
Rows_sent 4000000 45 60
Rows_tmp_read 3500000 45 60
Select_scan 10000
Syncs 1250
Table_locks_
Threads_created 600
Uptime 90000 1 1
# Table cache #######
# Key Percona Server features #######
Table & Index Stats | Disabled
Multiple I/O Threads | Enabled
Corruption Resilient | Not Supported
Durable Replication | Not Supported
Import InnoDB Tables | Not Supported
Fast Server Restarts | Not Supported
Enhanced Logging | Disabled
Replica Perf Logging | Enabled
Response Time Hist. | Not Supported
Smooth Flushing | Not Supported
HandlerSocket NoSQL | Not Supported
Fast Hash UDFs | Unknown
# Percona XtraDB Cluster #######
# Plugins #######
InnoDB compression | ACTIVE
# Query cache #######
# Schema #######
Specify --databases or --all-databases to dump and summarize schemas
# Noteworthy Technologies #######
Explicit LOCK TABLES | No
Delayed Insert | No
XA Transactions | No
NDB Cluster | No
Prepared Statements | No
Prepared statement count | 0
# InnoDB #######
Buffer Pool Size | 128,0M
Buffer Pool Fill | 4%
Buffer Pool Dirty | 0%
File Per Table | ON
Log File Size | 2 * 48,0M = 96,0M
Log Buffer Size | 16M
Flush Method |
Flush Log At Commit | 1
XA Support | ON
R/W I/O Threads | 4 4
I/O Capacity | 200
Thread Concurrency | 0
Concurrency Tickets | 5000
Commit Concurrency | 0
Txn Isolation Level | REPEATABLE-READ
Adaptive Flushing | ON
Adaptive Checkpoint |
# MyISAM #######
Key Cache | 128,0M
# Security #######
Old Passwords | OFF
# Binary Logging #######
# Noteworthy Variables #######
Auto-Inc Incr/Offset | 1/1
default_
read_
max_
log_queries_
# Configuration File #######
[mysqld_safe] mysql/ao756. pid
thp-setting = never
pid_file = /var/lib/
[mysql]
connect_timeout = 2
[mysqld] cache_instances = 1 gtid_consistenc y ####### ####### ####### ###### ####### ####### ####### ####### ####### ####### ###
server_id = 1
innodb_file_format = Barracuda
table_open_cache = 1156
table_open_
log_bin
gtid_mode = ON
enforce_
log_slave_updates
# Memory management library #######
jemalloc is not enabled in MySQL config for process with ID 11088
grep: /proc/1829/environ: Permission denied
jemalloc is not enabled in MySQL config for process with ID 1829
# The End #######
So, it may have something more to do with testing environment than MariaDB 10.2.x itself.