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 (loca...
---对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 ####################################################
【版权声明】本文为华为云社区用户原创内容，转载时必须标注文章的来源（华为云社区）、文章链接、文章作者等基本信息， 否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）