In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
An error was reported when installing and using Meituan net sqladvisor:
. / sqladvisor-h xxx-P 3306-u admin-p 'xxx'-d sql_audit-Q "SELECT FROM product_spu_modify where CreateTime > '2018-07-29 14 15 admin 46;"-v 1
2018-07-30 17:51:19 10008 [Note] step 1: optimize the SQL:select AS * from sql_audit.product_spu_modify where obtained after SQL parsing (CreateTime > '2018-07-29 14 SQL:select AS 15 from sql_audit.product_spu_modify where 46')
2018-07-30 17:51:19 10008 [Note] step 2: start parsing the conditions in the where: (CreateTime > '2018-07-29 14 CreateTime 15 CreateTime 46')
2018-07-30 17:51:19 10008 [Note] step 3: end of SQLAdvisor! Error log: Invalid parameter number
Since it is difficult to troubleshoot without a detailed error log, but it must be dependent on the package, this package must have something to do with passing in the MYSQL parameter. After many aspects of testing, the problem that has plagued me for a week has been solved. The problem lies in the php-mysql extension installed by centos, which will appear above SQLAdvisor end! Error log: Invalid parameter numbered error logs! Replace php-mysql with php-mysqlnd. The problem can be solved.
Yum install php-mysqlnd
2018-08-02 14:57:12 5294 [Note] step 5: field CreateTime is not a primary key. Table name: product_spu_modify
2018-08-02 14:57:12 5294 [Note] step 6: start verifying that the field CreateTime is the primary key. Table name: product_spu_modify
2018-08-02 14:57:12 5294 [Note] show index from product_spu_modify where Key_name = 'PRIMARY' and Column_name =' CreateTime' and Seq_in_index = 1
2018-08-02 14:57:12 5294 [Note] step 7: field CreateTime is not a primary key. Table name: product_spu_modify
2018-08-02 14:57:12 5294 [Note] step 8: start verifying that the relevant index already exists in the table. Table name: product_spu_modify, field name: CreateTime, position in the index: 1
2018-08-02 14:57:12 5294 [Note] show index from product_spu_modify where Column_name = 'CreateTime' and Seq_in_index = 1
2018-08-02 14:57:12 5294 [Note] step 9: start the output table product_spu_modify index optimization recommendations:
2018-08-02 14:57:12 5294 [Note] Create_Index_SQL:alter table product_spu_modify add index idx_CreateTime (CreateTime)
2018-08-02 14:57:12 5294 [Note] step 10: end of SQLAdvisor!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.