MySQL数据库索引的demo.pdf

mysql索引demo

下载地址

https://git.cfhy.work/demo/mysql-demo

线上慢sql

分析

1.索引过多

1SELECT

2ount(*)

3FROM

4(

5SELECT

6o.id,

7om.type,

8om.business_name,

9om.broker_name,

10o.driver_id,

11o.driver_name,

12o.driver_phone,

13o.sn,

14o.ar_number,

15o.STATUS,

16IF

17(

18om.slug_reeive_plaeISNULL,

19om.reeive_plae,

20onat(om.slug_reeive_plae,-,om.reeive_plae))ASreei

21IF

22(

23om.slug_delivery_plaeISNULL,

24om.delivery_plae,

25onat(om.slug_delivery_plae,-,om.delivery_plae))ASdel

26o.freight,

27om.argo_type,

28o.tax_publish_flagAStaxPublishFlag,

29o.tax_thresholdAStaxThreshold,

30o.amount,

31oir.urrent_ton,

32ob.freeze_status,

33ob.freeze_msg,

34oir.is_risk,

35oir.risk_key,

36ob.is_platform_orderisPlatformOrder,

37o.original_ton_image_urloriginalTonImageUrl,

38oir.imageimage

39FROM

40(order_item)ASo

41INNERJOINorder_ommonASomONo.order_ommon_id=om.id

42LEFTJOINorder_item_reportASoirONo.order_item_report_id=o

43LEFTJOINbath_order_itemboiONo.id=boi.ord