Comment 1 for bug 1680803

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

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.