Mysql性能分析之explain

DBA监控服务器指标,发现cpu指标占用率到27%,经过排查得知一条简单的查询SQL导致;eg:select supplier_id,product_id,status from t_order where product_id = 'xxx';