pt-mysql-summary主要用来输出MySQL的基本信息，可以作为数据库巡检以及刚开始熟悉数据库环境时候进行使用：
[root@mxqmongodb2 bin]# ./pt-mysql-summary --host=172.16.16.35 --port=3306 --user=root --password=123456 mysql: [Warning] Using a password on the command line interface can be insecure. # Percona Toolkit MySQL Summary Report ####################### System time | 2017-06-23 09:09:26 UTC (local TZ: CST +0800) # Instances ################################################## Port Data Directory Nice OOM Socket ===== ========================== ==== === ====== # MySQL Executable ########################################### # Report On Port 3306 ######################################## User | root@% Time | 2017-06-23 17:09:26 (CST) Hostname | mxqmongodb2 Version | 5.7.14-log MySQL Community Server (GPL) Built On | linux-glibc2.5 x86_64 Started | 2017-06-13 16:54 (up 10+00:15:23) Databases | 14 Datadir | /home/mysql/db3306/data/ Processes | 5 connected, 3 running Replication | Is not a slave, has 2 slaves connected Pidfile | /home/mysql/db3306/tmp/mysqld.pid (exists) # Processlist ################################################ Command COUNT(*) Working SUM(Time) MAX(Time) ------------------------------ -------- ------- --------- --------- Binlog Dump GTID 2 2 1750000 900000 Query 1 1 0 0 Sleep 2 0 2250 2250 User COUNT(*) Working SUM(Time) MAX(Time) ------------------------------ -------- ------- --------- --------- root 5 3 1750000 900000 Host COUNT(*) Working SUM(Time) MAX(Time) ------------------------------ -------- ------- --------- --------- 172.16.16.34 1 1 900000 900000 172.16.16.35 4 2 900000 900000 db COUNT(*) Working SUM(Time) MAX(Time) ------------------------------ -------- ------- --------- --------- NULL 3 3 1750000 900000 test 1 0 0 0 tpcc 1 0 0 0 State COUNT(*) Working SUM(Time) MAX(Time) ------------------------------ -------- ------- --------- --------- 2 0 0 0 Master has sent all binlog to 2 2 1750000 900000 starting 1 1 0 0 # Status Counters (Wait 10 Seconds) ########################## Variable Per day Per second 10 secs Aborted_clients 20 Aborted_connects 2 Binlog_cache_disk_use 800 Binlog_cache_use 35000 1 Binlog_stmt_cache_use 20 Bytes_received 300000000 3500 600 Bytes_sent 2250000000 25000 6000 Com_admin_commands 3000 1 Com_alter_table 2 Com_change_db 1250000 15 Com_commit 40000 Com_create_index 1 Com_create_table 4 Com_create_trigger 2 Com_delete 10000 Com_drop_table 3 Com_drop_trigger 2 Com_insert 600000 7 Com_insert_select 800 Com_kill 1 Com_rollback 1750000 20 Com_select 2500000 30 1 Com_set_option 8000 Com_show_create_table 20 Com_show_databases 4 Com_show_engine_status 4 Com_show_fields 15 Com_show_grants 1500 Com_show_master_status 2500 1 Com_show_processlist 2500 Com_show_slave_status 2500 1 Com_show_status 800 Com_show_storage_engines 4 Com_show_table_status 10 Com_show_tables 15 Com_show_triggers 2 Com_show_variables 5000 Com_show_warnings 800 Com_stmt_execute 4000000 45 Com_stmt_close 3000 Com_stmt_prepare 3500 Com_update 900000 10 1 Connections 1750 1 Created_tmp_disk_tables 35 1 Created_tmp_files 1 Created_tmp_tables 8000 6 Handler_commit 5000000 60 2 Handler_delete 9000 Handler_external_lock 10000000 125 2 Handler_prepare 1750000 20 2 Handler_read_first 15 Handler_read_key 4500000 50 1 Handler_read_next 45000000 500 Handler_read_rnd 90000 1 Handler_read_rnd_next 6000000 70 80 Handler_rollback 1750000 20 Handler_update 250000 2 1 Handler_write 4500000 50 40 Innodb_buffer_pool_bytes_data 12500000 125 Innodb_buffer_pool_bytes_dirty 350000 4 10000 Innodb_buffer_pool_pages_flushed 125000 1 Innodb_buffer_pool_read_ahead 80000 Innodb_buffer_pool_read_ahead_evicted 1750 Innodb_buffer_pool_read_requests 80000000 1000 35 Innodb_buffer_pool_reads 300000 3 Innodb_buffer_pool_wait_free 3000 Innodb_buffer_pool_write_requests 4500000 50 30 Innodb_data_fsyncs 30000 1 Innodb_data_read 6000000000 70000 3500 Innodb_data_reads 400000 4 Innodb_data_writes 150000 1 1 Innodb_data_written 5000000000 60000 2000 Innodb_dblwr_pages_written 125000 1 Innodb_dblwr_writes 3500 Innodb_log_write_requests 1000000 15 1 Innodb_log_writes 17500 1 Innodb_os_log_fsyncs 17500 1 Innodb_os_log_written 500000000 6000 2000 Innodb_pages_created 35000 Innodb_pages_read 400000 4 Innodb_pages_written 125000 1 Innodb_row_lock_time 15000000 175 Innodb_row_lock_waits 8000 Innodb_rows_deleted 9000 Innodb_rows_inserted 1500000 15 4 Innodb_rows_read 45000000 500 5 Innodb_rows_updated 250000 2 1 Innodb_num_open_files 4 Innodb_available_undo_logs 15 Key_read_requests 15 Key_reads 1 Key_write_requests 1 Open_table_definitions 25 Opened_files 250 Opened_table_definitions 70 Opened_tables 600 Qcache_not_cached 2500000 30 1 Queries 7000000 80 8 Questions 7000000 80 7 Rpl_semi_sync_master_no_tx 3 Select_range 2500 Select_scan 10000 Slow_queries 7000000 80 8 Sort_range 6000 Sort_rows 25000 Table_locks_immediate 6000 Table_open_cache_hits 5000000 60 1 Table_open_cache_misses 600 Table_open_cache_overflows 225 Threads_created 90 Uptime 90000 1 1 # Table cache ################################################ Size | 2000 Usage | 90% # 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 ##################################### # Plugins #################################################### InnoDB compression | ACTIVE # Query cache ################################################ query_cache_type | OFF Size | 1.0M Usage | 1% HitToInsertRatio | 0% # Semisynchronous Replication ################################ Master | Disabled Slave | Disabled # 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 | Yes Prepared statement count | 0 # InnoDB ##################################################### Version | 5.7.14 Buffer Pool Size | 128.0M Buffer Pool Fill | 90% Buffer Pool Dirty | 2% 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 | Checkpoint Age | 698k InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue Oldest Transaction | 0 Seconds History List Len | 2159 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 | 4xnot started # MyISAM ##################################################### Key Cache | 8.0M Pct Used | 20% Unflushed | 0% # Security ################################################### Users | Old Passwords | 0 # Binary Logging ############################################# Binlogs | 8 Zero-Sized | 0 Total Size | 4.8G binlog_format | ROW expire_logs_days | 7 sync_binlog | 1 server_id | 353306 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 | 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 | 4M thread_stack | 256k log | log_error | /home/mysql/db3306/log/mysql-error.log log_warnings | 2 log_slow_queries | log_queries_not_using_indexes | ON log_slave_updates | ON # Configuration File ######################################### Config File | /etc/my.cnf [client] port = 3306 socket = /home/mysql/db3306/tmp/mysql.sock # The End ####################################################