优惠券mysql 慢sql top 10,缺少主键
2.解决方案： 在晚上业务使用量少的时候创建 已添加
- 发现无主键表'prod_source.rb_report_order_source_skuday'，建议添加主键。
3.SQL
INSERT INTO prod_coupon.report_order_source_skuday (id, customer_id, order_source_id, order_source_sku, sku , sales_num, sales_day, order_num, update_time) SELECT t1.id, t1.customer_id, t1.order_source_id, t1.order_source_sku, t1.sku , t1.sales_num, t1.sales_day, t1.order_num, t1.update_time FROM prod_source.rb_report_order_source_skuday t1 WHERE t1.update_time >= date_sub(now(), INTERVAL 3 DAY) ON DUPLICATE KEY UPDATE id = VALUES(id), customer_id = VALUES(customer_id), order_source_id = VALUES(order_source_id), order_source_sku = VALUES(order_source_sku), sku = VALUES(sku) , sales_num = VALUES(sales_num), sales_day = VALUES(sales_day), order_num = VALUES(order_num), update_time = VALUES(update_time)