mysql error summary_pt-mysql-summary

---对mysql配置和status进行汇总

[root@db01 bin]# ./pt-mysql-summary -S /3333/mysql.sock

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

System time | 2021-02-07 00:39:13 UTC (local TZ: CST +0800)

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

Port Data Directory Nice OOM Socket

===== ========================== ==== === ======

3306 /3306/data 0 0 /3306/mysql.sock

3333 /3333/data 0 0 /3333/mysql.sock

# MySQL Executable ###########################################

Path to executable | /opt/mysql3333/bin/mysqld

Has symbols | Yes

Path to executable | /opt/mysql/bin/mysqld

Has symbols | Yes

# Report On Port 3333 ########################################

User | root@localhost

Time | 2021-02-07 08:39:13 (CST)

Hostname | db01

Version | 5.7.27-30 Source distribution

Built On | Linux x86_64

Started | 2021-02-05 15:41 (up 1+16:58:03)

Databases | 4

Datadir | /3333/data/

Processes | 1 connected, 1 running

Replication | Is not a slave, has 0 slaves connected

Pidfile | /3333/run/db.pid (exists)

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

Command COUNT(*) Working SUM(Time) MAX(Time)

------------------------------ -------- ------- --------- ---------

Query 1 1 0 0

User COUNT(*) Working SUM(Time) MAX(Time)

------------------------------ -------- ------- --------- ---------

root 1 1 0 0

Host COUNT(*) Working SUM(Time) MAX(Time)

------------------------------ -------- ------- --------- ---------

localhost 1 1 0 0

db COUNT(*) Working SUM(Time) MAX(Time)

------------------------------ -------- ------- --------- ---------

NULL 1 1 0 0

State COUNT(*) Working SUM(Time) MAX(Time)

------------------------------ -------- ------- --------- ---------

starting 1 1 0 0

# Status Counters (Wait 10 Seconds) ##########################

Variable Per day Per second 11 secs

Bytes_received 1500 175

Bytes_sent 60000 2500

Com_select 15 1

Com_show_status 2

Com_show_variables 1

Connections 15 1

Created_tmp_disk_tables 7 1

Created_tmp_files 3

Created_tmp_tables 50 7

Flush_commands 1

Handler_commit 3

Handler_external_lock 150

Handler_read_first 7

Handler_read_key 5

Handler_read_next 2

Handler_read_rnd_next 3500 80

Handler_write 1750 40

Innodb_background_log_sync 90000 1

Innodb_buffer_pool_bytes_data 2500000 30

Innodb_buffer_pool_pages_flushed 25

Innodb_buffer_pool_read_requests 90000 1 25

Innodb_buffer_pool_reads 125

Innodb_buffer_pool_write_requests 350 25

Innodb_checkpoint_age 5

Innodb_checkpoint_max_age 45000000 500

Innodb_data_fsyncs 4

Innodb_data_read 3500000 40

Innodb_data_reads 225

Innodb_data_writes 35

Innodb_data_written 400000 4 6000

Innodb_dblwr_pages_written 1

Innodb_ibuf_segment_size 1

Innodb_log_writes 1

Innodb_lsn_current 1500000 20

Innodb_lsn_flushed 1500000 20

Innodb_lsn_last_checkpoint 1500000 20

Innodb_master_thread_active_loops 1

Innodb_master_thread_idle_loops 90000

Innodb_max_trx_id 4500

Innodb_mem_adaptive_hash 1250000 15

Innodb_mem_dictionary 400000 4

Innodb_os_log_fsyncs 2

Innodb_os_log_written 600

Innodb_pages_created 20

Innodb_pages_read 125

Innodb_pages0_read 9

Innodb_pages_written 25

Innodb_rows_inserted 30 4

Innodb_rows_read 35 4

Innodb_num_open_files 10

Innodb_available_undo_logs 70

Key_read_requests 7

Key_reads 1

Open_table_definitions 2

Opened_files 80

Opened_table_definitions 60

Opened_tables 70

Qcache_not_cached 15 1

Queries 35 3

Questions 35 3

Select_scan 9

Table_locks_immediate 70

Table_open_cache_hits 5

Table_open_cache_misses 70

Uptime 90000 1 1

# Table cache ################################################

Size | 2000

Usage | 0%

# Key Percona Server features ################################

Table & Index Stats | Disabled

Multiple I/O Threads | Enabled

Corruption Resilient | Enabled

Durable Replication | Not Supported

Import InnoDB Tables | Not Supported

Fast Server Restarts | Not Supported

Enhanced Logging | Disabled

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%

# 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.27-30

Buffer Pool Size | 128.0M

Buffer Pool Fill | 3%

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 |

Checkpoint Age | 9

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 | 1xnot started

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

Key Cache | 8.0M

Pct Used | 20%

Unflushed | 0%

# Security ###################################################

Users |

Old Passwords | 0

# Binary Logging #############################################

# 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_AUTO_CREATE_USER,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 | /3333/log/db.log

log_warnings | 2

log_slow_queries |

log_queries_not_using_indexes | OFF

log_slave_updates | OFF

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

Config File | /3333/my.cnf

[mysqld]

port = 3333

datadir = /3333/data

socket = /3333/mysql.sock

log-error = /3333/log/db.log

[mysqld_safe]

log-error = /3333/log/db.log

pid-file = /3333/run/db.pid

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