Skip Navigation

[Resolved] Database Query Overloading CPU

This support ticket is created 5 years, 2 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 -
- 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 14:00 – 18:00 13:00 – 18:00 -

Supporter timezone: America/Jamaica (GMT-05:00)

Tagged: 

This topic contains 2 replies, has 2 voices.

Last updated by Shane 5 years, 2 months ago.

Assisted by: Shane.

Author
Posts
#1350359

I am trying to: Fix Site Speed Issue Current Setup has 16 GB RAM 50GB HD but CPU loads up to 99% because of Toolset

Link to a page where the issue can be seen: see private message

I expected to see: No Duplicate Database Queries or missing or slow queries

Instead, I got:

a very powerful server with badly coded plugins from toolset.

#1350365

2019/09/21 14:40:11 [error] 3549#0: *174445 FastCGI sent in stderr: "PHP
message: WordPress database error Table
'domain.wp_toolset_relationships' doesn't exist for query SELECT
relationships.id AS id,
relationships.slug AS slug,
relationships.display_name_plural AS
display_name_plural,
relationships.display_name_singular AS
display_name_singular,
relationships.driver AS driver,
relationships.parent_domain AS parent_domain,
relationships.child_domain AS child_domain,
relationships.intermediary_type AS
intermediary_type,
relationships.ownership AS ownership,
relationships.cardinality_parent_max AS
cardinality_parent_max,
relationships.cardinality_parent_min AS
cardinality_parent_min,
relationships.cardinality_child_max AS
cardinality_child_max,
relationships.cardinality_child_min AS
cardinality_child_min,
relationships.is_distinct AS is_distinct,
relationships.scope AS scope,
relationships.origin AS origin,
relationships.role_name_parent AS role_name_parent,
relationships.role_name_child AS role_name_child,
rel" while reading response header from upstream,
client: 46.229.168.144, server: devdo.domain.com, request: "GET
/cart/?_wpnonce=8efa358eb7&remove_item=34ed066df378efacc9b924ec161e7639
HTTP/1.1", upstream: "hidden link:", host: "
hidden link"

#1350539

Shane
Supporter

Languages: English (English )

Timezone: America/Jamaica (GMT-05:00)

Hi Paul,

Thank you for getting in touch.

Would you mind providing me with a copy of this site as this issue seems to be unique to your install.

To provide a copy of the site please follow the instructions in the link below.
https://toolset.com/faq/provide-supporters-copy-site/

This way I can check the site here locally to see exactly what is happening.

Thanks,
Shane