Bitix UP - How can you track heavy queries in the mysql database?

S

Sasha Odarchuk2016-09-12 22:24:11

MySQL

Sasha Odarchuk, 2016-09-12 22:24:11

Good afternoon!
What (preferably free) tool can track heavy queries in the mysql database. The site takes a long time to load when loading the ad list page. It is necessary to find out on what request time is spent. Site on Bitrix UP 14.xxxx.
I will be very grateful.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

N

Nikita, 2016-09-12
@Rema1ns

Well, in general, there is a debug mode in Bitrix, which shows the temporary statistics of the page / components. Shows how many requests this or that component executes, how many are in the cache, well, you can look at the requests themselves)

A

Andrey, 2016-09-13
@reaferon

HTTP://DOMAIN.RU/bitrix/admin/perfmon_sql_list.php?PAGEN_1=1&SIZEN_1=20〈=ru&by=QUERY_TIME&order=desc
Respectively, replace HTTP://DOMAIN.RU with your domain