URGENT ! – slow MySQL queries ….. Provider shut down site…

Hi, Folks… !

1st happy new year to all WP fans. Unluckily I got this morning the notice from my provider Siteground that the IT admin shut down my site https://www.india-meets-classic.net last night (one hour before year’s end ?? ) …

At Siteground I run two WP blog systems (one with WP version 2.8.6 (database: mysql_wrdp3) and 2nd with WP version 2.9.2 (database: mysql_wrdp4 )) on a linux system (Kernel version: 2.6.28.5-grsec-sg2).

The program versions installed there (not by me, all done by the provider) are:

Apache: 1.3.41
Curl: 7.15.5
MySQL 5.0.90
PostgreSQL 8.3.3
Python: 2.4.3
ImageMagic: 6.4.3
Perl:5.8.8
PHP:5.2.5
ionCube Loader:3.1.31
Zend Optimizer:3.3.3
phpMyAdmin 3.2.4
OpenSSL: 0.9.8e-fips-rhel5

The installation of my WordPress was done by Siteground system (via CPanel -> Fantastico DeLuxe).

Since days my provider tells me, that I generate too much activities… and that there exist a “server resources abuse“. That means, I overstretch the server processors.

Very strange, as I only have maximum 150-300 visitors daily (regularly much less). And in average per hour on both WP systems 4-5 postings (mirrored via Facebook Fanpage + Twitter Tweet/Re-Tweet).

I did a complete protocol check and followed all instructions, given by my provider Siteground: https://kb.siteground.com/article/How_to_optimize_WordPress_for_better_performance.html

… installed the cache plugin, optimized both wordPress databases with WP-DBManager… got no error report.

So all tables should be optimized. Same I deactivated RSS Feed plugin which created the biggest ‘automated activites’ (This one: https://feedwordpress.radgeek.com/ ).

PLEASE HELP ME AS I DO NOT GET ORIENTATION FROM MY PROVIDER. Siteground gave me the log protocols about my two databases and tells me that I have to check on my own. WHAT TO DO ?

1st LOG of last week: WP Database No. 3 – WP version 2.8.6
———————————-
Executed 7 min ago for 3 sec on Database –> mysql_wrdp3.
SELECT ID FROM wp_posts WHERE to_ping <> ” AND post_status = ‘publish

Executed 6 min ago for 2 sec on Database –> mysql_wrdp3.
SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationships.object_id AND post_status = ‘publish’ AND post_type = ‘post’ AND term_taxonomy_id = 10

Executed 4 min ago for 2 sec on Database –> mysql_wrdp3.
SELECT id, guid, post_modified_gmt FROM wp_posts WHERE guid=’https://www.residentadvisor.net/feed-item.aspx?id=19724

2nd LOG of last week: WP Database No. 4 – WP version 2.9.2
———————————–
Executed 7 min ago for 7 sec on Database –> mysql_wrdp4.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_posts.ID NOT IN (16235) AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (‘1’, ‘114’, ‘111’, ‘109’, ’81’, ’92’, ‘108’, ’50’, ’93’, ’53’, ‘100’, ’85’, ‘116’, ’69’, ’26’, ’32’, ‘107’, ’20’, ’27’, ’59’, ‘104’, ’44’, ’77’, ’90’, ’76’) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 4

Executed 7 min ago for 2 sec on Database –> mysql_wrdp4.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_posts.ID NOT IN (16230) AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (‘1’, ‘114’, ‘111’, ‘109’, ’81’, ’92’, ‘108’, ’50’, ’93’, ’53’, ‘100’, ’85’, ‘116’, ’69’, ’26’, ’32’, ‘107’, ’20’, ’27’, ’59’, ‘104’, ’44’, ’77’, ’90’, ’76’) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 4

Executed 4 min ago for 2 sec on Database –> mysql_wrdp4.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_posts.ID NOT IN (15086) AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (‘1’, ‘114’, ‘111’, ‘109’, ’81’, ’92’, ‘108’, ’50’, ’93’, ’53’, ‘100’, ’85’, ‘116’, ’69’, ’26’, ’32’, ‘107’, ’20’, ’27’, ’59’, ‘104’, ’44’, ’77’, ’90’, ’76’) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 4

Executed 2 min ago for 2 sec on Database –> mysql_wrdp4.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_posts.ID NOT IN (8791) AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (‘1’, ‘114’, ‘111’, ‘109’, ’81’, ’92’, ‘108’, ’50’, ’93’, ’53’, ‘100’, ’85’, ‘116’, ’69’, ’26’, ’32’, ‘107’, ’20’, ’27’, ’59’, ‘104’, ’44’, ’77’, ’90’, ’76’) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 4

Executed 1 min ago for 2 sec on Database –> mysql_wrdp4.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_posts.ID NOT IN (16246) AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (‘1’, ‘114’, ‘111’, ‘109’, ’81’, ’92’, ‘108’, ’50’, ’93’, ’53’, ‘100’, ’85’, ‘116’, ’69’, ’26’, ’32’, ‘107’, ’20’, ’27’, ’59’, ‘104’, ’44’, ’77’, ’90’, ’76’) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 4

3nd LOG of Yesterday: WP Database No. 4 – WP version 2.9.2
———————————–

SLOW QUERIES WERE FOUND:

Executed 290 min ago for 2 sec on Database –> mysql_wrdp4.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_posts.ID NOT IN (13641) AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (‘1’, ‘114’, ‘111’, ‘109’, ’81’, ’92’, ‘108’, ’50’, ’93’, ’53’, ‘100’, ’85’, ‘116’, ’69’, ’26’, ’32’, ‘107’, ’20’, ’27’, ’59’, ‘104’, ’44’, ’77’, ’90’, ’76’) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 4

Executed 284 min ago for 2 sec on Database –> mysql_wrdp4.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) INNER JOIN wp_terms ON (wp_term_taxonomy.term_id = wp_terms.term_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = ‘post_tag’ AND wp_terms.slug IN (‘imc-news-feed’) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 840, 40

Executed 129 min ago for 2 sec on Database –> mysql_wrdp4.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_posts.ID NOT IN (16596) AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (‘1’, ‘114’, ‘111’, ‘109’, ’81’, ’92’, ‘108’, ’50’, ’93’, ’53’, ‘100’, ’85’, ‘116’, ’69’, ’26’, ’32’, ‘107’, ’20’, ’27’, ’59’, ‘104’, ’44’, ’77’, ’90’, ’76’) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 4

Executed 57 min ago for 2 sec on Database –> mysql_wrdp4.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) INNER JOIN wp_terms ON (wp_term_taxonomy.term_id = wp_terms.term_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = ‘post_tag’ AND wp_terms.slug IN (‘imc-news-feed’) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 4360, 40
——————————————-

FROM WHERE COME THESE PROBLEMS AS MENTIONED BY MY PROVIDER ? – WHAT TO DO ! ANY IDEA ?

Please help me asap…. tks in advance. Wish you all a Happy NEw Year of peace, prosperity and health.