Annulleret

Ottimizzare mySQL 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, optimize mysql, mysql database administrator, database consult, database administrator, wordpress server slow, mysql database catalog, wordpress slow queries, slow queries, product catalog net, wordpress catalog system, resource limit problem wordpress, mysql slow queries, database procedure, mysql slow, wordpress resource limit, slow mysql queries wordpress, wordpress king, wordpress product database, wordpress catalog product, optimize wordpress queries, mysql administrator, product catalog wordpress, procedure mysql, mysql procedure

Om arbejdsgiveren:
( 0 bedømmelser ) Italy

Projekt-ID: #6055453

5 freelancere byder i gennemsnit €23 for dette job

LearningNew

A proposal has not yet been provided

€33 EUR på 1 dag
(8 bedømmelser)
5.7
bdsitech

A proposal has not yet been provided

€34 EUR på 1 dag
(30 bedømmelser)
4.7
salmansarwars

A proposal has not yet been provided

€23 EUR på 1 dag
(1 bedømmelse)
2.8
BigBang07

Give me a first chance on freelancer, i can optimize it in 1 night. I have 3 years experiences on php and mysql.

€15 EUR på 1 dag
(0 bedømmelser)
0.0
shallufreelancer

A proposal has not yet been provided

€11 EUR på 1 dag
(0 bedømmelser)
0.0