It take a long time to resume / 重启时间较长

[LinZexiao]

Summary

Drople 重启的时候 有一个查询花了比较长的时间

Log

2023-07-04T09:48:55.254+0800	INFO	modules	rpc/rpc.go:99	start rpc listen /ip4/0.0.0.0/tcp/41240

2023/07/04 09:48:59 /root/droplet/models/mysql/storage_deal.go:405 SLOW SQL >= 200ms
[4098.379ms] [rows:34326] SELECT * FROM `storage_deals` WHERE cdp_provider='02002688' AND state in (7)

2023/07/04 09:52:06 /root/droplet/models/mysql/storage_deal.go:478 SLOW SQL >= 200ms
[191476.179ms] [rows:1527454] SELECT * FROM `storage_deals` LIMIT 2147483647