Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 10.0.15-FusionIO, 10.1.1
-
Fix Version/s: 10.0.15-FusionIO, 10.1.2
-
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Description
Need support for query stats to provide statistics on the various TRIM operations performed for the page-compression/NVM Compression workload.
For the 2K format block-size it shows none
=======
Innodb_page_compression_saved 364564353024
Innodb_page_compression_trim_sect512 0
Innodb_page_compression_trim_sect4096 0
========
For the 512B and 4K format block-size it shows the following
=======
Innodb_page_compression_saved 284889649152
Innodb_page_compression_trim_sect512 0
Innodb_page_compression_trim_sect4096 13063475
=======
It should support block-size 512B, 1K, 2K, 4K at this time.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
commit ea8322687254fad00143ff7850a67ea8c7f0027e
Author: Jan Lindström <jan.lindstrom@skysql.com>
Date: Wed Nov 12 15:37:52 2014 +0200
MDEV-7088: Query stats for compression based on TRIM size
Analysis: Status variables were missing from innodb_status_variables
array.
Fix: Add missing status variables to the array.
revno: 4002
committer: Jan Lindström <jplindst@mariadb.org>
branch nick: 10.0-FusionIO-release
timestamp: Wed 2014-11-12 10:06:39 +0200
message:
MDEV-7088: Query stats for compression based on TRIM sizeAnalysis: Status variables were missing from innodb_status_variables
array.
Fix: Add missing status variables to the array.