maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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@xxxxxxxxxx>:
> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp



-- 
Roberto Spadim
SPAEmpresarial