MySQLAdvisor

MySQLAdvisor copied to clipboard

工具只能优化SELECT XXX FROM XXX的简单SQL？只要稍微麻烦点就core dump，弱爆了 2021-08-26 00:14:44 1808 [Note] 第12步：开始选择驱动表,一共有3个候选驱动表 2021-08-26 00:14:44 1808 [Note] explain select * from hmd_type Segmentation fault (core dumped)

WshaoJie

xiaocaiji-ctrl

## sql ``` SELECT * FROM `db2`.`tableA` AS a LEFT JOIN `db1`.`tableB` AS b ON a.company_code = b.CompanyCode WHERE a.company_code = 'xxx' AND a.company_type = '1' ``` ## 具体日志（对关键信息做了替换） ```...

weeway

/sqladvisor -u xx -p xx -P 3306 -h xxx -d sms -q 'SELECT d.id,a.sms_id,a.customer_id,d.phone,d.send_state,d.fail_msg,a.send_time FROM sms_record_detail d LEFT JOIN sms_record a on a.sms_id=d.sms_id WHERE d.create_time between \"2022-10-30 00:00:00\" and \"2022-10-31...

Gxiaodiao