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
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
