I found the system variable log_throttle_queries_not_using_indexes could not limit the the number of sql wirting in slowlog file. I have tried 2 release 8.0.32 and the latest image 8.0.36-28, both of them have same issue. but mysql community edition works with this system variable.
I provide following test case to reproduce the issue: 1: pull images from docker hub:
2: run image
3: login to docker to access db:
4: login to mysql
5: change parameter for slowlog:
6: mark down the location of slowlog file:
7: setup test table:
– wait about 30 seconds to generate records. – Then exit db and tail slowlog, and just mark down. /var/lib/mysql/xxxx-slow.log exit:
8: open another terminal to login docker and db;
9: run serval times sql below:
we can see this sql keep rolling in the slowlog tailing in the other terminal. The mysql community edition works as expected : after run 4 times of the sql. the slowlog stop rolling and 1 min later it came out :
Upstream Docker image & command rest steps would be similar to those above.
so please help to check whether it is a bug or any other setting we need to fix? Thanks a lot.
Environment
None
Activity
Show:
Aaditya Dubey April 18, 2024 at 9:35 AM
Hi
Verified as described!
Thank you for connecting with Percona!
Aaditya Dubey April 12, 2024 at 8:55 AM
Hi
Thank you for the report. I observed similar behaviour in upstream MySQL as well. I’ll check again and get back to you.
Medium
I found the system variable log_throttle_queries_not_using_indexes could not limit the the number of sql wirting in slowlog file.
I have tried 2 release 8.0.32 and the latest image 8.0.36-28, both of them have same issue.
but mysql community edition works with this system variable.
I provide following test case to reproduce the issue:
1: pull images from docker hub:
2: run image
3: login to docker to access db:
4: login to mysql
5: change parameter for slowlog:
6: mark down the location of slowlog file:
7: setup test table:
– wait about 30 seconds to generate records.
– Then exit db and tail slowlog, and just mark down. /var/lib/mysql/xxxx-slow.log
exit:
8: open another terminal to login docker and db;
9: run serval times sql below:
we can see this sql keep rolling in the slowlog tailing in the other terminal.
The mysql community edition works as expected : after run 4 times of the sql. the slowlog stop rolling and 1 min later it came out :
Upstream Docker image & command rest steps would be similar to those above.
so please help to check whether it is a bug or any other setting we need to fix? Thanks a lot.