深圳智汇创想科技有限公司

[步骤]

[结果]

[期望]

优化慢sql:

SELECT   id,source_id,source_name,asin,msku,sku,country   FROM t_amazon_listing_N   WHERE  is_deleted=N AND (source_id = N AND customer_id = N AND id > N) ORDER BY id ASC limit N;

优化到平均 0.5s 内

优化建议：

index_merge 比 range 性能差8-10倍

建议改为：

SELECT

id,source_id,source_name,asin,msku,sku,country

FROM t_amazon_listing_25

WHERE is_deleted=0 AND (source_id = 6104 AND customer_id = 1 AND id > 99188018)

ORDER BY id ASC limit 500;