Datadog - MySQL Table size not accurate

Hi everyone,
We’ve got MySQL metrics coming in just fine except for table size metrics. Anyone have any idea why this might be? No metrics available starting with*

Hi, I’ve seen from an old case that this can be caused by permission issues, but I’m not sure if that is the issue for you. Would you be able to reach out to us at the Datadog Support Platform and then send an agent flare, using the ticket ID as the <CASE_ID> in the flare command? This will allow us to inspect the agent’s logs and configurations for any potential clues.
Alternatively, you can also try running the status and check commands as specified here to see what issues might be reported:

Thank you I suspected permissions issues as well but was able to login with datadog MySQL user and run select commands on information_schema and get necessary table size stats.