这一条MYSQL慢查询记录什么意思,求大神解答阿!

2016-07-07 15:14 来源:www.chinab4c.com 作者:ecshop专家

MYSQL慢查询日志里面老是有这一条记录,是啥意思阿,大侠帮帮忙看看,不甚感激阿!拜谢!!!

# User@Host: dbebuy_f[dbebuy_f] @ localhost [127.0.0.1]
# Query_time: 4294967294 Lock_time: 0 Rows_sent: 7 Rows_examined: 3312
SELECT b.brand_id, b.brand_name, COUNT(*) AS goods_num FROM `dbebuy`.`ecs_brand`AS b, `dbebuy`.`ecs_goods` AS g LEFT JOIN `dbebuy`.`ecs_goods_cat` AS gc ON g.goods_id = gc.goods_id WHERE g.brand_id = b.brand_id AND (g.cat_id IN ('237') OR gc.cat_id IN ('237') ) AND b.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 b.sort_order, b.brand_id ASC;

帮忙看看哦,谢啦!

回答:
看你慢查询日志怎么设置的
可以设置超过一定的时间就记录相应的sql
还有可以设置记录没有使用索引的记录

可以做为优化sql的参考

本身并不是错误提示,也可以关闭日志

看来必须对EC进行分表了。呵呵。