COMMUNITY FORUM

Mysql query

Start
Prev
1
Next
End

Charles
Topic Author
Offline
Senior Member

7 years 8 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
Offline
Platinum Member

7 years 8 months ago #163780 by Krikor Boghossian

Replied by Krikor Boghossian on topic Mysql query

Hello Charly,

Is caching enabled?

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

Charles
Topic Author
Offline
Senior Member

7 years 8 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
Offline
Platinum Member

7 years 8 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?

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

CJ web
Offline
New Member

6 years 11 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
Offline
Platinum Member

6 years 11 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?

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

CJ web
Offline
New Member

6 years 11 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.

Start
Prev
1
Next
End