How Many Queries per Second is Too High?

Ignition
,
1

I have a MySQL Database that is averaging 97 queries per second.
What is considered too many?

2

When your database machine falls over. If it's keeping up (CPU and memory usage are reasonable) then the right number for queries/second is whatever your application needs.

3 Likes
3

Excellent. Thank you.

4

Ignition has a nice feature where you can see the slow logs under the database status. Optimizing your slow queries could mean less queries per second if you have a lot of queries stacking up. Just in case you ever notice you do go over the limit it’s not a bad place to start.

1 Like