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.

Sign up for GitHub

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

Jump to bottom

Add new table to reduce agent list query time #9058

Open
intr3p1d opened this issue Jul 20, 2022 · 0 comments · May be fixed by #9059
Open

Add new table to reduce agent list query time #9058

intr3p1d opened this issue Jul 20, 2022 · 0 comments · May be fixed by #9059
Assignees
@intr3p1d
Labels
module:collector module:web

Comments

@intr3p1d
Copy link
Contributor

Which module is your feature request related to?
web, collector

Is your feature request related to a problem?
Inside the pinpoint, we frequently get the list of the active agents.
Currently we make only a row of all agents list of the application.
If the number of (especially inactive) agents increase, query cost increases to check each agent status.

Describe the solution you'd like
To reduce such query time, Add new table with new form of rowkey : applicationName + timestamp (rounded).
The ultimate goal is to replace ApplicationIndex Table, but currently, leave the table and add new table with new logic.
@intr3p1d intr3p1d self-assigned this Jul 20, 2022
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Jul 20, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
26a3e37
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Jul 20, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
aa8656a
@intr3p1d intr3p1d linked a pull request Jul 20, 2022 that will close this issue
[#9058] Add new Table to reduce agent list query time #9059
Open
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Jul 20, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
a9a8fff
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Jul 25, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
bd06aa0
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 3, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
f6dacec
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 3, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
192213a
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 3, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
0555dc0
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 12, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
0113d9b
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 12, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
a47f99a
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 12, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
cd03ebe
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 12, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
2c5fc9d
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 24, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
b1e2c9c
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 24, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
7d0a446
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 24, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
6976de1
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Sep 19, 2022
@intr3p1d
[pinpoint-apm#9058] Cleanup
9f83b00
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Nov 1, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
d6a8532
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Nov 1, 2022
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
6205f42
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Jul 26, 2023
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
3c39e6d
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Jul 27, 2023
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
0d906bd
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 23, 2023
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
0c6cef7
intr3p1d added a commit to intr3p1d/pinpoint that referenced this issue Aug 23, 2023
@intr3p1d
[pinpoint-apm#9058] Add new Table to reduce agent list query time
e9117a1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@intr3p1d intr3p1d

Labels
module:collector module:web
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[#9058] Add new Table to reduce agent list query time intr3p1d/pinpoint
1 participant
@intr3p1d