[MDEV-7409] On RBR, extend the PROCESSLIST info to include at least the name of the recently used table Created: 2015-01-05  Updated: 2023-08-01  Resolved: 2021-02-28

Status: Closed
Project: MariaDB Server
Component/s: Replication
Fix Version/s: 10.6.0

Type: Task Priority: Major
Reporter: Stoykov (Inactive) Assignee: Sachin Setiya (Inactive)
Resolution: Fixed Votes: 2
Labels: None

Issue Links:
Duplicate
duplicates MDEV-4557 Make status more visible in RBR Closed
Sprint: 10.1.21, 10.1.24

 Description   

When RBR is used, add the db.table name to the "SHOW FULL PROCESSLIST" command output.

Something like: table name - and the operation it is doing like: INSERT/UPDATE/DELETE/TRUNCATE will be good enough.

Note: there is similar MySQL request filled here : http://bugs.mysql.com/bug.php?id=62019



 Comments   
Comment by Stoykov (Inactive) [ 2015-01-05 ]

That issue was created because I was not able to identify the MDEV task corresponding to http://askmonty.org/worklog/?tid=202 seen at https://mariadb.com/kb/en/progress-reporting/

Comment by Sachin Setiya (Inactive) [ 2017-01-23 ]

http://lists.askmonty.org/pipermail/commits/2017-January/010488.html

Comment by Sachin Setiya (Inactive) [ 2017-01-30 ]

Buildbot failure + some changes required in patch

Comment by Sachin Setiya (Inactive) [ 2019-05-28 ]

http://lists.askmonty.org/pipermail/commits/2019-May/013809.html

Comment by Sachin Setiya (Inactive) [ 2019-05-31 ]

Removed memory leak http://lists.askmonty.org/pipermail/commits/2019-May/013826.html

Comment by Andrei Elkin [ 2019-06-13 ]

Mailed my notes to suggest ansi-quoting and changes in the test part, specifically
replace simulations with the slave local trx as Rows_log_event applying blocker.

Comment by Sachin Setiya (Inactive) [ 2021-01-29 ]

Hi ralf.gebhardt@mariadb.com,

I just need to change the test cases. Then it should be okay to push.

Comment by Sachin Setiya (Inactive) [ 2021-02-23 ]

I am getting a memory leak , regarding set_db() , Currently debugging that.

Comment by Sachin Setiya (Inactive) [ 2021-02-23 ]

Review branch bb-10.6-sachin

Comment by Sujatha Sivakumar (Inactive) [ 2021-02-25 ]

Patch Looks fine.

Generated at Thu Feb 08 07:19:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.