# DB status question (queries per second)

**URL:** <https://forum.inductiveautomation.com/t/db-status-question-queries-per-second/54269>\
**Category:** Ignition\
**Created:** [December 18, 2021, 5:50am UTC](https://forum.inductiveautomation.com/t/db-status-question-queries-per-second/54269 "2021-12-18T05:50:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [December 18, 2021, 5:50am UTC](https://forum.inductiveautomation.com/t/db-status-question-queries-per-second/54269/1 "2021-12-18T05:50:48Z")

</div>

Hello all,

Simple question here, how can I have almost 300 queries per second, but no active query and no active connection?

I need to understand where does come from these 300+ queries per second.

Thanks.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/7/2724a7b1b0a51e057e394054c6249b1452542ad2.png)

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [December 18, 2021, 10:52am UTC](https://forum.inductiveautomation.com/t/db-status-question-queries-per-second/54269/2 "2021-12-18T10:52:07Z")

</div>

What Ignition version, and what flavour of SQL?

That’s normal enough, what you are seeing.

I just checked my R&D server. MySQL, and it is using 0/50 connections, no active queries, and 30qps.

The active queries only appear for queries that take a bit of time. Just to the right of where you’ve cropped your screenshot you will see a bar chart of longer queries. And just below, you will see longest recent queries.

I’m no DBA but I think a connection is only used via JDBC either from certain flavours of SQL or for certain tasks.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 18, 2021, 3:48pm UTC](https://forum.inductiveautomation.com/t/db-status-question-queries-per-second/54269/3 "2021-12-18T15:48:26Z")

</div>

Yup, at the instant checked, there was no connection in use, so no active query. If queries are executing in a fraction of a millisecond, the odds of the snapshot catching one of those 300 is slim. Assuming it updates every second, which it doesn’t. So the odds are slimmer. Most often, you need a query that runs for several seconds to always show up in that stat display.

---

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [December 20, 2021, 2:00pm UTC](https://forum.inductiveautomation.com/t/db-status-question-queries-per-second/54269/4 "2021-12-20T14:00:18Z")

</div>

Clear answer. Thank you guys!