windows server，無論修改my.ini的tmp_table_size，max_heap_table_size到多少，情況都一樣。

同樣的表和查詢語句，在本地運行，沒出現慢查詢。

SELECT

g.goods_id,

g.goods_name,

g.shop_price,

g.goods_thumb,

SUM(og.goods_number) AS goods_number

FROM

`chinaetm`.`ecs_goods` AS g,

`chinaetm`.`ecs_order_info` AS o,

`chinaetm`.`ecs_order_goods` AS og

WHERE

g.is_on_sale = 1

AND g.is_alone_sale = 1

AND g.is_delete = 0

AND (

g.cat_id IN (

'21',

'75',

'206',

'207',

'208',

'209',

'210',

'211',

'212'

) OR g.goods_id IN ('')

) AND og.order_id = o.order_id

AND og.goods_id = g.goods_id

AND (

o.order_status = '1'

OR o.order_status = '5'

)

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

explain結果

總結

以上是生活随笔為你收集整理的copying mysql status_mysql慢查询copying to tmp table的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。