[MDEV-7088] Query stats for compression based on TRIM size Created: 2014-11-12  Updated: 2014-11-12  Resolved: 2014-11-12

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Affects Version/s: 10.0.15-FusionIO, 10.1.1
Fix Version/s: 10.0.15-FusionIO, 10.1.2

Type: Bug Priority: Minor
Reporter: Dhananjoy Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: fusion-io, innodb, 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.

 Comments   
Comment by Jan Lindström (Inactive) [ 2014-11-12 ]

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 size

Analysis: Status variables were missing from innodb_status_variables
array.

Fix: Add missing status variables to the array.

Comment by Jan Lindström (Inactive) [ 2014-11-12 ]

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.

Generated at Thu Feb 08 07:16:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.