Hi Kristian!

On Tue, Jan 10, 2017 at 5:37 PM, Kristian Nielsen <knielsen@knielsen-hq.org> wrote:
> Sachin Setiya <sachin.setiya@mariadb.com> writes:
>
>> Okay, So it there a better way to show progress in slave ?
>
> You have not explained what you mean by "showing progress".
>
> Doesn't SHOW SLAVE STATUS already show event-by-event progress in the relay
> log position?
>
> For progress inside a row event, for example one could display the offset of
> current row operation as a percentage of total event size. Be sure to
> consider the performance impact of such status updates.
>
> Why does replication slave need different progress monitoring than any other
> thread doing queriess?
>
> I mean, more visibility and monitoring is nice, sure. But it should start
> with a general approach and design. Not by randomly adding bits and pieces
> to various binlog events (or other places) without a clear idea what is
> being achieved, and why...
>
>  - Kristian.
This task is related to mdev-7409 / mdev-4557.
I have created a patch for this mdev. but I was thinking for monitoring command 'SHOW PROCESSLIST'
in Progress column can we show how much % of the events from Event group Slave has applied so that
user can get a better monitoring.
If I apply my patch I get only this.
MariaDB [d]> show processlist;
+----+-------------+-----------+------+---------+------+-------------------------------------------------+------------------+----------+
| Id | User        | Host      | db   | Command | Time | State                                           | Info             | Progress |
+----+-------------+-----------+------+---------+------+-------------------------------------------------+------------------+----------+
|  3 | system user |           | d    | Connect |    0 | Write_rows_log_event::write_row(-1) on table t1 | NULL             |    0.000 |
|  4 | system user |           | NULL | Connect |  121 | Waiting for master to send event                | NULL             |    0.000 |
|  7 | root        | localhost | d    | Query   |    0 | init                                            | show processlist |    0.000 |
+----+-------------+-----------+------+---------+------+-------------------------------------------------+------------------+----------+