Portada del sitio > Tareas > Analizar query lento
Analizar query lento
Lunes 21 de diciembre de 2015, por
Buenas, en el momento en que reportaron que el sitio estaba lento, lo único raro que encontré son unas queries que quedaron loggeadas y que llevaron varios segundos. No pude determinar todavía de qué manera se dispararon:
# Time: 161220 12:26:48
# User@Host: laizquierdadiari[laizquierdadiari] @ localhost []
# Query_time: 5.875098 Lock_time: 0.000103 Rows_sent: 0 Rows_examined: 0
SET timestamp=1482247608;
SELECT articles.lang, articles.titre
FROM <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZGlhcmlvX2l6cXVpZXJkYTwvY29kZT4="></span>.spip_articles AS <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+YXJ0aWNsZXM8L2NvZGU+"></span>
INNER JOIN <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZGlhcmlvX2l6cXVpZXJkYTwvY29kZT4="></span>.spip_mots_liens AS L1 ON ( L1.id_objet = articles.id_article AND L1.objet='article')
WHERE (articles.statut = 'publie')
AND (L1.id_mot = 69)
GROUP BY articles.id_article
LIMIT 0,1;
# User@Host: laizquierdadiari[laizquierdadiari] @ localhost []
# Query_time: 6.124617 Lock_time: 0.000105 Rows_sent: 0 Rows_examined: 638
SET timestamp=1482247608;
SELECT articles.popularite, articles.id_article, articles.titre, articles.lang
FROM <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZGlhcmlvX2l6cXVpZXJkYTwvY29kZT4="></span>.spip_articles AS <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+YXJ0aWNsZXM8L2NvZGU+"></span>
INNER JOIN <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZGlhcmlvX2l6cXVpZXJkYTwvY29kZT4="></span>.spip_mots_liens AS L2 ON ( L2.id_objet = articles.id_article AND L2.objet='article')
INNER JOIN <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZGlhcmlvX2l6cXVpZXJkYTwvY29kZT4="></span>.spip_mots_liens AS L1 ON ( L1.id_objet = articles.id_article AND L1.objet='article')
WHERE (articles.statut = 'publie')
AND ((L1.id_mot IN (213,706,4464,11334,11382)))
AND (L2.id_mot = 9016)
AND NOT((articles.id_article = 62506))
AND ((articles.id_rubrique NOT IN (1201,1714,2653,5441,5442,5443)))
AND ((articles.id_article NOT IN (39881,62513,62575)))
GROUP BY articles.id_article
ORDER BY articles.popularite DESC
LIMIT 0,2;
# User@Host: laizquierdadiari[laizquierdadiari] @ localhost []
# Query_time: 6.145711 Lock_time: 0.000083 Rows_sent: 3 Rows_examined: 5265
SET timestamp=1482247608;
SELECT articles.popularite, articles.id_article, articles.titre, articles.lang
FROM <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZGlhcmlvX2l6cXVpZXJkYTwvY29kZT4="></span>.spip_articles AS <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+YXJ0aWNsZXM8L2NvZGU+"></span>
INNER JOIN <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZGlhcmlvX2l6cXVpZXJkYTwvY29kZT4="></span>.spip_mots_liens AS L1 ON ( L1.id_objet = articles.id_article AND L1.objet='article')
WHERE (articles.statut = 'publie')
AND (L1.id_mot = 108)
AND NOT((articles.id_article = 62077))
AND ((articles.id_rubrique NOT IN (1201,1714,2653,5441,5442,5443)))
GROUP BY articles.id_article
ORDER BY articles.popularite DESC
LIMIT 0,3;