The problem is that there are always requests with large samples that load the outgoing channel of the mysql server.

The log of slow queries does not give an exact picture. the server is not overloaded yet and is handling the load.

Is there a way to track large samples and log them?

  • You can check each sample, use EXPLAIN, dev.mysql.com/doc/refman/5.7/en/explain.html - Arsen
  • Is there a way to track large samples and log them? Enable General Log and log the requests themselves. It shows who performs what requests. By repeating them, you can roughly find out the sample size (you can wrap it in SELECT COUNT() , if you are only interested in the number of records). - Akina
  • the general query log does not give that informativity as in mysql-slow and it will have to run all requests by hand - le9i0nx

0