Keyword

High Query Time

  • Muhammad Abbas
  • Muhammad Abbas's Avatar Topic Author
  • Offline
  • New Member
More
1 month 1 day ago #172960 by Muhammad Abbas
Muhammad Abbas created the topic: High Query Time
Hi,
I'm using a dedicated server for a single website with joomla and K2 component as primary content component and a module named "News Show Pro GK5", My website is News/blog based website with more than 200k items.
Server specification Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz 10 of Cores, 20 of Threads Ram: 60GB SSD:250 (OS and i think DB) HDD: 2TB
PHP 7.3
MySQL 5.7
Website load time is very slow and i optimized page but the server response time is very slow, after inspection i enabled slow query log and i found bellow query which is repeated in slow query log file and Query_time is vary from 2 second to 8 second ... how can i optimize or solve this issue?
<pre>
Query_time:4.012262 Lock_time:0.000219 Rows_sent:28 Rows_examined:191584 SELECT i.*, c.name as categoryname,c.id as categoryid,c.alias as categoryalias, c.params as categoryparams FROM y_k2_items as i RIGHT JOIN y_k2_categories AS c ON c.id =i.catid WHERE i.published =1 AND i.access IN(1,1) AND i.trash =0 AND c.published =1 AND c.access IN(1,1) AND c.trash =0 AND( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-08-21 09:07:45' ) AND ( i.publish_down ='0000-00-00 00:00:00' OR i.publish_down >='2019-08-21 09:07:45' ) AND c.id IN (100,1,3,So on) ORDER BY i.id DESC LIMIT 0, 28; </pre>

Thanks

Please Log in or Create an account to join the conversation.

  • Fotis
  • Fotis's Avatar
  • Offline
  • Administrator
  • JoomlaWorks Support Team
More
1 month 4 hours ago #172969 by Fotis
Fotis replied the topic: High Query Time
Which K2 version are you using?

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Please Log in or Create an account to join the conversation.

  • Muhammad Abbas
  • Muhammad Abbas's Avatar Topic Author
  • Offline
  • New Member
More
1 month 31 minutes ago #172975 by Muhammad Abbas
Muhammad Abbas replied the topic: High Query Time
k2: V2.9.0
Joomla 3.9.11 Release

Please Log in or Create an account to join the conversation.

  • Fotis
  • Fotis's Avatar
  • Offline
  • Administrator
  • JoomlaWorks Support Team
More
4 weeks 2 days ago #172981 by Fotis
Fotis replied the topic: High Query Time
Try v2.10 (dev) from github.com/getk2/k2/archive/master.zip and check once more.

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Please Log in or Create an account to join the conversation.

  • Muhammad Abbas
  • Muhammad Abbas's Avatar Topic Author
  • Offline
  • New Member
More
3 weeks 6 days ago #172994 by Muhammad Abbas
Muhammad Abbas replied the topic: High Query Time
thanks for response.

Before install i have 2 question:
1- is that k2 version stable for live website?
2- the mentioned query genetrating from k2 or mentioned module?

Please Log in or Create an account to join the conversation.

  • Muhammad Abbas
  • Muhammad Abbas's Avatar Topic Author
  • Offline
  • New Member
More
3 weeks 5 days ago #173002 by Muhammad Abbas
Muhammad Abbas replied the topic: High Query Time
Before install i have 2 question:
1- is that k2 version stable for live website?
2- the mentioned query genetrating from k2 or mentioned module?

Please Log in or Create an account to join the conversation.

  • Fotis
  • Fotis's Avatar
  • Offline
  • Administrator
  • JoomlaWorks Support Team
More
3 weeks 3 days ago #173012 by Fotis
Fotis replied the topic: High Query Time
1. Yes.
2. It's the module. And this module is known to NOT be performant. If you can swap it with K2 Content, your load will drop. Additionally, make sure no dynamic image resizing is enabled in that Gavick module.

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

Please Log in or Create an account to join the conversation.

Moderators: william white

Powered by Kunena Forum