如何找到 joomla 的哪个部分正在减慢我的系统速度？

发布于 2024-12-10 19:14:08 字数 919 浏览 0 评论 0原文

我在 mysql 中有这个慢查询：

Count: 59  Time=14.19s (837s)  Lock=0.00s (0s)  Rows=1.5 (87), fmrh[fmrh]@localhost
  SELECT DISTINCT v.id
  FROM jos_custom_properties_fields AS f
  INNER JOIN jos_custom_properties_values as v
  LEFT JOIN jos_jf_content AS jfcf ON jfcf.reference_id = f.id
  LEFT JOIN jos_languages as jflf ON jfcf.language_id = jflf.id
  LEFT JOIN jos_jf_content AS jfcv ON jfcv.reference_id = v.id
  LEFT JOIN jos_languages as jflv ON jfcv.language_id = jflv.id
  WHERE f.access <= 'S'
  AND ( (jfcf.value = 'S' AND jflf.code = 'S')
  OR f.label = 'S'  )
  AND ( (jfcv.value = 'S' AND jflv.code = 'S')
  OR v.label = 'S' )

但我不知道它在 joomla 中的何处使用。它是一个单一主机，会降低只有 2 个用户的 4 核 VMachine 的速度。开发人员/集成商不再可用，我不知道我能做些什么来检测导致这种情况发生的 joomla 扩展。我认为这是 joomla-fish 但我不确定。

jfcf.value = 'S' 在 60Mb 表中的 MEDIUM TEXT 字段中进行搜索，我认为这不正确。

预先感谢您抽出时间。

维森特

原文

I've this slow query in mysql :

Count: 59  Time=14.19s (837s)  Lock=0.00s (0s)  Rows=1.5 (87), fmrh[fmrh]@localhost
  SELECT DISTINCT v.id
  FROM jos_custom_properties_fields AS f
  INNER JOIN jos_custom_properties_values as v
  LEFT JOIN jos_jf_content AS jfcf ON jfcf.reference_id = f.id
  LEFT JOIN jos_languages as jflf ON jfcf.language_id = jflf.id
  LEFT JOIN jos_jf_content AS jfcv ON jfcv.reference_id = v.id
  LEFT JOIN jos_languages as jflv ON jfcv.language_id = jflv.id
  WHERE f.access <= 'S'
  AND ( (jfcf.value = 'S' AND jflf.code = 'S')
  OR f.label = 'S'  )
  AND ( (jfcv.value = 'S' AND jflv.code = 'S')
  OR v.label = 'S' )

but I don't where in the joomla it's used.
It's a single hosting that slows down a 4 core VMachine whith only 2 users.
The developper/integrator is not available any more, and I don't know what I can do to detect the joomla-extension that is making this happen. I think it's joomla-fish but I'm not sure.

jfcf.value = 'S' makes a search among a MEDIUM TEXT field in a table with 60Mb, I think this is not wright.

Thank you in advance for your time.

Vicente

分享到QQ

分享到微博