Created
March 16, 2023 10:52
-
-
Save yaroslaff/6c934241e74debf2b0e9f0c28231443a to your computer and use it in GitHub Desktop.
pt-mysql-summary
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Percona Toolkit MySQL Summary Report ####################### | |
System time | 2023-03-16 10:51:18 UTC (local TZ: UTC +0000) | |
# Instances ################################################## | |
Port Data Directory Nice OOM Socket | |
===== ========================== ==== === ====== | |
# MySQL Executable ########################################### | |
# Slave Hosts ################################################ | |
No slaves found | |
# Report On Port 3306 ######################################## | |
User | root@localhost | |
Time | 2023-03-16 10:51:18 (UTC) | |
Hostname | ns1 | |
Version | 10.5.18-MariaDB-0+deb11u1 Debian 11 | |
Built On | debian-linux-gnu x86_64 | |
Started | 2023-03-12 14:07 (up 3+20:43:44) | |
Databases | 4 | |
Datadir | /var/lib/mysql/ | |
Processes | 6 connected, 1 running | |
Replication | Is not a slave, has 0 slaves connected | |
Pidfile | /run/mysqld/mysqld.pid (exists) | |
# Processlist ################################################ | |
Command COUNT(*) Working SUM(Time) MAX(Time) | |
------------------------------ -------- ------- --------- --------- | |
Query 1 1 0 0 | |
Sleep 5 0 10000 10000 | |
User COUNT(*) Working SUM(Time) MAX(Time) | |
------------------------------ -------- ------- --------- --------- | |
pdns 5 0 0 0 | |
root 1 1 0 0 | |
Host COUNT(*) Working SUM(Time) MAX(Time) | |
------------------------------ -------- ------- --------- --------- | |
localhost 6 1 0 0 | |
db COUNT(*) Working SUM(Time) MAX(Time) | |
------------------------------ -------- ------- --------- --------- | |
NULL 1 1 0 0 | |
pdns 5 0 0 0 | |
State COUNT(*) Working SUM(Time) MAX(Time) | |
------------------------------ -------- ------- --------- --------- | |
5 0 0 0 | |
starting 1 1 0 0 | |
# Status Counters (Wait 10 Seconds) ########################## | |
Variable Per day Per second 10 secs | |
Aria_pagecache_blocks_unused 4000 | |
Aria_pagecache_blocks_used 2 | |
Aria_pagecache_read_requests 4 7 | |
Aria_pagecache_reads 3 | |
Bytes_received 15000000 175 700 | |
Bytes_sent 175000000 2000 6000 | |
Com_begin 3 | |
Com_commit 3 | |
Com_delete 7 | |
Com_insert 4 | |
Com_select 350000 3 6 | |
Com_set_option 25 | |
Com_show_databases 2 | |
Com_show_fields 35 | |
Com_show_status 5 | |
Com_show_tables 2 | |
Com_stmt_close 100 | |
Com_stmt_execute 350000 3 6 | |
Com_stmt_prepare 100 | |
Com_stmt_reset 350000 3 6 | |
Com_update 10 | |
Connections 35 1 | |
Created_tmp_files 1 | |
Created_tmp_tables 10 | |
Empty_queries 125000 1 2 | |
Feature_json 10 9 | |
Handler_commit 350000 3 6 | |
Handler_delete 4 | |
Handler_icp_attempts 500000 6 4 | |
Handler_icp_match 500000 6 4 | |
Handler_read_key 700000 7 7 | |
Handler_read_next 1500000 20 25 | |
Handler_read_rnd 175 | |
Handler_read_rnd_next 500000 5 70 | |
Handler_tmp_write 900 60 | |
Handler_update 25 | |
Handler_write 4 | |
Innodb_adaptive_hash_non_hash_searches 3000000 35 40 | |
Innodb_background_log_sync 90000 1 | |
Innodb_buffer_pool_bytes_data 2250000 25 | |
Innodb_buffer_pool_bytes_dirty 250000 2 | |
Innodb_buffer_pool_pages_old 60 | |
Innodb_buffer_pool_read_requests 6000000 70 90 | |
Innodb_buffer_pool_reads 100 | |
Innodb_buffer_pool_write_requests 300 | |
Innodb_checkpoint_age 7000 | |
Innodb_checkpoint_max_age 20000000 250 | |
Innodb_data_fsyncs 9 | |
Innodb_data_read 1750000 20 | |
Innodb_data_reads 125 | |
Innodb_data_writes 9 | |
Innodb_log_write_requests 15 | |
Innodb_log_writes 9 | |
Innodb_lsn_current 1500000 15 | |
Innodb_lsn_flushed 1500000 15 | |
Innodb_lsn_last_checkpoint 1500000 15 | |
Innodb_master_thread_active_loops 3 | |
Innodb_master_thread_idle_loops 90000 1 | |
Innodb_max_trx_id 1250 | |
Innodb_mem_dictionary 450000 5 | |
Innodb_os_log_fsyncs 9 | |
Innodb_os_log_written 10000 | |
Innodb_pages_created 35 | |
Innodb_pages_read 100 | |
Innodb_rows_deleted 4 | |
Innodb_rows_inserted 4 | |
Innodb_rows_read 2250000 25 30 | |
Innodb_rows_updated 7 | |
Innodb_num_open_files 5 | |
Innodb_available_undo_logs 35 | |
Innodb_secondary_index_triggered_cluster_reads 600000 6 5 | |
Memory_used 125000000 1500 9000 | |
Memory_used_initial 9000000 100 | |
Open_table_definitions 1 | |
Opened_files 40 1 | |
Opened_table_definitions 15 | |
Opened_tables 15 | |
Queries 700000 7 15 | |
Questions 350000 3 9 | |
Rows_read 2250000 25 30 | |
Rows_sent 600000 6 70 | |
Rows_tmp_read 900 60 | |
Select_range 35000 1 | |
Select_scan 35000 | |
Sort_range 15 | |
Sort_rows 175 | |
Syncs 15 | |
Table_locks_immediate 25 | |
Table_open_cache_hits 400000 4 7 | |
Table_open_cache_misses 15 | |
Threads_created 6 | |
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 | Not Supported | |
Durable Replication | Not Supported | |
Import InnoDB Tables | Not Supported | |
Fast Server Restarts | Not Supported | |
Enhanced Logging | Disabled | |
Replica Perf Logging | Enabled | |
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 | 33 | |
# InnoDB ##################################################### | |
Version | 10.5.18 | |
Buffer Pool Size | 256.0M | |
Buffer Pool Fill | 3% | |
Buffer Pool Dirty | 0% | |
File Per Table | ON | |
Page Size | 16k | |
Log File Size | 1 * 96.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 | 0 | |
Commit Concurrency | 0 | |
Txn Isolation Level | REPEATABLE-READ | |
Adaptive Flushing | ON | |
Adaptive Checkpoint | | |
Checkpoint Age | 28k | |
InnoDB 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 | 5xnot started | |
# MyISAM ##################################################### | |
Key Cache | 128.0M | |
Pct Used | 20% | |
Unflushed | 0% | |
# Security ################################################### | |
Users | 3 users, 0 anon, 2 w/o pw, 2 old pw | |
Old Passwords | OFF | |
# Encryption ################################################# | |
No keyring plugins found | |
# Binary Logging ############################################# | |
# Noteworthy Variables ####################################### | |
Auto-Inc Incr/Offset | 1/1 | |
default_storage_engine | InnoDB | |
flush_time | 0 | |
init_connect | | |
init_file | | |
sql_mode | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | |
join_buffer_size | 256k | |
sort_buffer_size | 2M | |
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 | 16M | |
thread_stack | 292k | |
log | | |
log_error | | |
log_warnings | 2 | |
log_slow_queries | | |
log_queries_not_using_indexes | OFF | |
log_slave_updates | OFF | |
# Configuration File ######################################### | |
Config File | /etc/mysql/my.cnf | |
[client-server] | |
socket = /run/mysqld/mysqld.sock | |
# Memory management library ################################## | |
# The End #################################################### |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment