# I see only one service in mysql table details

**URL:** https://forums.percona.com/t/i-see-only-one-service-in-mysql-table-details/22615
**Category:** PMM 2.x
**Created:** [June 7, 2023, 5:19am UTC](https://forums.percona.com/t/i-see-only-one-service-in-mysql-table-details/22615 "2023-06-07T05:19:06Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![shshwe2](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/shshwe2/32/10086_2.png) [@shshwe2](https://forums.percona.com/u/shshwe2)
#### Post date: [June 7, 2023, 5:19am UTC](https://forums.percona.com/t/i-see-only-one-service-in-mysql-table-details/22615/1 "2023-06-07T05:19:06Z")

</div>

hello.

Currently, a total of 23 services have been registered.

in Grafana  
If you go into MySQL-Overview, you can see a total of 23 related to Services.

however

MySQL-Table details shows only one Service.

Are there any additional settings that need to be set?

The service that only shows one service and the other services have the same environment and the same user rights registered in the DB.

---

<div class="post-metadata">

### Author: ![steve.hoffman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/steve.hoffman/32/66_2.png) [@steve.hoffman](https://forums.percona.com/u/steve.hoffman)
#### Post date: [June 7, 2023, 12:55pm UTC](https://forums.percona.com/t/i-see-only-one-service-in-mysql-table-details/22615/2 "2023-06-07T12:55:59Z")

</div>

Not sure what version of PMM you’re running but the first place I’d look is at inventory (gear icon towards bottom of nav menu) → Inventory. if you’re on a newer version of PMM you’ll see what services are registered and their status. See if there are any errors or services in a down state.

Most of the menus are populated from the victoriametrics database (which is where metrics are stored) as opposed to the postgres database (which is where registrations are stored)…so if you’re not seeing any details, it sounds to me like no metrics are coming in from the node or you are looking in a time range where some nodes/services had no data returned as the dropdowns are all generated by what’s found for a given time window.

---

<div class="post-metadata">

### Author: ![shshwe2](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/shshwe2/32/10086_2.png) [@shshwe2](https://forums.percona.com/u/shshwe2)
#### Post date: [June 8, 2023, 12:39am UTC](https://forums.percona.com/t/i-see-only-one-service-in-mysql-table-details/22615/3 "2023-06-08T00:39:28Z")

</div>

Thanks for the reply

But when I checked the inventory,

There are no errors in any part.

In fact, in the mysql entry, it comes out normally.

There is only 1 Service item in MySql-Table Details.

---

<div class="post-metadata">

### Author: ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)
#### Post date: [June 8, 2023, 8:37am UTC](https://forums.percona.com/t/i-see-only-one-service-in-mysql-table-details/22615/4 "2023-06-08T08:37:34Z")

</div>

@shshwe2, how many tables do you have in DB?  
PMM has a feature to automatically stop collecting Table-related metrics if the number of Tables is significant (100 by default, I think). This is why - if there is no Table collector enabled - there are no services in the mentioned dashboard.  
You can control the number of tables to disable Table collector by the `--disable-table-stats-limit=disable-tablestats-limit` flag from [our doc](https://docs.percona.com/percona-monitoring-and-management/details/commands/pmm-admin.html#mysql)

---

<div class="post-metadata">

### Author: ![shshwe2](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/shshwe2/32/10086_2.png) [@shshwe2](https://forums.percona.com/u/shshwe2)
#### Post date: [June 8, 2023, 8:45am UTC](https://forums.percona.com/t/i-see-only-one-service-in-mysql-table-details/22615/5 "2023-06-08T08:45:51Z")

</div>

Oh thank you, there are about 800 tables except for the DB that comes out.

so you didn’t come

thank you it’s solved
