Trop de requêtes = coupure du blog (Créer un compte)

Y a pas un admin, un modo, enfin un spécialiste pour m’aider?? J’y crois pas!!

Merci beaucoup.

Merci.
Voici ce que je viens encore de recevoir:
rdb272:~# zgrep dbo199290758 /var/log/anna.log*
/var/log/anna.log:dbo199290758@infong480: 101 Queries: 11 Selects, 6
Upd, 6 Del, 124 Connects
/var/log/anna.log.0:dbo199290758@infong480: 16061 Queries: 15566
Selects, 36 Upd, 364 Connects
/var/log/anna.log.1.gz:dbo199290758@infong480: 14363 Queries: 13809
Selects, 30 Upd, 450 Connects
/var/log/anna.log.2.gz:dbo199290758@infong480: 15159 Queries: 14636
Selects, 28 Upd, 438 Connects
/var/log/anna.log.3.gz:dbo199290758@infong480: 18395 Queries: 17298
Selects, 82 Ins, 342 Upd, 23 Del, 571 Connects
/var/log/anna.log.4.gz:dbo199290758@infong480: 20299 Queries: 19781
Selects, 35 Upd, 459 Connects
/var/log/anna.log.5.gz:*** dbo199290758@infong480: 30494 Queries: 29549
Selects, 42 Upd, 575 Connects
/var/log/anna.log.6.gz:dbo199290758@infong480: 24344 Queries: 23753
Selects, 25 Upd, 483 Connects

rdb272:~# myslowana /db/logs/mysql.slowlog.?.gz -e ‘user dbo199290758’
-s | head -20
user count query_time lock_time rows_sent rows_examined
dbo199290758 31 206[16](6.65) 25[5](0.81) 1233[741](39.77)
13494[2456](435.29)
dbo199290758 4 SET timestamp=%%; SELECT * , IF (DATE_ADD(link_updated,
INTERVAL %% MINUTE) >= NOW(), %%,0) as recently_updated ,
UNIX_TIMESTAMP(link_updated) AS link_updated_f FROM wp_links INNER JOIN
wp_term_relationships AS tr ON (wp_links.link_id = %%) INNER JOIN
wp_term_taxonomy as tt ON tt.term_taxonomy_id = %% WHERE %%=1 AND
link_visible = %% AND ( tt.term_id = %% ) AND taxonomy = %% ORDER BY
link_name ASC;
dbo199290758 3 SELECT post_id, meta_key, meta_value FROM wp_postmeta
WHERE post_id IN %%;
dbo199290758 3 SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE
%%=1 AND wp_posts.ID NOT IN %% ) AND wp_posts.post_type = %% AND
(wp_posts.post_status = %%) LIMIT %%;
dbo199290758 2 SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE
%%=1 AND wp_posts.post_type = %% AND (wp_posts.post_status = %%) LIMIT
%%;
dbo199290758 2 SELECT t.name AS name, t.term_id AS term_id, tt.count AS
count FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt
ON (tr.term_taxonomy_id = %%) INNER JOIN wp_terms AS t ON (tt.term_id =
%%) WHERE tt.taxonomy = %% AND ( tr.object_id IN %% ) GROUP BY t.term_id
ORDER BY tt.count DESC;
dbo199290758 2 SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER
JOIN wp_term_taxonomy AS tt ON tt.term_id = %% INNER JOIN
wp_term_relationships AS tr ON tr.term_taxonomy_id = %% WHERE
tt.taxonomy IN %% AND tr.object_id IN %% ORDER BY t.name ASC;
dbo199290758 2 SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER
JOIN wp_term_relationships ON (wp_posts.ID = %%) INNER JOIN
wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = %%) INNER
JOIN wp_terms ON (wp_term_taxonomy.term_id = %%) WHERE %%=1 AND
wp_term_taxonomy.taxonomy = %% AND wp_terms.slug IN %% AND
wp_posts.post_type IN %% AND (wp_posts.post_status = %%) GROUP BY
wp_posts.ID LIMIT %%;
dbo199290758 1 SELECT DISTINCT post_author, COUNT(ID) AS count FROM
wp_posts WHERE post_type = %% AND (post_status = %%) GROUP BY
post_author;
dbo199290758 1 SHOW TABLE STATUS;
dbo199290758 1 SHOW TABLE STATUS FROM `db199290758`;
dbo199290758 1 SELECT DISTINCT
ID,post_title,post_date,MATCH(post_title,post_content) AGAINST %% AS
score FROM wp_posts WHERE MATCH (post_title,post_content) AGAINST %% AND
post_date <= %% AND post_status = %% AND id != %% AND post_type = %%
ORDER BY score DESC;
dbo199290758 1 SELECT option_name, option_value FROM wp_options WHERE
autoload = %%;
dbo199290758 1 SELECT DISTINCT post_author, COUNT(ID) AS count FROM
wp_posts WHERE post_type = %% AND (post_status = %% OR post_status = %%)
GROUP BY post_author;
dbo199290758 1 SELECT COUNT(*) as comments FROM wp_comments WHERE
comment_author=%%;
dbo199290758 1 SELECT COUNT(%%) as comments FROM wp_comments WHERE
comment_author_email=%%;
dbo199290758 1 SELECT p.* FROM wp_posts AS p WHERE p.post_date > %% AND
p.post_type = %% AND p.post_status = %% LIMIT %%;
dbo199290758 1 SHOW TABLE STATUS FROM db199290758;
dbo199290758 1 SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN
wp_term_taxonomy AS tt ON t.term_id = %% WHERE tt.taxonomy = %% AND
t.slug = %% LIMIT %%;

J’ai supprimé pas mal de plugin, mes requêtes ont diminué de moitié, mais 1and1 me gonfle encore.
Merci de ton aide.

Alors suite de l’épisode coupure sauvage par 1and1:
j’ai reçu deux mails coup sur coup après le rétablissement de la base mysql. Ces deux mails me disaient la même chose : votre base consomme trop de requêtes, etc.. J’avais réussi à diminuer les requêtes de moitié, pourtant.
Et la je me suis faché : je leur ai dit d’arrêter de me prendre pour un con, que mon blog ne consommait pas tant que ça, qu’en plus j’avais diminué le nb de requêtes de moitié (preuve à l’appui avec la liste de celles-ci) et je leur ai demandé les codes et id pour transférer ailleurs.
Et bin, vous me croirez ou pas, mais j’ai plus de problèmes!! Enfin jusqu’à la prochaine fois, bien sur.
Je pense qu’ils tapent un peu au hasard histoire de montrer que c’est eux les chefs.
Enfin cela m’a permis aussi de mettre en place une sauvegarde auto de ma base MySql.

Merci à vous pour vos aides.