[receiver/mysql] INFORMATION_SCHEMA TABLES table metrics

[s-v-a-n]

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

[github-actions]

Pinging code owners:

• receiver/mysql: @djaglowski

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