Skip to content

[receiver/mysql] INFORMATION_SCHEMA TABLES table metrics #32693

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
Closed
s-v-a-n opened this issue Apr 25, 2024 · 1 comment
Closed

[receiver/mysql] INFORMATION_SCHEMA TABLES table metrics #32693

s-v-a-n opened this issue Apr 25, 2024 · 1 comment
Assignees
@s-v-a-n
Labels
enhancement New feature or request receiver/mysql

Comments

@s-v-a-n
Copy link
Contributor

s-v-a-n commented Apr 25, 2024 •
edited
Loading

Component(s)

receiver/mysql

Is your feature request related to a problem? Please describe.

Hoping to collect MySQL table metrics such as the number of rows, average row length and table size.

Describe the solution you'd like

Add support for the following metrics: TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH, INDEX_LENGTH and TABLE_LENGTH as the sum of DATA_LENGTH and INDEX_LENGTH.

Describe alternatives you've considered

No response

Additional context

No response
@s-v-a-n s-v-a-n added enhancement New feature or request needs triage New item requiring triage labels Apr 25, 2024
@github-actions GitHub Actions
Copy link
Contributor

Pinging code owners:

%s See Adding Labels via Comments if you do not have permissions to add labels yourself.

@s-v-a-n s-v-a-n mentioned this issue Apr 25, 2024
Merged
@djaglowski djaglowski removed the needs triage New item requiring triage label May 2, 2024
djaglowski pushed a commit that referenced this issue May 20, 2024
@s-v-a-n
[receiver/mysql] feat: add table size metrics (#32680)
7ddb350 
**Description:** This adds table size metrics using the
INFORMATION_SCHEMA TABLES table:
https://dev.mysql.com/doc/refman/8.3/en/information-schema-tables-table.html.
Specifically, we are adding the columns:

`TABLE_ROWS`, `AVG_ROW_LENGTH`, `DATA_LENGTH`, `INDEX_LENGTH`

Link to tracking issue:
#32693

**Testing:** Added testing data, tested locally against MySQL 8.
 
**Documentation:** By default, the metric is turned off. When enabled,
make sure that the MySQL user has access to the tables being monitored.
@s-v-a-n s-v-a-n closed this as completed May 20, 2024
@heaje heaje mentioned this issue May 28, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@s-v-a-n s-v-a-n

Labels
enhancement New feature or request receiver/mysql
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@djaglowski @s-v-a-n