Timeline for How to monitor slow queries time on Mariadb
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 13, 2023 at 21:49 | history | edited | Gordan Bobić | CC BY-SA 4.0 |
Disclosure
|
| Sep 9, 2023 at 15:18 | comment | added | Gordan Bobić | If the workload of recording all queries becomes too great (10K+/second), yes. But until then, it is a good idea to get a clear view of all of the queries that hit the system. It is not uncommon to have queries that take less than 100ms to run that are further optimizable and consume 80% of server's expended CPU time. | |
| Sep 7, 2023 at 23:34 | comment | added | danblack |
long_query_time=0 seem a little on the short side. It can accept sub 1 second like =0.1 to represent 100ms.
|
|
| Jul 29, 2023 at 20:07 | history | answered | Gordan Bobić | CC BY-SA 4.0 |