[Telemetry] Datapoints for MySQL
General
Escalation
General
Escalation
Description
How to test
Use this feature build for testing https://github.com/percona/pmm/pull/1215
How to document
None
Attachments
1
- 22 Sep 2022, 08:28 PM
is caused by
Smart Checklist
Activity
Show:
Ihor Cherkasov September 22, 2022 at 8:28 PM
Verified on FB – https://github.com/Percona-Lab/pmm-submodules/pull/2777#issuecomment-1254763622
Server Docker – perconalab/pmm-server-fb:PR-2777-db345a8
Client Tarball – https://s3.us-east-2.amazonaws.com/pmm-build-cache/PR-BUILDS/pmm2-client/pmm2-client-PR-2777-db345a8.tar.gz
Databases: Percona Server for MySQL 5.7, MySQL 8.0
Now I see following metrics in PMM ManageD logs:
mysql_global_variables_innodb_buffer_pool_size
mysql_global_status_threads_running
mysql_global_status_queries_running
mysql_innodb_space_used
Done
Created September 6, 2022 at 1:46 PM
Updated November 10, 2022 at 3:08 PM
Resolved November 9, 2022 at 8:11 AM
In scope of this ticket we have to implement next datapoints:
Basic MySQL Configuration. what is innodb_buffer_pool size?. Datapoint Name: mysql_global_variables_innodb_buffer_pool_size
Server Load. what is average threads_running during last day?. Datapoint Name: mysql_global_status_threads_running
Number queries per second during last day. Datapoint Name: mysql_global_status_queries_running
Data usage. How big is MySQL database under management? Datapoint Name: mysql_global_data_usage