MySQL Slow Query
The reports that allow you to optimise your site’s performance
MySQL Slow Query is a cPanel module developed by Artera’s technicians that will allow you to analyse and improve your site’s performance .
This module examines the system logs, normally visible only to the administrator, and generates a report of all the slowest queries recently performed by the site. Thanks to this data you can constantly monitor the status of the databases, intervene with optimizations or request our specialized advice.
What is MySQL Slow Query for?
The MySQL Slow Query module generates two reports: the first allows you to quickly view the individual executions of the slowest queries performed by your site and to analyse in detail the most significant parameters such as: execution time, the number of database rows examined, the number of rows effectively sent and the possible lock time that involved the database during the execution of the query.
The second report groups queries of the same type, showing: the number of executions recently carried out, the relative average execution and lock times, the average number of lines examined and sent.
The analysis of these reports will allow you to monitor the database status and improve overall site performance thanks to maintenance activities such as emptying some tables that are no longer useful or performing some simple optimizations such as the application of indices or reviewing the scripts involved in running the queries.
The module was developed starting from the analysis of the MySQL log files, normally visible only by the system administrator. In particular, in a first phase, the parameters for the generation of the slow query log were calibrated based on the experience of our technicians. Parameters that are constantly monitored and updated.
The module then takes care of dividing the information thus obtained based on the different shared hosting accounts cPanel and of showing each one their specific report. It is in this phase that the queries are normalised by eliminating the parameters to show the grouping of the same and average execution times in the final report.