[MDEV-569] Improve processlist reporting of replication threads Created: 2012-10-02  Updated: 2013-06-07  Resolved: 2013-06-07

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: 10.0.4

Type: Task Priority: Minor
Reporter: Kristian Nielsen Assignee: Kristian Nielsen
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

The "state" and "command" reported by SHOW PROCESSLIST for replication threads
is lacking.

Improve it so that DBAs can see more precisely what the threads are doing.

For the SQL thread, "Command" could be "execute" when replicating row events,
and "sleep" when waiting for new events from the IO thread. State could be
"execute row events".

 Comments   
Comment by Kristian Nielsen [ 2012-10-02 ]

The mechanism for updating THD states for processlist is changing with merge of P_S stages into 10.0.

So seems easier to wait for that code to be merged before doing this - it's not urgent.
Might also be easier to do it after merge of multi-source replication.

Generated at Thu Feb 08 06:29:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.