All geek questions in one place

Max mysql queries per minute

How many requests does the follower process per minute?

In my case, I used delivery status, for example, "% questions%", and found that after an interval of 1 minute, about 5,000 queries were completed.

Is this normal behavior or can it improve?

+3
source share
2 answers

There are many interrelated factors that influence the answer to your questions. These include, but are not limited to,

  • Distributing requests to your subordinate
  • Time and types of updates coming through replication
  • Your data set
  • Your equipment
  • Used version of MySQL and used engines

, "5000 question " , - .

, , ; .

, question , SELECT s. , , "UPDATE s, DELETE s, SHOW STATUS, USE $db, SHOW TABLES" questions .

+1

, , 3090 , 185 . . - !

0

Source: https://habr.com/ru/post/1777898/

More articles:


All Articles