[Maria-discuss] INFORMATION_SCHEMA.PROCESSLIST values of PROGRESS, STAGE and STAGE_MAX
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.
hum what i know, there's a incomplete implementation with partitions and stage when you use repair table or other command like this 2013/12/10 Jean Weisbuch <jean@phpnet.org>:
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 : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial
Hi
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/
Thanks Jean, the Knowledge Base error seemed to be old syntax no longer supported. I've fixed it, and linked to https://mariadb.com/kb/en/progress-reporting/ It's not ideal that SHOW PROCESSLIST and INFORMATION_SCHEMA.PROCESSLIST show different values for a field with the same name, and the information schema should probably be extended to show both. The SHOW PROCESSLIST version of the progress seems to be more useful in theory, but I'm not sure of the thinking behind changing this for the information schema (perhaps accuracy?). I think the partitions issue Roberto was referring to is: https://mariadb.atlassian.net/browse/MDEV-4417 ian
And, to answer your question:
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
your formula is correct, as double total_progress= ((stage -1) / (double) max_stage * 100.00 + progress / max_stage); is the formula used. ian
participants (3)
-
Ian Gilfillan -
Jean Weisbuch -
Roberto Spadim