Keyword

Mysql query

  • Charles
  • Charles's Avatar Topic Author
  • Offline
  • Senior Member
More
6 years 6 months ago #163753 by Charles
Mysql query was created by Charles
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.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
6 years 6 months ago #163780 by Krikor Boghossian
Replied by Krikor Boghossian on topic Mysql query
Hello Charly,

Is caching enabled?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Charles
  • Charles's Avatar Topic Author
  • Offline
  • Senior Member
More
6 years 6 months ago #163809 by Charles
Replied by Charles on 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.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
6 years 6 months ago #163819 by Krikor Boghossian
Replied by Krikor Boghossian on topic Mysql query
Not at all.
Caching always helps. I will need some context though, which event is triggering this query?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

More
5 years 9 months ago #168175 by CJ web
Replied by CJ web on 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.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
5 years 9 months ago #168183 by Krikor Boghossian
Replied by Krikor Boghossian on 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?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

More
5 years 9 months ago #168195 by CJ web
Replied by CJ web on 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.


Powered by Kunena Forum