Hello,
Lately, i did modify mytop
(https://mariadb.atlassian.net/browse/MDEV-4476) to use
INFORMATION_SCHEMA.PROCESSLIST instead of SHOW PROCESSLIST (when
available) to gather running processes informations as it's more
flexible and has more informations but the value of the PROGRESS column
on both is different, so i wondered if the PROGRESS value on SHOW
PROCESSLIST was using a simple formula like this one or something more
complex :
(STAGE-1)/MAX_STAGE + {decimal progress on the actual
stage}/MAX_STAGE
There seems to be a broken alinea about that on the KB page of the
PROCESSLIST : https://mariadb.com/kb/en/show-processlist/
In any case, what would be the best way to go with mytop, add columns
with the actual_stage/max_stage or only keep the progress of the actual
stage or only the "total" progress using the formula previously shown?
Putting an option and keystroke to show/hide these columns could be
another solution as these values might be of use on only "rare" cases
depending on the workload.
Regards.
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
