Support will be in summer mood from 6-17 August, 2018 while the JoomlaWorks folks get some rest.
Keyword

Mysql query

  • Durand
  • Durand's Avatar Topic Author
  • Offline
  • Junior Member
More
11 months 2 weeks ago #163753 by Durand
Durand created the topic: Mysql query
Hello,

I have a lot of mysql query and the server logs out because it loads 100%.
More details about my setup :

Joomla : 3.7.5
Php : 7
K2 : 2.7.8
K2 item : More than 10 000

Here the query :
| 100127 | procrea3_pdyqm       | localhost       | procrea3_pdyqm     | Sleep   | 20   |                      |                                                                                                      | 0.000    |
| 100170 | procrea3_pdyqm       | localhost       | procrea3_pdyqm     | Sleep   | 20   |                      |                                                                                                      | 0.000    |
| 100220 | procrea3_pdyqm       | localhost       | procrea3_pdyqm     | Sleep   | 15   |                      |                                                                                                      | 0.000    |
| 100261 | procrea3_pdyqm       | localhost       | procrea3_pdyqm     | Sleep   | 13   |                      |                                                                                                      | 0.000    |
| 100266 | procrea3_pdyqm       | localhost       | procrea3_pdyqm     | Sleep   | 11   |                      |                                                                                                      | 0.000    |
| 100288 | procrea3_pdyqm       | localhost       | procrea3_pdyqm     | Query   | 13   | Copying to tmp table | SELECT DISTINCT i.`id`,i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.p | 0.000    |
| 100291 | procrea3_pdyqm       | localhost       | procrea3_pdyqm     | Query   | 13   | Copying to tmp table | SELECT DISTINCT i.`id`,i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.p | 0.000    |
| 100292 | procrea3_pdyqm       | localhost       | procrea3_pdyqm     | Query   | 13   | Copying to tmp table | SELECT DISTINCT i.`id`,i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.p | 0.000    |

Thank's in advance for you're help.
Regards,
Charly

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

More
11 months 2 weeks ago #163780 by Krikor Boghossian
Krikor Boghossian replied the topic: Mysql query
Hello Charly,

Is caching enabled?

IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

---
JoomlaWorks
www.joomlaworks.net/

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

  • Durand
  • Durand's Avatar Topic Author
  • Offline
  • Junior Member
More
11 months 2 weeks ago #163809 by Durand
Durand replied the topic: Mysql query
Hello, thank's for reply.

Yes the cache file and the cache page plugin are enabled.
PHP opcache is enabled too.

It's a problem ?

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

More
11 months 2 weeks ago #163819 by Krikor Boghossian
Krikor Boghossian replied the topic: Mysql query
Not at all.
Caching always helps. I will need some context though, which event is triggering this query?

IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

---
JoomlaWorks
www.joomlaworks.net/

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

More
2 months 1 week ago #168175 by CJ web
CJ web replied the topic: Mysql query
i have this issue too
i have to always restart my dedicated because of overload
a little help please

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

More
2 months 1 week ago #168183 by Krikor Boghossian
Krikor Boghossian replied the topic: Mysql query
Is that exact query is it another query?
This is most likely and admin filter? Can you verify this behaviour or is it another case?

IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

---
JoomlaWorks
www.joomlaworks.net/

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

More
2 months 1 week ago #168195 by CJ web
CJ web replied the topic: Mysql query
i have post my issue here:
www.joomlaworks.net/forum/k2-en/49402-overload-site-query
i dont know if it admin filter
i see that is most likely the same case

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

Moderators: william white