# Only one service shows strange connect information

**URL:** <https://forums.percona.com/t/only-one-service-shows-strange-connect-information/22651>\
**Category:** PMM 2.x\
**Created:** [June 8, 2023, 5:40am UTC](https://forums.percona.com/t/only-one-service-shows-strange-connect-information/22651 "2023-06-08T05:40:38Z")\
**Posts on this page:** 4\
**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 8, 2023, 5:40am UTC](https://forums.percona.com/t/only-one-service-shows-strange-connect-information/22651/1 "2023-06-08T05:40:38Z")

</div>

hello.  
The number of thread connects is displayed strangely.

in mysql tool  
show global status like ‘%thread%’  
At Threads\_connected I get 363. I’ve never exceeded 1000.

Currently in Prometheus

avg by(service\_name) (max(max\_over\_time(mysql\_global\_status\_threads\_connected{service\_name=“$service\_name”}[$interval]) or  
max\_over\_time(mysql\_global\_status\_threads\_connected{service\_name=“$service\_name”}[5m])))

, the number of threads is more than 1000.

In the case of other servers, it is roughly similar (not correct), but the gap difference is too large for only one server.

Where should I look?

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [June 8, 2023, 6:30am UTC](https://forums.percona.com/t/only-one-service-shows-strange-connect-information/22651/2 "2023-06-08T06:30:37Z")

</div>

Hello @shshwe2,

So, what I think is, this is wrong comparison…

Documentation says: _Threads\_connected_. The number of currently open connections  
But the promql specified is showing you maximum value of threads\_connected over that interval.

Is this server that you’re talking about is a primary or high traffic compared to others?  
Can you also add output of:  
`show global variables like '%max%conn%';`  
`show global status like '%max%conn%';`  
`show global status like 'thread%';`

Thanks,  
Kedar.

---

<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, 7:59am UTC](https://forums.percona.com/t/only-one-service-shows-strange-connect-information/22651/3 "2023-06-08T07:59:12Z")

</div>

Thanks for the reply

show global variables like ‘%max%conn%’ is  
is set to 3000

show global status like ‘%max%conn%’ has value 1748.

Currently show global status like ‘thread%’ is about 403

I hit 1000 or more when there are conjoint players, but when it doesn’t, I keep it around 200-600.

However, the maximum average value of the range (from 15 minutes ago) exceeds 1000.

Other servers have a similar number of concurrent users as I thought,

Only one server is weird.

If you want to keep getting the maximum value during that period, do you have to modify promql?

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [June 8, 2023, 10:22am UTC](https://forums.percona.com/t/only-one-service-shows-strange-connect-information/22651/4 "2023-06-08T10:22:50Z")

</div>

I hope I understand your response to my queries correctly 🙂  
anyhow, I’d plot only `mysql_global_status_threads_connected{service_name=“$service_name”}` and compare it with current time.

Thanks,  
K