Closed pengpai2016 closed 6 years ago
./sqladvisor -h 172.2x.xxx.102 -u admin -p '123456' -P 3306 -d sql_db -q "select from dbinfo where dbname ='test'" -v 1 2018-03-27 16:38:32 22274 [Note] 第1步: 对SQL解析优化之后得到的SQL:select `AS*fromsql_db.dbinfowhere (dbname` = 'test')3
AS
from
.
where (
2018-03-27 16:38:32 22274 [Note] 第2步:开始解析where中的条件:(dbname = 'test')
dbname
段错误
换成centos6.8安装成功,原来是centos7 安装也能成功,但是在centos7上再装上mariadb,执行就报段错误了;在centos6.8安装sqladvisor再安装mariadb没报段错误。
./sqladvisor -h 172.2x.xxx.102 -u admin -p '123456' -P 3306 -d sql_db -q "select from dbinfo where dbname ='test'" -v 1 2018-03-27 16:38:32 22274 [Note] 第1步: 对SQL解析优化之后得到的SQL:select `
AS
*from
sql_db.
dbinfowhere (
dbname` = 'test')32018-03-27 16:38:32 22274 [Note] 第2步:开始解析where中的条件:(
dbname
= 'test')段错误