Titre du sujet : Re: Surcharge serveur par escrime-info sur 07/10/2013 11:02:16
Toujours non résolu avec la mise à jour du forum.
Le requêtes ont un peu changées, mais les problèmes restent :
# Time: 131004 7:39:56
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 9.236481 Lock_time: 0.000085 Rows_sent: 20 Rows_examined: 30720
use xxxxx;
SET timestamp=1380865196;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (21) AND p.approved = '1') ORDER BY p.post_id ASC LIMIT 15340, 20;
# Time: 131004 7:42:52
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 5.602597 Lock_time: 0.000141 Rows_sent: 20 Rows_examined: 2000
SET timestamp=1380865372;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE ((p.approved = '1') AND (p.forum_id IN (16,8,26,55,54,22,23,47,25,21,6,7,1,36,34,30,24,19,17,14,12,10,9,56,53,50,43,42,49,13,29,40,44,35,52,31,41,27,15,28,5,4,2,45,46)) AND (p.uid = '647')) ORDER BY p.post_time DESC LIMIT 280, 20;
# Time: 131004 7:44:05
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 14.596753 Lock_time: 0.000044 Rows_sent: 10 Rows_examined: 7550
SET timestamp=1380865445;
SELECT * FROM `xxxxx_planet_article` LIMIT 7540, 10;
# Time: 131004 8:05:50
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 5.300787 Lock_time: 0.000048 Rows_sent: 1 Rows_examined: 7040
use xxxxx;
SET timestamp=1380866750;
SELECT count(*), MAX(post_time) FROM xxxxx_bb_posts WHERE approved=1 AND uid =7433;
# Time: 131004 8:58:47
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 19.796785 Lock_time: 0.000246 Rows_sent: 20 Rows_examined: 33680
use xxxxx;
SET timestamp=1380869927;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (22) AND p.approved = '1') ORDER BY p.post_id DESC LIMIT 16820, 20;
# Time: 131004 8:59:15
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 63.969825 Lock_time: 0.000106 Rows_sent: 20 Rows_examined: 256160
SET timestamp=1380869955;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16) AND p.approved = '1') ORDER BY p.post_id DESC LIMIT 128060, 20;
# Time: 131004 9:08:40
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 8.836323 Lock_time: 0.000092 Rows_sent: 20 Rows_examined: 10480
use xxxxx;
SET timestamp=1380870520;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (13) AND p.approved = '1') ORDER BY p.post_id DESC LIMIT 5220, 20;
# Time: 131004 9:37:59
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 10.567838 Lock_time: 0.000107 Rows_sent: 20 Rows_examined: 263400
use xxxxx;
SET timestamp=1380872279;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16) AND p.approved = '1') ORDER BY p.post_id DESC LIMIT 131680, 20;
# Time: 131004 9:52:15
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 49.335924 Lock_time: 0.000071 Rows_sent: 20 Rows_examined: 256120
SET timestamp=1380873135;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16) AND p.approved = '1') ORDER BY p.post_id DESC LIMIT 128040, 20;
# Time: 131004 10:04:14
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 6.239671 Lock_time: 0.000106 Rows_sent: 20 Rows_examined: 30800
SET timestamp=1380873854;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (21) AND p.approved = '1') ORDER BY p.post_id ASC LIMIT 15380, 20;
# Time: 131004 10:06:48
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 10.749896 Lock_time: 0.000107 Rows_sent: 7 Rows_examined: 92614
SET timestamp=1380874008;
SELECT p.*, t.* FROM xxxxx_bb_posts p, xxxxx_bb_posts_text t WHERE p.topic_id=2193 AND p.post_id = t.post_id AND p.approved = 1 ORDER BY p.post_id ASC LIMIT 46300, 20;
# Time: 131004 10:26:49
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 5.465695 Lock_time: 0.000059 Rows_sent: 0 Rows_examined: 114
use xxxxx;
SET timestamp=1380875209;
SELECT DISTINCT topic_id FROM xxxxx_bb_posts WHERE attachment != '' AND topic_id IN (1374,7433,6048,1225,2987,1385,1389,1932,1004,12689,5,7588,2579,2951,1409,3566,167,1930,11318,13288);
# Time: 131004 10:34:50
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 19.910980 Lock_time: 0.000124 Rows_sent: 20 Rows_examined: 257660
SET timestamp=1380875690;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16) AND p.approved = '1') ORDER BY p.post_id DESC LIMIT 128810, 20;
# Time: 131004 10:43:25
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 6.248516 Lock_time: 0.000078 Rows_sent: 0 Rows_examined: 136
use xxxxx;
SET timestamp=1380876205;
SELECT DISTINCT topic_id FROM xxxxx_bb_posts WHERE attachment != '' AND topic_id IN (5568,282,2090,8322,864,441,1497,201,1386,6541,9814,7761,9090,4566,9222,4615,3292,5872,7212,2786);
# Time: 131004 11:34:34
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 13.068556 Lock_time: 0.000110 Rows_sent: 20 Rows_examined: 5360
use xxxxx;
SET timestamp=1380879274;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (7) AND p.approved = '1') ORDER BY p.post_id DESC LIMIT 2660, 20;
# Time: 131004 11:37:56
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 26.026366 Lock_time: 0.000145 Rows_sent: 9 Rows_examined: 672046
SET timestamp=1380879476;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE ((p.approved = '1') AND (p.forum_id IN (16,8,26,55,54,22,23,47,25,21,6,7,1,36,34,30,24,19,17,14,12,10,9,56,53,50,43,42,49,13,29,40,44,35,52,31,41,27,15,28,5,4,2,45,46)) AND ((p.subject LIKE '%dévelopement%' OR t.post_text LIKE '%dévelopement%'))) ORDER BY p.post_time DESC LIMIT 0, 20;
# Time: 131004 18:26:35
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 5.185827 Lock_time: 0.000074 Rows_sent: 1 Rows_examined: 68
use xxxxx;
SET timestamp=1380903995;
SELECT COUNT(*) FROM xxxxx_priv_msgs WHERE (read_msg = '0' AND to_userid = '5054');
# Time: 131004 20:01:10
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 7.372891 Lock_time: 0.000146 Rows_sent: 5 Rows_examined: 443284
use xxxxx;
SET timestamp=1380909670;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE ((p.approved = '1') AND (p.forum_id IN (16,8,26,55,54,22,23,47,25,21,6,7,1,36,34,30,24,19,17,14,12,10,9,56,53,50,43,42,49,13,29,40,44,35,52,31,41,27,15,28,5,4,2,45,46)) AND ((p.subject LIKE '%SEB%' OR t.post_text LIKE '%SEB%') AND (p.subject LIKE '%FOSS%' OR t.post_text LIKE '%FOSS%'))) ORDER BY p.post_time DESC LIMIT 0, 5;
/opt/mysql/bin/mysqld, Version: 5.5.27-log (MySQL Community Server (GPL)). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
# Time: 131004 21:31:20
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 6.168540 Lock_time: 0.000277 Rows_sent: 20 Rows_examined: 6120
use xxxxx;
SET timestamp=1380915080;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (14) AND p.approved = '1') ORDER BY p.post_id DESC LIMIT 3040, 20;
# Time: 131004 21:31:30
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 19.371076 Lock_time: 0.000138 Rows_sent: 20 Rows_examined: 262820
SET timestamp=1380915090;
SELECT p.*, t.* FROM xxxxx_bb_posts AS p LEFT JOIN xxxxx_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16) AND p.approved = '1') ORDER BY p.post_id DESC LIMIT 131390, 20;
En gros, il ne me reste qu'à supprimer quelques dizaines de milliers de posts ? Pas de solution miracle ?
|