Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature Request]: add show active txn statement #11321

Closed
1 task done
daviszhen opened this issue Aug 19, 2023 · 6 comments
Closed
1 task done

[Feature Request]: add show active txn statement #11321

daviszhen opened this issue Aug 19, 2023 · 6 comments
Assignees
Labels
attention/doc-influence need to complete design document kind/feature priority/p-1 source/dev issues from devs
Milestone

Comments

@daviszhen
Copy link
Contributor

Is there an existing issue for the same feature request?

  • I have checked the existing issues.

Is your feature request related to a problem?

#10948

Describe the feature you'd like

show active txn list all active txns and their stats like user transaction, internal or task, status (blocked by lock, blocked by queue, etc).

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

No response

Additional information

suggested by @fengttt , merge the show active txn into the main.

@daviszhen
Copy link
Contributor Author

  • active txns (txnclient.mu.activeTxns)
  • user transaction, internal, or task.
  • status (blocked by lock(can not be provided not), blocked by queue(waitActiveTxns), etc).

get all txns on all cns:

  • rpc to call other cn to get all info

@daviszhen
Copy link
Contributor Author

daviszhen commented Aug 19, 2023

draft syntax

show transactions [all] [filter user/not_user/blockedbyqueue/] [order by start_time [desc|asc],...]

all 所有cn;
没有时,当前cn; 

draft result content

columns:
txnId
status
user
start_time ?
duration ?
cn ?

@sukki37 sukki37 changed the title [Feature Request]: add show ative txn statement [Feature Request]: add show active txn statement Aug 22, 2023
@sukki37 sukki37 added the source/dev issues from devs label Aug 27, 2023
@lacrimosaprinz lacrimosaprinz added the attention/doc-influence need to complete design document label Aug 29, 2023
@daviszhen
Copy link
Contributor Author

关联 #11499

@daviszhen
Copy link
Contributor Author

关联 #11707

@daviszhen
Copy link
Contributor Author

关联 #11836

@daviszhen
Copy link
Contributor Author

加好了。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
attention/doc-influence need to complete design document kind/feature priority/p-1 source/dev issues from devs
Projects
None yet
Development

No branches or pull requests

3 participants