# No data in MySQL Table Details
**URL:** https://forums.percona.com/t/no-data-in-mysql-table-details/21687
**Category:** PMM 2.x
**Created:** [April 26, 2023, 2:57pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687 "2023-04-26T14:57:56Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@ultrapain](https://forums.percona.com/u/ultrapain)
#### Post date: [April 26, 2023, 2:57pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/1 "2023-04-26T14:57:56Z")
Hi all,
I’m running PMM 2.32.0 in a docker container. I’m currently monitoring two Percona 5.7 DBs. I perform the following navigation in PMM:
On the left, I hover over MySQL and click on “Table details”
All of the graphs say “No data”. I’ve followed the documentation for setup, and I see tons of data on other screens. Is there something specific to be done to enable data to populate this screen? Perhaps that I overlooked? Any help would be greatly appreciated.
Please note, per the documentation, I am using the Slow Query Log configuration, as opposed to using the Performance Schema ([MySQL - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/mysql.html#choose-and-configure-a-source)).
Thanks!
---
### Author:  [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)
#### Post date: [April 26, 2023, 3:33pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/2 "2023-04-26T15:33:01Z")
Hi @ultrapain welcome back to the Percona forums!
I suspect you do not have `performance_schema` set up in order to expose this information. Can you refer to the `setup_consumers` table and verify you have the following consumers enabled:
```auto
mysql> select * from setup_consumers where ENABLED = 'YES';
+---------------------------+---------+
| NAME | ENABLED |
+---------------------------+---------+
| events_statements_current | YES |
| events_statements_history | YES |
| global_instrumentation | YES |
| thread_instrumentation | YES |
| statements_digest | YES |
+---------------------------+---------+
5 rows in set (0.00 sec)
```
---
### Author:  [@ultrapain](https://forums.percona.com/u/ultrapain)
#### Post date: [April 26, 2023, 4:18pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/3 "2023-04-26T16:18:09Z")
Thanks for the quick reply!
Per the documentation, I am using the Slow Query Logs as my source, versus using the Performance Schema. Does that mean that the data I’m looking for won’t be available with this setup?
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [April 26, 2023, 4:48pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/4 "2023-04-26T16:48:14Z")
Hello @ultrapain,
The information on table size, free space, etc, comes from the information-schema. Does the MySQL PMM user have access to this schema?
---
### Author:  [@ultrapain](https://forums.percona.com/u/ultrapain)
#### Post date: [April 26, 2023, 5:16pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/5 "2023-04-26T17:16:56Z")
That user has the following perms:
select, reload, process, replication client on _._
Regarding the setup\_consumers table, the results of that select statement against my PMM client DB matches that of yours.
This is my first time setting up PMM, so I admit that I know next to nothing about this, but I wanted to restate that I followed the guidelines for setting up the client to use the Slow Query Log, since that is what is recommended for my version of Percona. Specifically, I performed the following steps:
Enable the following in my.cnf:
slow\_query\_log=ON
log\_output=FILE
long\_query\_time=0
log\_slow\_admin\_statements=ON
log\_slow\_slave\_statements=ON
log\_slow\_rate\_limit=100
log\_slow\_rate\_type=‘query’
slow\_query\_log\_always\_write\_time=1
log\_slow\_verbosity=‘full’
slow\_query\_log\_use\_global\_control=‘all’
I restarted the DB after adding the above parms to my.cnf. Anything you see that I may have missed?
---
### Author:  [@ultrapain](https://forums.percona.com/u/ultrapain)
#### Post date: [April 26, 2023, 6:00pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/6 "2023-04-26T18:00:50Z")
I just updated the configuration to use the Performance Schema by performing the following actions:
I commented out the following items in /etc/my.cnf:
slow\_query\_log=ON
log\_output=FILE
long\_query\_time=0
log\_slow\_admin\_statements=ON
log\_slow\_slave\_statements=ON
log\_slow\_rate\_limit=100
log\_slow\_rate\_type=‘query’
slow\_query\_log\_always\_write\_time=1
log\_slow\_verbosity=‘full’
slow\_query\_log\_use\_global\_control=‘all’
Added the following to /etc/my.cnf:
performance\_schema=ON
performance-schema-instrument=‘statement/%=ON’
performance-schema-consumer-statements-digest=ON
innodb\_monitor\_enable=all
query\_response\_time\_stats=ON
userstat=ON
Ran the following against the DB:
INSTALL PLUGIN QUERY\_RESPONSE\_TIME\_AUDIT SONAME ‘query\_response\_time.so’;
INSTALL PLUGIN QUERY\_RESPONSE\_TIME SONAME ‘query\_response\_time.so’;
INSTALL PLUGIN QUERY\_RESPONSE\_TIME\_READ SONAME ‘query\_response\_time.so’;
INSTALL PLUGIN QUERY\_RESPONSE\_TIME\_WRITE SONAME ‘query\_response\_time.so’;
Restarted the DB, and I still do not see any table data.
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [April 26, 2023, 7:11pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/7 "2023-04-26T19:11:55Z")
Can you provide the exact command you used to add this MySQL server to PMM?
---
### Author:  [@ultrapain](https://forums.percona.com/u/ultrapain)
#### Post date: [April 27, 2023, 6:15pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/8 "2023-04-27T18:15:15Z")
I added the node via the GUI. However, I recalled seeing a “use performance schema” checkbox, which I hadn’t previously checked (because I wasn’t using that). I couldn’t figure out a way to update the existing node to use the performance schema, so I removed and re-added it. It’s our testing region/DB, so I currently am using slow query log and performance schema because I am not concerned with performance hits in our test system. However, I’m still not seeing any table metrics.
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [April 27, 2023, 6:59pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/9 "2023-04-27T18:59:17Z")
You should have added the MySQL servers via command-line. That would have enabled tablestats by default. IIRC, in the GUI, you have to enable table stats. It should have been an option near the very end. Also, you should use slow query log for analytics as the information is better than what is available in perf schema. Remove both nodes, ssh to both nodes, add them via pmm-admin (see docs) and you’ll be fine.
---
### Author:  [@ultrapain](https://forums.percona.com/u/ultrapain)
#### Post date: [May 1, 2023, 5:04pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/10 "2023-05-01T17:04:15Z")
@matthewb thanks for your help/guidance. Indeed, adding via the command line was the way to go. The documentation states to choose one or the other (perf schema or slow query), and that using both may incur a performance hit. Should I disregard that/not worry about it?
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [May 1, 2023, 5:22pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/11 "2023-05-01T17:22:52Z")
I wouldn’t worry about it. Perf schema is enabled by default and slow log can be changed if you ever reach 10,000+ connections.
---
### Author:  [@ultrapain](https://forums.percona.com/u/ultrapain)
#### Post date: [May 1, 2023, 5:24pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/12 "2023-05-01T17:24:40Z")
Again, much thanks for the guidance and information - much appreciated!!!
---
### Author:  [@LTjikana](https://forums.percona.com/u/LTjikana)
#### Post date: [February 15, 2024, 7:56am UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/13 "2024-02-15T07:56:24Z")
Hi @mathewb apologies to just jump on this thread like this but im also experiencing the same however I used the --disable-tablestats-limit argument when adding the nodes with the following results:
pmm-admin add mysql --username=pmm --password=PXXX\_\_ dbhostname\_3321 127.0.0.1:3321 --query-source=perfschema --disable-tablestats-limit=3000
MySQL Service added.
Service ID : /service\_id/982b6b7a-7f01-45b8-b4bc-ff4fb6fd7936
Service name: dbhostname\_3321
Table statistics collection enabled (the limit is 3000, the actual table count is 2892).
I still however do not see any data on the table details tab/page
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [February 15, 2024, 3:19pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/14 "2024-02-15T15:19:40Z")
@LTjikana Check the error logs on that server. Make sure there are no permissions issues.
---
### Author:  [@LTjikana](https://forums.percona.com/u/LTjikana)
#### Post date: [February 16, 2024, 6:01am UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/15 "2024-02-16T06:01:17Z")
Hi Mathew,
luckily don’t rotate error logs so No Errors in my DB error log…
unless if there is another error log associated to the pmm-client I can check?
Thanks in advance!
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [February 16, 2024, 3:47pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/16 "2024-02-16T15:47:59Z")
There are PMM-specific error logs. I think you can get them from journalctl
---
### Author:  [@LTjikana](https://forums.percona.com/u/LTjikana)
#### Post date: [February 19, 2024, 10:14am UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/17 "2024-02-19T10:14:59Z")
Hi Mathew,
thanks for the information, do you mind sharing the exact command to get the logs for the pam-specific error logs?
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [February 19, 2024, 5:08pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/18 "2024-02-19T17:08:10Z")
`sudo journalctl -xe` and look for PMM messages. Use `grep` to filter.
---
### Author:  [@LTjikana](https://forums.percona.com/u/LTjikana)
#### Post date: [February 20, 2024, 9:33am UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/19 "2024-02-20T09:33:49Z")
Hi Mathew,
See attached logs from my Pam server, I think that’s the best place to get the logs since none of my 168 monitored hosts shows table details.
please let me know if you see anything amiss there.
[pmm-server-logs.txt](https://forums.percona.com/uploads/short-url/pXpW18vEv7lQtksPeNc8n4dPA0u.txt) (101.8 KB)
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [February 20, 2024, 2:24pm UTC](https://forums.percona.com/t/no-data-in-mysql-table-details/21687/20 "2024-02-20T14:24:19Z")
Hello @LTjikana,
Unfortunately, no, the PMM server is not the best place for this. You need to look at the agent logs on one of the servers since it is the agents themselves that collect the data.
[Next page](https://forums.percona.com/t/no-data-in-mysql-table-details/21687.md?page=2)