pt-mysql-summary blank InnoDB section for 5.6
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
High
|
Frank Cizmich |
Bug Description
This is because have_innodb variable does not exist on 5.6 anymore.
[revin@forge ~]$ /wok/bin/
pt-mysql-summary 2.2.5
[revin@forge ~]$ /wok/bin/
# Percona Toolkit MySQL Summary Report #######
# Instances #######
Port Data Directory Nice OOM Socket
===== =======
3306 /wok/dta/mysql 0 0 /wok/dta/
56140 /ssd/msb/
# MySQL Executable #######
Path to executable | /usr/libexec/mysqld
Has symbols | No
Path to executable | /wok/bin/
Has symbols | Yes
# Report On Port 56140 #######
# Processlist #######
...
# Percona XtraDB Cluster #######
# Plugins #######
InnoDB compression | ACTIVE
# Query cache #######
# Schema #######
Would you like to mysqldump -d the schema and analyze it? y/n n
Skipping schema analysis
# Noteworthy Technologies #######
Explicit LOCK TABLES | Yes
Delayed Insert | No
XA Transactions | No
NDB Cluster | No
Prepared Statements | No
Prepared statement count | 0
# InnoDB #######
# MyISAM #######
Key Cache | 8.0M
# Security #######
...
# The End #######
[revin@forge ~]$ /wok/bin/
# Percona Toolkit MySQL Summary Report #######
# Instances #######
Port Data Directory Nice OOM Socket
===== =======
3306 /wok/dta/mysql 0 0 /wok/dta/
56140 /ssd/msb/
# MySQL Executable #######
Path to executable | /usr/libexec/mysqld
Has symbols | No
Path to executable | /wok/bin/
Has symbols | Yes
# Report On Port 3306 #######
# Processlist #######
...
# Percona XtraDB Cluster #######
# Plugins #######
InnoDB compression | ACTIVE
# Query cache #######
# Schema #######
Would you like to mysqldump -d the schema and analyze it? y/n n
Skipping schema analysis
# Noteworthy Technologies #######
Explicit LOCK TABLES | No
Delayed Insert | No
XA Transactions | No
NDB Cluster | No
Prepared Statements | No
Prepared statement count | 0
# InnoDB #######
Buffer Pool Size | 512.0M
Buffer Pool Fill | 1%
Buffer Pool Dirty | 0%
File Per Table | ON
Log File Size | 2 * 256.0M = 512.0M
Log Buffer Size | 8M
Flush Method |
Flush Log At Commit | 1
XA Support | ON
R/W I/O Threads | 4 4
I/O Capacity | 200
Thread Concurrency | 0
Concurrency Tickets | 500
Commit Concurrency | 0
Txn Isolation Level | REPEATABLE-READ
Adaptive Flushing | ON
Adaptive Checkpoint |
InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue
Oldest Transaction | 0 Seconds
History List Len | 1478
Read Views | 1
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 | 128.0M
# Security #######
...
# The End #######
Related branches
- Daniel Nichter: Approve
-
Diff: 33 lines (+9/-2)2 files modifiedbin/pt-mysql-summary (+2/-2)
t/pt-mysql-summary/pt-mysql-summary.t (+7/-0)
Changed in percona-toolkit: | |
assignee: | nobody → Frank Cizmich (frank-cizmich) |
importance: | Undecided → High |
status: | Confirmed → Won't Fix |
status: | Won't Fix → Triaged |
tags: | added: pt-mysql-summary |
Changed in percona-toolkit: | |
status: | Triaged → In Progress |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
summary: |
- pt-mysql-summary Blank InnoDB Section for 5.6 + pt-mysql-summary blank InnoDB Section for 5.6 |
summary: |
- pt-mysql-summary blank InnoDB Section for 5.6 + pt-mysql-summary blank InnoDB section for 5.6 |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
Confirmed in latest 2.2.5.