# Percona not showing all Mysql services

**URL:** https://forums.percona.com/t/percona-not-showing-all-mysql-services/23184
**Category:** MySQL & MariaDB
**Tags:** mysql, percona
**Created:** [June 28, 2023, 2:26pm UTC](https://forums.percona.com/t/percona-not-showing-all-mysql-services/23184 "2023-06-28T14:26:55Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![adikovec](https://avatars.discourse-cdn.com/v4/letter/a/e79b87/32.png) [@adikovec](https://forums.percona.com/u/adikovec)
#### Post date: [June 28, 2023, 2:26pm UTC](https://forums.percona.com/t/percona-not-showing-all-mysql-services/23184/1 "2023-06-28T14:26:55Z")

</div>

Hello there,

We are facing a bit of a strange issue when trying Percona.

Some of the nodes (hosts) are not shown in all dashboards. (See images attached bellow)  
The service in overview - `count(mysql_global_status_uptime{service_name=~"$service_name"})`  
isn’t limited as far as I can see.

Does anyone have any suggestions of what could be wrong?

I am attaching a link with the images as new accounts can only submit 1 image per post:

[[Album] imgur.com ![](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/c27fd52f1894ef61b15372263546fd7dd486bcca.jpeg "imgur.com") ](https://imgur.com/a/2FLO9N8)

Thanks,

Adam

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [June 28, 2023, 3:05pm UTC](https://forums.percona.com/t/percona-not-showing-all-mysql-services/23184/2 "2023-06-28T15:05:52Z")

</div>

If there is no MySQL data, then the node won’t appear in the MySQL dashboard menus. Try changing your timeframe to 5m. Your terminal screenshot is chopped off so I can’t see which agents are running. Ensure that you’ve properly added the `mysql` agent to all mysql hosts.

---

<div class="post-metadata">

### Author: ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)
#### Post date: [June 28, 2023, 3:27pm UTC](https://forums.percona.com/t/percona-not-showing-all-mysql-services/23184/3 "2023-06-28T15:27:52Z")

</div>

Hi Adam,

Could you compare in Explore service names that provided by mysql\_up and mysql\_global\_status\_uptime metrics?

 ![Screenshot 2023-06-28 at 18.07.53](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/5/5aaa4b167daa4a5443599b6192838a212929a64a.png)

---

<div class="post-metadata">

### Author: ![adikovec](https://avatars.discourse-cdn.com/v4/letter/a/e79b87/32.png) [@adikovec](https://forums.percona.com/u/adikovec)
#### Post date: [June 29, 2023, 9:33am UTC](https://forums.percona.com/t/percona-not-showing-all-mysql-services/23184/4 "2023-06-29T09:33:25Z")

</div>

Hi Matt,

thank you for your prompt reply. Would this suffice?

```auto
Service type Service name Address and port Service ID
MySQL db01.beta.xxx 127.0.0.1:3306 /service_id/xxx                                                     

Agent type Status Metrics Mode Agent ID Service ID                                                      
pmm_agent Connected /agent_id/xxx                                                                        
node_exporter Running push /agent_id/xxx                                                                        
mysqld_exporter Running push /agent_id/xxx /service_id/xxxx               
mysql_slowlog_agent Running /agent_id/xxx /service_id/xxxx                
vmagent Running push /agent_id/xxx

```

```
                                                          `

```

I have made sure that they are running on other nodes, as can be seen on OS Disk details for example, I can see all the other mysql services from different environments/ locations and their metrics.

All the nodes but this db01.beta I am showing (where it is working) are running version

```auto
Version: 2.37.1
PMMVersion: 2.37.1

```

The workinig DB is running a 2 year old version

```auto
Version: 2.23.0
PMMVersion: 2.23.0
Timestamp: 2021-10-19 09:56:50 (UTC)

```

Could there be a compatibility issue? I am not super keen on updating it, because it is the only one that works completely 😃

For example

```auto
different beta server:

Service type Service name Address and port Service ID

Agent type Status Metrics Mode Agent ID Service ID Port
pmm_agent Connected /agent_id/xxx 0 
node_exporter Running push /agent_id/xxx 42000 
vmagent Running push /agent_id/xxx 42001

```

@Vadim_Yalovets I have made these two metrics and put them side by side, they also show the same:  
For the timeframe, it does not matter what I choose, the data stays the same.

 ![mysql_upVS_global_status_uptime](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/9/9cac50a60ae4cccf74a9e9a260636d2eb6da4eb2.png)

Thank you for your time,  
Adam

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [June 29, 2023, 2:13pm UTC](https://forums.percona.com/t/percona-not-showing-all-mysql-services/23184/5 "2023-06-29T14:13:33Z")

</div>

Notice how “different beta server:” does not have mysql agent running? You need to fix that.

---

<div class="post-metadata">

### Author: ![adikovec](https://avatars.discourse-cdn.com/v4/letter/a/e79b87/32.png) [@adikovec](https://forums.percona.com/u/adikovec)
#### Post date: [July 4, 2023, 12:21pm UTC](https://forums.percona.com/t/percona-not-showing-all-mysql-services/23184/6 "2023-07-04T12:21:33Z")

</div>

Hi Matthew,

thanks a lot. No idea how I missed that…

Solved 🙂 !