Annulleret

Many slow MySQL queries towards my database

Hello,

A system Siteground administrator have informed me that are many slow MySQL queries towards my database, which is causing a high server resource consumption. Below he have pasted the latest queries:

Executed 19 min ago for 3 sec on Database --> .

SELECT [url removed, login to view] FROM wp_posts INNER JOIN wp_term_relationships ON ([url removed, login to view] = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS tt1 ON ([url removed, login to view] = tt1.object_id) INNER JOIN wp_postmeta ON ([url removed, login to view] = wp_postmeta.post_id) WHERE 1=1 AND [url removed, login to view] NOT IN (18830) AND ( wp_term_relationships.term_taxonomy_id IN (3690) OR tt1.term_taxonomy_id IN (7490,7491,7492,7493) ) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) AND ( (wp_postmeta.meta_key = 'visibility' AND CAST(wp_postmeta.meta_value AS CHAR) IN ('catalog','visible')) ) GROUP BY [url removed, login to view] ORDER BY RAND() DESC LIMIT 0, 5

Executed 19 min ago for 2 sec on Database --> .

SELECT [url removed, login to view] FROM wp_posts INNER JOIN wp_term_relationships ON ([url removed, login to view] = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS tt1 ON ([url removed, login to view] = tt1.object_id) INNER JOIN wp_postmeta ON ([url removed, login to view] = wp_postmeta.post_id) WHERE 1=1 AND [url removed, login to view] NOT IN (18830) AND ( wp_term_relationships.term_taxonomy_id IN (3690) OR tt1.term_taxonomy_id IN (7490,7491,7492,7493) ) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) AND ( (wp_postmeta.meta_key = 'visibility' AND CAST(wp_postmeta.meta_value AS CHAR) IN ('catalog','visible')) ) GROUP BY [url removed, login to view] ORDER BY RAND() DESC LIMIT 0, 5

Executed 19 min ago for 1 sec on Database --> .

SELECT [url removed, login to view] FROM wp_posts INNER JOIN wp_term_relationships ON ([url removed, login to view] = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS tt1 ON ([url removed, login to view] = tt1.object_id) INNER JOIN wp_postmeta ON ([url removed, login to view] = wp_postmeta.post_id) WHERE 1=1 AND [url removed, login to view] NOT IN (18830) AND ( wp_term_relationships.term_taxonomy_id IN (3690) OR tt1.term_taxonomy_id IN (7490,7491,7492,7493) ) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) AND ( (wp_postmeta.meta_key = 'visibility' AND CAST(wp_postmeta.meta_value AS CHAR) IN ('catalog','visible')) ) GROUP BY [url removed, login to view] ORDER BY RAND() DESC LIMIT 0, 5

He asked me to consult with a developer and ask him to optimize the database for my WordPress as he should be able to perform that procedure and resolve the problem. Mi site is located at [url removed, login to view]

King regards,

Riccardo Favullo

Færdigheder: MySQL

Se mere: wordpress mysql database developer, wordpress slow, queries, optimize mysql, mysql database administrator, database consult, wordpress server slow, mysql database catalog, wordpress slow queries, slow queries, product catalog net, queries wordpress, wordpress catalog system, resource limit problem wordpress, mysql slow queries, database procedure, mysql slow, wordpress resource limit, slow mysql queries wordpress, wordpress king, slow server, wordpress product database, wordpress catalog product, optimize wordpress queries, zencart mysql slow queries

Om arbejdsgiveren:
( 0 bedømmelser ) Italy

Projekt-ID: #6055443

1 freelancer is bidding on average €2 for this job

rinsadsl

Hired by the Employer

€2 EUR / hour
(190 bedømmelser)
7.0