ECSHOP运行HM的MYSQL数据超限

freegreen

客服让我查日志：

Lock_time: 0.581488 Rows_sent: 11  Rows_examined: 6217
use cfqqcomc_jjman;
SELECT DISTINCT SUM(goods_number) AS num FROM `cfqqcomc_jjman`.`ecs_order_info` AS o, `cfqqcomc_jjman`.`ecs_order_goods` AS g WHERE o.order_id = g.order_id AND o.order_status = '1' AND o.shipping_status  IN ('1','2')  AND o.pay_status  IN ('2','1')  AND o.add_time > '1253300720' GROUP BY g.goods_id HAVING num > 5

# Thu Mar 18 21:05:23 2010
# Query_time: 2.535898  Lock_time: 0.382558 Rows_sent: 0  Rows_examined: 10
use cfqqcomc_jjman;
SELECT id, number, type FROM `cfqqcomc_jjman`.`ecs_template` WHERE filename = 'goods' AND type > 0 AND remarks ='' AND theme='002'

# Thu Mar 18 21:05:25 2010
# Query_time: 1.791256  Lock_time: 0.184949 Rows_sent: 3  Rows_examined: 3
use cfqqcomc_jjman;
DESC `cfqqcomc_jjman`.`ecs_searchengine`

# Thu Mar 18 21:05:26 2010
# Query_time: 3.989016  Lock_time: 1.678569 Rows_sent: 9  Rows_examined: 27
use cfqqcomc_jjman;
SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, IFNULL(mp.user_price, g.shop_price * '') AS shop_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img, RAND() AS rnd FROM `cfqqcomc_jjman`.`ecs_goods` AS g LEFT JOIN `cfqqcomc_jjman`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = ''  WHERE g.goods_id  IN ('2429','3269','4744','3776','4102','4854','4490','4588','4658')  ORDER BY rnd DESC

# Thu Mar 18 21:05:26 2010
# Query_time: 2.237508  Lock_time: 0.507452 Rows_sent: 0  Rows_examined: 0
use cfqqcomc_jjman;
UPDATE `cfqqcomc_jjman`.`ecs_goods` SET click_count = click_count + 1 WHERE goods_id = '3554'

# Thu Mar 18 21:05:30 2010
# Query_time: 1.623442  Lock_time: 0.575419 Rows_sent: 3  Rows_examined: 3
use cfqqcomc_jjman;
DESC `cfqqcomc_jjman`.`ecs_searchengine`

# Thu Mar 18 21:05:33 2010
# Query_time: 1.602624  Lock_time: 0.000080 Rows_sent: 1  Rows_examined: 0
use cfqqcomc_jjman;
SELECT SUM(goods_number) AS number, SUM(goods_price * goods_number) AS amount FROM `cfqqcomc_jjman`.`ecs_cart` WHERE session_id = 'da44981f94f98f28947daaac499fa5a7' AND rec_type = '0'

# Thu Mar 18 21:05:33 2010
# Query_time: 2.004155  Lock_time: 0.310150 Rows_sent: 1  Rows_examined: 0
use cfqqcomc_jjman;
SELECT COUNT(*) FROM `cfqqcomc_jjman`.`ecs_sessions`

# Thu Mar 18 21:05:49 2010
# Query_time: 1.365178  Lock_time: 0.050346 Rows_sent: 10  Rows_examined: 10
use cfqqcomc_jjman;
SELECT library, number FROM `cfqqcomc_jjman`.`ecs_template` WHERE theme = '002' AND filename = 'category' AND remarks=''

# Thu Mar 18 21:06:46 2010
# Query_time: 1.166403  Lock_time: 0.014889 Rows_sent: 3  Rows_examined: 3
use cfqqcomc_jjman;
DESC `cfqqcomc_jjman`.`ecs_searchengine`

# Thu Mar 18 21:06:46 2010
# Query_time: 1.120069  Lock_time: 0.000187 Rows_sent: 15  Rows_examined: 7468
use cfqqcomc_jjman;
SELECT g.goods_id, g.goods_name, g.goods_img, g.goods_thumb, g.shop_price, g.promote_price, SUM(og.goods_number) as goods_number FROM `cfqqcomc_jjman`.`ecs_goods` AS g, `cfqqcomc_jjman`.`ecs_order_info` AS o, `cfqqcomc_jjman`.`ecs_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0  AND o.order_sn >= '20090920'  AND g.goods_number > 0  AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND o.order_status = '1' AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 15

# Thu Mar 18 21:06:48 2010
# Query_time: 1.475723  Lock_time: 0.267341 Rows_sent: 2  Rows_examined: 142
use cfqqcomc_jjman;
SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag FROM `cfqqcomc_jjman`.`ecs_brand`AS b, `cfqqcomc_jjman`.`ecs_goods` AS g WHERE g.brand_id = b.brand_id  AND g.cat_id  IN ('17')  AND is_show = 1  AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC

# Thu Mar 18 21:15:16 2010
# Query_time: 1.141065  Lock_time: 0.000180 Rows_sent: 6  Rows_examined: 137
use cfqqcomc_jjman;
SELECT COUNT(b.goods_id ) AS num, g.goods_id, g.goods_name, g.goods_thumb, g.goods_img, g.shop_price, g.promote_price, g.promote_start_date, g.promote_end_date FROM `cfqqcomc_jjman`.`ecs_order_goods` AS a LEFT JOIN `cfqqcomc_jjman`.`ecs_order_goods` AS b ON b.order_id = a.order_id LEFT JOIN `cfqqcomc_jjman`.`ecs_goods` AS g ON g.goods_id = b.goods_id WHERE a.goods_id = '3373' AND b.goods_id <> '3373' AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.goods_id ORDER BY num DESC LIMIT 6

# Thu Mar 18 21:18:36 2010
# Query_time: 1.552151  Lock_time: 0.000066 Rows_sent: 0  Rows_examined: 0
use cfqqcomc_jjman;
INSERT INTO `cfqqcomc_jjman`.`ecs_searchengine` (date, searchengine, count) VALUES ('2010-03-19', 'Yahoo China', '1')ON DUPLICATE KEY UPDATE count = count + 1

# Thu Mar 18 21:20:26 2010
# Query_time: 4.487603  Lock_time: 1.391128 Rows_sent: 3  Rows_examined: 3
use cfqqcomc_jjman;
DESC `cfqqcomc_jjman`.`ecs_searchengine`

# Thu Mar 18 21:20:28 2010
# Query_time: 1.472861  Lock_time: 0.000222 Rows_sent: 15  Rows_examined: 7468
use cfqqcomc_jjman;
SELECT g.goods_id, g.goods_name, g.goods_img, g.goods_thumb, g.shop_price, g.promote_price, SUM(og.goods_number) as goods_number FROM `cfqqcomc_jjman`.`ecs_goods` AS g, `cfqqcomc_jjman`.`ecs_order_info` AS o, `cfqqcomc_jjman`.`ecs_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0  AND o.order_sn >= '20090920'  AND g.goods_number > 0  AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND o.order_status = '1' AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 15

# Thu Mar 18 21:22:43 2010
# Query_time: 1.301177  Lock_time: 0.168717 Rows_sent: 4  Rows_examined: 3492
use cfqqcomc_jjman;
SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag FROM `cfqqcomc_jjman`.`ecs_brand`AS b, `cfqqcomc_jjman`.`ecs_goods` AS g WHERE g.brand_id = b.brand_id  AND g.cat_id  IN ('62','86','70','68','98','156','162','76','103','41','163','154','165','166','155','158','164','46','67','168','169','160','161','167','159','170','171','44')  AND is_show = 1  AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC

# Thu Mar 18 21:23:00 2010
# Query_time: 2.322987  Lock_time: 0.000146 Rows_sent: 1  Rows_examined: 1
use cfqqcomc_jjman;
SELECT c.cat_id, c.cat_name, COUNT(g.goods_id) AS goods_num  FROM `cfqqcomc_jjman`.`ecs_goods` AS g  LEFT JOIN `cfqqcomc_jjman`.`ecs_category` AS c ON c.cat_id = g.cat_id  WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0  AND g.goods_id  IN ('4419')  GROUP BY g.cat_id

# Thu Mar 18 21:25:40 2010
# Query_time: 2.106841  Lock_time: 0.437456 Rows_sent: 0  Rows_examined: 0
use cfqqcomc_jjman;
SELECT act_id, act_name, act_type, start_time, end_time FROM `cfqqcomc_jjman`.`ecs_goods_activity` WHERE is_finished=0 AND start_time <= '1268940338' AND end_time >= '1268940338' AND goods_id = '3605'

# Thu Mar 18 21:25:49 2010
# Query_time: 6.479844  Lock_time: 3.288394 Rows_sent: 0  Rows_examined: 0
use cfqqcomc_jjman;
SELECT act_id, act_range, act_range_ext, act_name, start_time, end_time FROM `cfqqcomc_jjman`.`ecs_favourable_activity` WHERE start_time <= '1268940341' AND end_time >= '1268940341' AND CONCAT(',', user_rank, ',') LIKE '%,0,%'

提示全是这样的信息，看不懂，烦躁

一路同行

这是错误日志里显示的吗？这都是些sql语句
你网站具体情况是什么

freegreen

具体情况是，只要打开ECSHOP的网站，就会导致网站超级慢，而且看日志，涉及到了太多数据表操作

freegreen

是不是被攻击了，数据库操作怎么这么频繁

一路同行

这情况是最近才出现的吗？空间上有其他网站吗 正常吗？

freegreen

貌似出现两三天了，DECECMS的没有问题，

freegreen

以前用 独立服务器，就出现过MYSQL连接N多的情况

freegreen

2月份就有错误日志，现在是越来越多，越来越频繁，是不是跟 HM升级也有关系？

一路同行

你的网站访问量怎么样？

freegreen

2000IP+