pt-mysql-summary 使用

[root@781c38071bbd ~]# pt-mysql-summary --host=172.17.0.2 --port=3306 --user=user0001 --password=User0001!
mysql: [Warning] Using a password on the command line interface can be insecure.
# Percona Toolkit MySQL Summary Report #######################
              System time | 2022-06-23 02:18:33 UTC (local TZ: UTC +0000)
# Instances ##################################################
  Port  Data Directory             Nice OOM Socket
  ===== ========================== ==== === ======
# MySQL Executable ###########################################
       Path to executable | /usr/sbin/mysqld
              Has symbols | Yes
# Slave Hosts ################################################
*************************** 1. row ***************************
 Server_id: 4
      Host:
      Port: 3306
 Master_id: 1
Slave_UUID: 5d939d06-ad4e-11ec-a3fd-fa163e102a2d
# Report On Port 3306 ########################################
                     User | user0001@%
                     Time | 2022-06-23 02:18:33 (UTC)
                 Hostname | 781c38071bbd
                  Version | 8.0.28 MySQL Community Server - GPL
                 Built On | Linux x86_64
                  Started | 2022-06-23 02:07 (up 0+00:10:38)
                Databases | 7
                  Datadir | /var/lib/mysql/
                Processes | 2 connected, 3 running
              Replication | Is not a slave, has 1 slaves connected
                  Pidfile | /var/run/mysqld/mysqld.pid (exists)
# Processlist ################################################

  Command                        COUNT(*) Working SUM(Time) MAX(Time)
  ------------------------------ -------- ------- --------- ---------
  Binlog Dump                           1       1       125       125
  Daemon                                1       1       600       600
  Query                                 1       1         0         0

  User                           COUNT(*) Working SUM(Time) MAX(Time)
  ------------------------------ -------- ------- --------- ---------
  event_scheduler                       1       1       600       600
  user0001                              2       2       125       125

  Host                           COUNT(*) Working SUM(Time) MAX(Time)
  ------------------------------ -------- ------- --------- ---------
  172.17.0.3                            1       1       125       125
  781c38071bbd                          1       1         0         0
  localhost                             1       1       600       600

  db                             COUNT(*) Working SUM(Time) MAX(Time)
  ------------------------------ -------- ------- --------- ---------
  NULL                                  3       3       800       600

  State                          COUNT(*) Working SUM(Time) MAX(Time)
  ------------------------------ -------- ------- --------- ---------
  init                                  1       1         0         0
  Source has sent all binlog to         1       1       125       125
  Waiting on empty queue                1       1       600       600

# Status Counters (Wait 10 Seconds) ##########################
Variable                                Per day  Per second     10 secs
Aborted_clients                             125
Bytes_received                           600000           6         600
Bytes_sent                          17500000000      225000        3000
Com_admin_commands                          250
Com_change_db                               125
Com_create_db                               125
Com_create_table                           4500
Com_flush                                   125
Com_select                                 2500                       2
Com_set_option                             1750
Com_show_master_status                      125
Com_show_replica_status                     125
Com_show_slave_status                       125
Com_show_status                             250
Com_show_variables                          400
Connections                                2250                       1
Created_tmp_disk_tables                     250
Created_tmp_files                           700
Created_tmp_tables                          900
Error_log_buffered_bytes                6000000          70
Error_log_buffered_events                 45000
Error_log_latest_write              225000000000000000 2500000000000
Flush_commands                              400
Handler_commit                            80000
Handler_external_lock                    800000           9           9
Handler_read_first                         6000
Handler_read_key                         225000           2           3
Handler_read_next                        500000           6           7
Handler_read_rnd_next                    500000           5         100
Handler_update                            45000
Handler_write                            150000           1          50
Innodb_buffer_pool_bytes_data        2500000000       30000       -1638
Innodb_buffer_pool_pages_flushed          25000
Innodb_buffer_pool_read_requests        2000000          25          20
Innodb_buffer_pool_reads                 125000           1
Innodb_buffer_pool_write_requests        250000           2           4
Innodb_data_fsyncs                         7000
Innodb_data_read                     2000000000       25000        1750
Innodb_data_reads                        125000           1
Innodb_data_writes                        30000
Innodb_data_written                   400000000        4500        1750
Innodb_dblwr_pages_written                 4000
Innodb_dblwr_writes                        1000
Innodb_log_write_requests                100000           1
Innodb_log_writes                          3000
Innodb_os_log_fsyncs                       2250
Innodb_os_log_written                   5000000          60
Innodb_pages_created                      20000
Innodb_pages_read                        125000           1
Innodb_pages_written                      25000
Innodb_rows_inserted                        700                       4
Innodb_rows_read                            700                       4
Innodb_system_rows_deleted                 2500
Innodb_system_rows_read                  700000           7          10
Innodb_system_rows_updated                45000
Innodb_num_open_files                      2500
Innodb_undo_tablespaces_total               250
Innodb_undo_tablespaces_implicit            250
Innodb_undo_tablespaces_active              250
Mysqlx_port                             4500000          50
Mysqlx_ssl_ctx_verify_mode                  700
Mysqlx_worker_threads                       250
Open_table_definitions                     6000
Opened_files                                400
Opened_table_definitions                  10000
Opened_tables                             22500                       2
Performance_schema_session_connect_attrs_longest_seen       22500
Queries                                    6000                       5
Questions                                  6000                       5
Select_scan                                1750
Ssl_accepts                                 800                       1
Ssl_finished_accepts                        800                       1
Table_locks_immediate                       700
Table_open_cache_hits                    400000           4           2
Table_open_cache_misses                   22500                       2
Threads_created                             250
Uptime                                    90000           1           1
# Table cache ################################################
                     Size | 4000
                    Usage | 2%
# Key Percona Server features ################################
      Table & Index Stats | Not Supported
     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 | Not Supported
     Replica Perf Logging | Disabled
      Response Time Hist. | Not Supported
          Smooth Flushing | Not Supported
      HandlerSocket NoSQL | Not Supported
           Fast Hash UDFs | Unknown
# Percona XtraDB Cluster #####################################
mysql: [Warning] Using a password on the command line interface can be insecure.
# Plugins ####################################################
       InnoDB compression | ACTIVE
# Schema #####################################################
Specify --databases or --all-databases to dump and summarize schemas
# Noteworthy Technologies ####################################
                      SSL | Yes
     Explicit LOCK TABLES | No
           Delayed Insert | No
          XA Transactions | No
              NDB Cluster | No
      Prepared Statements | No
 Prepared statement count | 0
# InnoDB #####################################################
                  Version | 8.0.28
         Buffer Pool Size | 128.0M
         Buffer Pool Fill | 15%
        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 | fsync
      Flush Log At Commit | 1
               XA Support |
                Checksums |
              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 |
        Adaptive Flushing | ON
      Adaptive Checkpoint |
           Checkpoint Age | 0
             InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue
       Oldest Transaction | 0 Seconds
         History List Len | 0
               Read Views | 0
         Undo Log Entries | 0 transactions, 0 total undo, 0 max undo
        Pending I/O Reads | 0 buf pool reads, 0 normal AIO, 0 ibuf AIO, 0 preads
       Pending I/O Writes | 0 buf pool (0 LRU, 0 flush list, 0 page); 0 AIO, 0 sync, 0 log IO (0 log, 0 chkp); 0 pwrites
      Pending I/O Flushes | 0 buf pool, 0 log
       Transaction States | 3xnot started
# MyISAM #####################################################
                Key Cache | 8.0M
                 Pct Used | 20%
                Unflushed | 0%
# Security ###################################################
                    Users | 2 users, 0 anon, 0 w/o pw, 0 old pw
            Old Passwords |
# Encryption #################################################
mysql: [Warning] Using a password on the command line interface can be insecure.
No keyring plugins found
# Binary Logging #############################################
                  Binlogs | 9
               Zero-Sized | 0
               Total Size | 129.1M
            binlog_format | ROW
         expire_logs_days | 0
              sync_binlog | 1
                server_id | 1
             binlog_do_db |
         binlog_ignore_db |
# Noteworthy Variables #######################################
     Auto-Inc Incr/Offset | 1/1
   default_storage_engine | InnoDB
               flush_time | 0
             init_connect |
                init_file |
                 sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
         join_buffer_size | 256k
         sort_buffer_size | 256k
         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 | 64M
             thread_stack | 1M
                      log |
                log_error | /var/log/mysqld.log
             log_warnings |
         log_slow_queries |
log_queries_not_using_indexes | OFF
        log_slave_updates | ON
# Configuration File #########################################
              Config File | /etc/my.cnf

[mysqld]
datadir                             = /var/lib/mysql
socket                              = /var/lib/mysql/mysql.sock
log-error                           = /var/log/mysqld.log
pid-file                            = /var/run/mysqld/mysqld.pid
server-id                           = 1
secure-file-priv                    = NULL
gtid_mode                           = off
enforce_gtid_consistency            = off
default_authentication_plugin       = mysql_native_password
# Memory management library ##################################
jemalloc is not enabled in mysql config for process with id 11018
# The End ####################################################