Re: Server just hanging (Copying to tmp table)

[Thomas Deliduka]

In case the above syntax is too long to be easily read...
YOUR MODIFICATION:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE xno_items ref active active 4 const 1647 Using temporary; Using filesort
1 SIMPLE xno_prod_index eq_ref PRIMARY PRIMARY 64 finerkitchens_com.xno_items.itemid,const 1
1 SIMPLE xno_item_cat index NULL PRIMARY 8 NULL 5155 Using index
1 SIMPLE xno_categories eq_ref PRIMARY,active PRIMARY 4 finerkitchens_com.xno_item_cat.catid 1
1 SIMPLE xno_manufacturers eq_ref PRIMARY PRIMARY 4 finerkitchens_com.xno_items.mfgid 1


ORIGINAL:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE xno_items ref PRIMARY,active active 4 const 1647 Using temporary; Using filesort
1 SIMPLE xno_prod_index eq_ref PRIMARY PRIMARY 64 finerkitchens_com.xno_items.itemid,const 1 Using where
1 SIMPLE xno_item_cat index NULL PRIMARY 8 NULL 5155 Using index
1 SIMPLE xno_categories eq_ref PRIMARY,active PRIMARY 4 finerkitchens_com.xno_item_cat.catid 1 Using where
1 SIMPLE xno_manufacturers eq_ref PRIMARY PRIMARY 4 finerkitchens_com.xno_items.mfgid 1

I know enough to be dangerous. Thanks for being patient!