databases_size value in the json file created by the percona_telemetry is zero.

Description

  1. Setup the PXC using the build from branch release-8.0.39 with telemetry enabled.

  2. Connect to one of the PXC nodes and create the databases say sbtest.

  3. generate some sysbench load by executing command say,

  4. databases_size will still be 0 in the new json file (/usr/local/percona/telemetry/pxc/1730183471-394114b2-70ad-4eca-95a0-67c778ac0fa8.json) created by the telemetry component

 

Most probably the mysql.session user is missing the privilege to fetch the overall databases size.
Tested same scenario with branch 8.4.0-1 which doesn’t;t contain the related patch, hence uses root user, it works correctly and we can see the actual databases_size in generated json file.

Environment

None

Activity

Show:
Done

Details

Assignee

Reporter

Needs QA

No

Sprint

Priority

Smart Checklist

Created October 29, 2024 at 8:14 AM
Updated December 11, 2024 at 3:33 PM
Resolved November 27, 2024 at 9:12 AM