How and by what it is possible to monitor and evaluate the work of the MySQL database, in particular, which SQL queries go most often and in what time they are executed?
Kromster
9,782 7 golden marks 31 silver badge 59 bronze marks
Nicolas Chabanovsky ♦ Nicolas Chabanovsky
38.1k 54 gold marks 222 silver marks 438 bronze marks
|
1 answer
You can track SQL queries in MySQL by turning on logging. To enable logging, start mysqld with the options --log[=имя_файла] or -l [имя_файла] . And already having a log, you can build statistics to estimate the time and frequency of various requests.
stanislav stanislav
29.5k 20 gold marks 74 silver marks 192 bronze marks
|