| Thread Previous • Date Previous • Date Next • Thread Next |
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.
| Thread Previous • Date Previous • Date Next • Thread Next |
