Manage cookies that are used for advertising, such as ad personalization, remarketing, and ad effectiveness analysis.
2.6.1.8. Slow queries
Attention!
The presence of slow queries can negatively affect the speed of the site. All slow queries should be optimized.Notes:
- Query execution time, beyond which the query is considered slow:
- Shared hosting — 5 seconds.
- Business hosting — from 0.5 to 10 seconds (set in MySQL settings).
- For each slow query, the total information is displayed. To get the average value, divide each value by the number of queries.
- For each database, a maximum of 100 recent slow queries from the last 30 days are stored.
- In the list of slow requests, the
%character instead of the IP address means that the slow request is executed in a procedure.
Databases with slow queries in the "Databases" section are marked with an exclamation mark icon and a notification is displayed in the menu for them.
To view the list of slow queries, click on the icon, "View list" or "Slow queries":
An example of a list of slow requests:
The ℹ️ button in the slow query line opens detailed information:
(11)