[MDEV-7409] On RBR, extend the PROCESSLIST info to include at least the name of the recently used table - Jira

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Fix Version/s: 10.6.0
Component/s: Replication
Labels:
None

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

Attachments

Issue Links

duplicates

MDEV-4557 Make status more visible in RBR

Closed

Activity

Ascending order - Click to sort in descending order

Stoykov (Inactive) created issue - 2015-01-05 14:44

Stoykov (Inactive) added a comment - 2015-01-05 14:45 - edited

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/

Stoykov (Inactive) added a comment - 2015-01-05 14:45 - edited 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/

Stoykov (Inactive) made changes - 2015-01-05 16:13

Field	Original Value	New Value
Description	When RBR is used, add the db.table name to the "SHOW FULL PROCESSLIST" command output. there is similar MySQL request filled here : http://bugs.mysql.com/bug.php?id=62019	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

Elena Stepanova made changes - 2015-01-08 01:56

Affects Version/s	10.0.15 [ 17300 ]
Environment	Red Hat Enterprise Linux 6
Issue Type	Bug [ 1 ]	Task [ 3 ]

Sergei Golubchik made changes - 2015-01-28 17:18

Summary

On RBR, extentend the PROCESSLIST info to include at least the name of the recently used table

On RBR, extend the PROCESSLIST info to include at least the name of the recently used table

Sergei Golubchik made changes - 2015-01-28 17:18

Component/s		Replication [ 10100 ]
Component/s	OTHER [ 10125 ]
Component/s	Storage Engine - InnoDB [ 10129 ]

Daniel Black made changes - 2015-04-06 11:26

Link

This issue duplicates ~~MDEV-4557~~ [ ~~MDEV-4557~~ ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 59110 ]

MariaDB v3 [ 65256 ]

Sachin Setiya (Inactive) made changes - 2016-12-30 07:29

Assignee

Sachin Setiya [ sachin.setiya.007 ]

Rasmus Johansson (Inactive) made changes - 2017-01-11 08:24

Fix Version/s

10.0 [ 16000 ]

Rasmus Johansson (Inactive) made changes - 2017-01-11 08:25

Sprint

10.1.21 [ 130 ]

Rasmus Johansson (Inactive) made changes - 2017-01-11 08:25

Rank

Ranked lower

Sachin Setiya (Inactive) made changes - 2017-01-23 16:33

Status

Open [ 1 ]

In Progress [ 3 ]

Sachin Setiya (Inactive) made changes - 2017-01-23 17:36

Fix Version/s		10.1.22 [ 22502 ]
Fix Version/s	10.0 [ 16000 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Sachin Setiya (Inactive) added a comment - 2017-01-23 17:36 - edited

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

Sachin Setiya (Inactive) added a comment - 2017-01-23 17:36 - edited http://lists.askmonty.org/pipermail/commits/2017-January/010488.html

Sachin Setiya (Inactive) added a comment - 2017-01-30 11:37

Buildbot failure + some changes required in patch

Sachin Setiya (Inactive) added a comment - 2017-01-30 11:37 Buildbot failure + some changes required in patch

Sachin Setiya (Inactive) made changes - 2017-01-30 11:37

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Sergei Golubchik made changes - 2017-03-13 19:46

Fix Version/s		10.1 [ 16100 ]
Fix Version/s	10.1.22 [ 22502 ]

Rasmus Johansson (Inactive) made changes - 2017-05-18 12:08

Sprint

10.1.21 [ 130 ]

10.1.21, 10.1.24 [ 130, 161 ]

Sachin Setiya (Inactive) made changes - 2018-07-20 14:18

Fix Version/s		10.4 [ 22408 ]
Fix Version/s	10.1 [ 16100 ]

Sachin Setiya (Inactive) added a comment - 2019-05-28 08:15

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

Sachin Setiya (Inactive) added a comment - 2019-05-28 08:15 http://lists.askmonty.org/pipermail/commits/2019-May/013809.html

Sachin Setiya (Inactive) made changes - 2019-05-28 08:15

Assignee	Sachin Setiya [ sachin.setiya.007 ]	Andrei Elkin [ elkin ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Sachin Setiya (Inactive) added a comment - 2019-05-31 06:35

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

Sachin Setiya (Inactive) added a comment - 2019-05-31 06:35 Removed memory leak http://lists.askmonty.org/pipermail/commits/2019-May/013826.html

Andrei Elkin added a comment - 2019-06-13 20:36

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.

Andrei Elkin added a comment - 2019-06-13 20:36 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.

Andrei Elkin made changes - 2019-06-13 20:36

Assignee	Andrei Elkin [ elkin ]	Sachin Setiya [ sachin.setiya.007 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Ralf Gebhardt made changes - 2021-01-28 11:31

Fix Version/s		10.6 [ 24028 ]
Fix Version/s	10.4 [ 22408 ]

Sachin Setiya (Inactive) added a comment - 2021-01-29 10:47

Hi ralf.gebhardt@mariadb.com,

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

Sachin Setiya (Inactive) added a comment - 2021-01-29 10:47 Hi ralf.gebhardt@mariadb.com , I just need to change the test cases. Then it should be okay to push.

Sachin Setiya (Inactive) added a comment - 2021-02-23 12:49

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

Sachin Setiya (Inactive) added a comment - 2021-02-23 12:49 I am getting a memory leak , regarding set_db() , Currently debugging that.

Sachin Setiya (Inactive) added a comment - 2021-02-23 14:26

Review branch bb-10.6-sachin

Sachin Setiya (Inactive) added a comment - 2021-02-23 14:26 Review branch bb-10.6-sachin

Sujatha Sivakumar (Inactive) made changes - 2021-02-24 06:07

Assignee

Sachin Setiya [ sachin.setiya.007 ]

Sujatha Sivakumar [ sujatha.sivakumar ]

Sujatha Sivakumar (Inactive) made changes - 2021-02-24 06:07

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Sujatha Sivakumar (Inactive) added a comment - 2021-02-25 13:49

Patch Looks fine.

Sujatha Sivakumar (Inactive) added a comment - 2021-02-25 13:49 Patch Looks fine.

Sujatha Sivakumar (Inactive) made changes - 2021-02-25 13:50

Assignee

Sujatha Sivakumar [ sujatha.sivakumar ]

Sachin Setiya [ sachin.setiya.007 ]

Sachin Setiya (Inactive) made changes - 2021-02-28 11:41

Fix Version/s		10.6.0 [ 24431 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:22

Workflow

MariaDB v3 [ 65256 ]

MariaDB v4 [ 132500 ]

People

Assignee:: Sachin Setiya (Inactive)

Reporter:: Stoykov (Inactive)

Votes:: 2 Vote for this issue

Watchers:: 11 Start watching this issue

Dates

Created:: 2015-01-05 14:44

Updated:: 2023-08-01 02:33

Resolved:: 2021-02-28 11:41

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration