mysql error summary_pt-mysql-summary

[root@mxqmongodb2 bin]# ./pt-mysql-summary --host=172.16.16.35 --port=3306 --user=root --password=123456mysql: [Warning] Using a password on the command line interface can be insecure.

# Percona Toolkit MySQL Summary Report #######################

Systemtime | 2017-06-23 09:09:26 UTC (local TZ: CST +0800)

# Instances ##################################################

Port Data Directory Nice OOM Socket===== ========================== ==== === ======# MySQL Executable ###########################################

# Report On Port3306########################################

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.5x86_64

Started| 2017-06-13 16:54 (up 10+00:15:23)

Databases| 14Datadir| /home/mysql/db3306/data/Processes| 5 connected, 3running

Replication| Is not a slave, has 2slaves connected

Pidfile| /home/mysql/db3306/tmp/mysqld.pid (exists)

# Processlist ################################################

Command COUNT(*) Working SUM(Time) MAX(Time)------------------------------ -------- ------- --------- ---------Binlog Dump GTID2 2 1750000 900000Query1 1 0 0Sleep2 0 2250 2250User COUNT(*) Working SUM(Time) MAX(Time)------------------------------ -------- ------- --------- ---------root5 3 1750000 900000Host COUNT(*) Working SUM(Time) MAX(Time)------------------------------ -------- ------- --------- ---------

172.16.16.34 1 1 900000 900000

172.16.16.35 4 2 900000 900000db COUNT(*) Working SUM(Time) MAX(Time)------------------------------ -------- ------- --------- ---------NULL3 3 1750000 900000test1 0 0 0tpcc1 0 0 0State COUNT(*) Working SUM(Time) MAX(Time)------------------------------ -------- ------- --------- ---------

2 0 0 0Master has sent all binlog to2 2 1750000 900000starting1 1 0 0# Status Counters (Wait10Seconds) ##########################

Variable Per day Per second10secs

Aborted_clients20Aborted_connects2Binlog_cache_disk_use800Binlog_cache_use35000 1Binlog_stmt_cache_use20Bytes_received300000000 3500 600Bytes_sent2250000000 25000 6000Com_admin_commands3000 1Com_alter_table2Com_change_db1250000 15Com_commit40000Com_create_index1Com_create_table4Com_create_trigger2Com_delete10000Com_drop_table3Com_drop_trigger2Com_insert600000 7Com_insert_select800Com_kill1Com_rollback1750000 20Com_select2500000 30 1Com_set_option8000Com_show_create_table20Com_show_databases4Com_show_engine_status4Com_show_fields15Com_show_grants1500Com_show_master_status2500 1Com_show_processlist2500Com_show_slave_status2500 1Com_show_status800Com_show_storage_engines4Com_show_table_status10Com_show_tables15Com_show_triggers2Com_show_variables5000Com_show_warnings800Com_stmt_execute4000000 45Com_stmt_close3000Com_stmt_prepare3500Com_update900000 10 1Connections1750 1Created_tmp_disk_tables35 1Created_tmp_files1Created_tmp_tables8000 6Handler_commit5000000 60 2Handler_delete9000Handler_external_lock10000000 125 2Handler_prepare1750000 20 2Handler_read_first15Handler_read_key4500000 50 1Handler_read_next45000000 500Handler_read_rnd90000 1Handler_read_rnd_next6000000 70 80Handler_rollback1750000 20Handler_update250000 2 1Handler_write4500000 50 40Innodb_buffer_pool_bytes_data12500000 125Innodb_buffer_pool_bytes_dirty350000 4 10000Innodb_buffer_pool_pages_flushed125000 1Innodb_buffer_pool_read_ahead80000Innodb_buffer_pool_read_ahead_evicted1750Innodb_buffer_pool_read_requests80000000 1000 35Innodb_buffer_pool_reads300000 3Innodb_buffer_pool_wait_free3000Innodb_buffer_pool_write_requests4500000 50 30Innodb_data_fsyncs30000 1Innodb_data_read6000000000 70000 3500Innodb_data_reads400000 4Innodb_data_writes150000 1 1Innodb_data_written5000000000 60000 2000Innodb_dblwr_pages_written125000 1Innodb_dblwr_writes3500Innodb_log_write_requests1000000 15 1Innodb_log_writes17500 1Innodb_os_log_fsyncs17500 1Innodb_os_log_written500000000 6000 2000Innodb_pages_created35000Innodb_pages_read400000 4Innodb_pages_written125000 1Innodb_row_lock_time15000000 175Innodb_row_lock_waits8000Innodb_rows_deleted9000Innodb_rows_inserted1500000 15 4Innodb_rows_read45000000 500 5Innodb_rows_updated250000 2 1Innodb_num_open_files4Innodb_available_undo_logs15Key_read_requests15Key_reads1Key_write_requests1Open_table_definitions25Opened_files250Opened_table_definitions70Opened_tables600Qcache_not_cached2500000 30 1Queries7000000 80 8Questions7000000 80 7Rpl_semi_sync_master_no_tx3Select_range2500Select_scan10000Slow_queries7000000 80 8Sort_range6000Sort_rows25000Table_locks_immediate6000Table_open_cache_hits5000000 60 1Table_open_cache_misses600Table_open_cache_overflows225Threads_created90Uptime90000 1 1# Table cache ################################################

Size| 2000Usage| 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.0MUsage| 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.14Buffer Pool Size| 128.0MBuffer Pool Fill| 90%Buffer Pool Dirty| 2%File Per Table|ON

Page Size|16k

Log File Size| 2 * 48.0M = 96.0MLog Buffer Size|16M

Flush Method|Flush Log At Commit| 1XA Support|ON

Checksums|ON

Doublewrite|ON

R/W I/O Threads | 4 4I/O Capacity | 200Thread Concurrency| 0Concurrency Tickets| 5000Commit Concurrency| 0Txn Isolation Level| REPEATABLE-READ

Adaptive Flushing|ON

Adaptive Checkpoint|Checkpoint Age|698k

InnoDB Queue| 0 queries inside InnoDB, 0 queries inqueue

Oldest Transaction| 0Seconds

History List Len| 2159Read Views| 0Undo Log Entries| 0 transactions, 0 total undo, 0max undo

Pending I/O Reads | 0 buf pool reads, 0 normal AIO, 0 ibuf AIO, 0preads

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); 0pwrites

Pending I/O Flushes | 0 buf pool, 0log

Transaction States|4xnot started

# MyISAM #####################################################

Key Cache| 8.0MPct Used| 20%Unflushed| 0%# Security ###################################################

Users|Old Passwords| 0# Binary Logging #############################################

Binlogs| 8Zero-Sized | 0Total Size| 4.8G

binlog_format|ROW

expire_logs_days| 7sync_binlog| 1server_id| 353306binlog_do_db|binlog_ignore_db|# Noteworthy Variables #######################################

Auto-Inc Incr/Offset | 1/1default_storage_engine|InnoDB

flush_time| 0init_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.00max_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| 2log_slow_queries|log_queries_not_using_indexes|ON

log_slave_updates|ON

# Configuration File #########################################

Config File| /etc/my.cnf

[client]

port= 3306socket= /home/mysql/db3306/tmp/mysql.sock

# The End ####################################################