配置文件怎么搞?
我做过索引的,下面是explain的结果,好象就sp_goods的ref=null有点问题,不过这好象无法避免:
id select_type table type possible_keys key key_len ref rows
1 SIMPLE sp_goods range did,status status 1 NULL 10896
1 SIMPLE sp_doors eq_ref PRIMARY,dr_ct_id,dr_sh_id PRIMARY 3 bbs.sp_goods.did 1
1 SIMPLE sp_shop eq_ref PRIMARY,mid,viptime PRIMARY 2 bbs.sp_doors.dr_sh_id 1
1 SIMPLE user eq_ref PRIMARY PRIMARY 3 bbs.sp_shop.mid 1
1 SIMPLE login_superet ref sid sid 2 bbs.sp_shop.sid 208
1 SIMPLE sp_catetype eq_ref PRIMARY PRIMARY 1 bbs.sp_doors.dr_ct_id 1
我做过索引的,下面是explain的结果,好象就sp_goods的ref=null有点问题,不过这好象无法避免:
id select_type table type possible_keys key key_len ref rows
1 SIMPLE sp_goods range did,status status 1 NULL 10896
1 SIMPLE sp_doors eq_ref PRIMARY,dr_ct_id,dr_sh_id PRIMARY 3 bbs.sp_goods.did 1
1 SIMPLE sp_shop eq_ref PRIMARY,mid,viptime PRIMARY 2 bbs.sp_doors.dr_sh_id 1
1 SIMPLE user eq_ref PRIMARY PRIMARY 3 bbs.sp_shop.mid 1
1 SIMPLE login_superet ref sid sid 2 bbs.sp_shop.sid 208
1 SIMPLE sp_catetype eq_ref PRIMARY PRIMARY 1 bbs.sp_doors.dr_ct_id 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货