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.