Feature request: show engine pbxt reports data log files in non relational way

Bug #719596 reported by shinguz
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
PBXT
New
Undecided
Unassigned

Bug Description

SHOW ENGINE PBXT STATUS reports the information of the data log files in a non-relational way which is difficult to parse:

SHOW ENGINE PBXT STATUS\G
...
Data log files:
d-log: 1 status=has-space eof=20765 garbage=0 g%=0 open=0

Ideally in an relational database I would like to have those informations in such a way:

CREATE TABLE pbxt.data_log_files (
  data_log_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, status VARCHAR(16)
, eof BIGINT UNSIGNED
, garbage BIGINT UNSIGNED
, garbage_pct TINYINT UNSIGNED
, `open` TINYINT UNSIGNED
) engine = pbxt;

INSERT INTO pbxt.data_log_files VALUES
  (1, 'deleted', 536877571, 536877528, 99, 0)
, (2, 'to-delete', 536884529, 536884486, 99, 0)
, (3, 'to-compact', 536875249, 326535432, 60, 1)
, (4, 'read-only', 536876941, 0, 0, 0)
, (5, 'x-locked', 536872185, 0, 0, 0)
, (6, 'has-space', 20765, 0, 0, 0)
;

select * from pbxt.data_log_files;
+-------------+------------+-----------+-----------+-------------+------+
| data_log_id | status | eof | garbage | garbage_pct | open |
+-------------+------------+-----------+-----------+-------------+------+
| 1 | deleted | 536877571 | 536877528 | 99 | 0 |
| 2 | to-delete | 536884529 | 536884486 | 99 | 0 |
| 3 | to-compact | 536875249 | 326535432 | 60 | 1 |
| 4 | read-only | 536876941 | 0 | 0 | 0 |
| 5 | x-locked | 536872185 | 0 | 0 | 0 |
| 6 | has-space | 20765 | 0 | 0 | 0 |
+-------------+------------+-----------+-----------+-------------+------+

So we can use it for reporting, alerting, monitoring and graphing...

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.