Feature request: show engine pbxt reports data log files in non relational way
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_
+------
| 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...