数据库 经常卡死，谁会加索引？
User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 36.779912 Lock_time: 0.000080 Rows_sent: 1 Rows_examined: 3747
SET timestamp=1528795977;
SELECT COUNT(*) FROM `ims_mc_mapping_fans` WHERE uniacid = '320' and follow=1;
# Time: 180612 17:33:14
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 3.070489 Lock_time: 0.000084 Rows_sent: 1 Rows_examined: 373
SET timestamp=1528795994;
SELECT COUNT(*) FROM `ims_bsht_tbk_order` WHERE uniacid = '230' AND orderid!='';
# Time: 180612 17:33:59
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 10.730873 Lock_time: 0.380492 Rows_sent: 1 Rows_examined: 1516
SET timestamp=1528796039;
SELECT sum(xgyg) FROM `ims_tiger_newhu_tkorder` where weid='654' and orderzt<>'订单失效' and addtime>=1528732800 and ( tgwid=717046535 or tgwid=717046535);
# Time: 180612 17:35:09
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 4.012837 Lock_time: 0.000096 Rows_sent: 1 Rows_examined: 5406
SET timestamp=1528796109;
SELECT COUNT(*) AS a , sum(num) AS b FROM `ims_mc_credits_record` WHERE uniacid='225' AND module = 'bsht_tbk' AND createtime>='1528732800';
# Time: 180612 17:35:51
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 3.663113 Lock_time: 0.000148 Rows_sent: 10 Rows_examined: 3026
SET timestamp=1528796151;
SELECT em.*,m.credit1,m.credit2 FROM `ims_nets_hjk_members` AS em left join `ims_mc_members` AS m on em.memberid=m.uid where em.uniacid='680' ORDER BY id DESC limit 0,10;
# Time: 180612 17:35:55
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 4.778956 Lock_time: 1.032873 Rows_sent: 20 Rows_examined: 117
SET timestamp=1528796155;
SELECT mf.openid AS 'mfopenid', em.*,m.credit1,m.credit2 FROM `ims_mc_mapping_fans` AS mf INNER JOIN `ims_mc_members` AS m ON mf.uid=m.uid INNER JOIN `ims_nets_hjk_members` AS em ON mf.uid=em.memberid
where mf.uniacid='680' AND em.created_at >= 0 AND em.created_at <=1528882548 ORDER BY em.id DESC limit 0,20;
# Time: 180612 17:36:28
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 9.752760 Lock_time: 0.000098 Rows_sent: 1 Rows_examined: 2042
SET timestamp=1528796188;
select qrcid from `ims_qrcode` where uniacid='105' order by qrcid desc limit 1;
# Time: 180612 17:37:32
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 12.474970 Lock_time: 0.000087 Rows_sent: 4 Rows_examined: 7365
SET timestamp=1528796252;
select * from `ims_tiger_newhu_tkorder` where weid='654' and tgwid=724008707 order by addtime desc LIMIT 0,20;
# Time: 180612 17:39:17
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 7.164248 Lock_time: 0.000085 Rows_sent: 1 Rows_examined: 279
SET timestamp=1528796357;
SELECT COUNT(*) FROM `ims_mc_mapping_fans` WHERE uniacid = '279' and follow=1;
# Time: 180612 17:39:37
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 4.135208 Lock_time: 0.000094 Rows_sent: 1 Rows_examined: 997
SET timestamp=1528796377;
SELECT SUM(shouru_yongjin) as sum FROM `ims_bsht_tbk_order` WHERE uniacid = '302' AND shopid = '2553' AND UNIX_TIMESTAMP(ctime) >= '1528732800' AND UNIX_TIMESTAMP(ctime) <= '1528819199';
# Time: 180612 17:42:50
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 5.189814 Lock_time: 0.000237 Rows_sent: 1 Rows_examined: 406
SET timestamp=1528796570;
SELECT COUNT(*) FROM `ims_mc_mapping_fans` WHERE uniacid = '189' and follow=1;
# Time: 180612 17:43:16
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 3.067321 Lock_time: 0.000095 Rows_sent: 0 Rows_examined: 0
SET timestamp=1528796596;
INSERT INTO `ims_mc_mapping_fans` SET `openid` = 'ooL1s0cWV0nwxSqStsWOwsxFuc6o' , `acid` = '253' , `uniacid` = '253' , `updatetime` = '1528796592' , `followtime` = '1528796592' , `follow` = '1' , `nickname` = '禾狼' , `tag` = 'YToxMjp7czo5OiJzdWJzY3JpYmUiO2k6MTtzOjY6Im9wZW5pZCI7czoyODoib29MMXMwY1dWMG53eFNxU3RzV093c3hGdWM2byI7czo4OiJuaWNrbmFtZSI7czo2OiLnpr7ni7wiO3M6Mzoic2V4IjtpOjE7czo4OiJsYW5ndWFnZSI7czo1OiJ6aF9DTiI7czo0OiJjaXR5IjtzOjY6IuazieW3niI7czo4OiJwcm92aW5jZSI7czo2OiLnpo/lu7oiO3M6NzoiY291bnRyeSI7czo2OiLkuK3lm70iO3M6MTA6ImhlYWRpbWd1cmwiO3M6MTM2OiJodHRwOi8vdGhpcmR3eC5xbG9nby5jbi9tbW9wZW4vRVVtZWNpYWF4cjVRUXRNWFFtQ2UxaWNFMGVqUmRPM3RwdXpRMklNY2RiYkZjWXdNRWFzcXRkS0hpYU9lbkY2dWliaWN6VUtrQlk3STlVVVFLQVkzS05iYktJWmFtTXBIVUlJdlIvMTMyIjtzOjE0OiJzdWJzY3JpYmVfdGltZSI7aToxNTI4Nzk2NTkyO3M6NzoiZ3JvdXBpZCI7aTowO3M6MTA6InRhZ2lkX2xpc3QiO2E6MDp7fX0=' , `unionid` = '' , `groupid` = '' , `uid` = '239157' , `salt` = 'evM0MdDF' , `unfollowtime` = '0';
# Time: 180612 17:47:15
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 6.159303 Lock_time: 0.000083 Rows_sent: 1 Rows_examined: 10990
SET timestamp=1528796835;
SELECT COUNT(*) FROM `ims_mc_mapping_fans` WHERE uniacid = '198' and follow=1;
# Time: 180612 17:49:17
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 4.222540 Lock_time: 0.000144 Rows_sent: 1 Rows_examined: 120
SET timestamp=1528796957;
SELECT COUNT(*) FROM `ims_mc_mapping_fans` WHERE uniacid = '502' and follow=1;
# Time: 180612 17:50:26
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 5.636325 Lock_time: 0.000161 Rows_sent: 1 Rows_examined: 130
SET timestamp=1528797026;
SELECT COUNT(*) FROM `ims_mc_mapping_fans` WHERE uniacid = '596' and follow=1;
# Time: 180612 17:51:44
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 4.053587 Lock_time: 0.000120 Rows_sent: 1 Rows_examined: 404
SET timestamp=1528797104;
SELECT COUNT(*) FROM `ims_mc_mapping_fans` WHERE uniacid = '384' and follow=1;
# Time: 180612 17:57:30
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 4141.461198 Lock_time: 2.392443 Rows_sent: 0 Rows_examined: 725304
SET timestamp=1528797450;
select id,zyid,title,istmall,quan_id,num_iid,pic_url,org_price,price,goods_sale,coupons_end,coupons_total,coupons_take,coupons_price,tjcontent from `ims_tingtao_tk_tkgoods` where weid='147' and coupons_end>1528793308 and title like '%飞斑马双肩包女韩版潮包男印花旅行包校园书包高中大学生情侣背包%' and istmall=1 order by id desc LIMIT 0,20;
/www/server/mysql/bin/mysqld, Version: 5.5.57-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
# Time: 180612 17:58:48
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 47.573588 Lock_time: 0.000031 Rows_sent: 0 Rows_examined: 363024
use dd_277kzz_cn;
SET timestamp=1528797528;
SELECT * FROM `ims_mc_mapping_fans` WHERE `unionid` = NULL AND `openid` != 'ozMo95XjayL-y0Ch03lMfalaZMsY' LIMIT 1;
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 42.176468 Lock_time: 0.000031 Rows_sent: 0 Rows_examined: 363024
SET timestamp=1528797528;
SELECT * FROM `ims_mc_mapping_fans` WHERE `unionid` = NULL AND `openid` != 'ozMo95XjayL-y0Ch03lMfalaZMsY' LIMIT 1;
# User@Host: dd_277kzz_cn[dd_277kzz_cn] @ localhost [127.0.0.1]
# Query_time: 50.980899 Lock_time: 0.000034 Rows_sent: 0 Rows_examined: 363024
SET timestamp=1528797528;
SELECT * FROM `ims_mc_mapping_fans` WHERE `unionid` = NULL AND `openid` != 'ozMo95XjayL-y0Ch03lMfalaZMsY' LIMIT 1;
|
发表于 2018-6-12 18:23:12
QQ好友和群
QQ空间
收藏