We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
2023/07/20 17:14:20.408 [D] [mysql.go:92] Execute SQL with DSN(10.8.0.4:3306/sorttest) : select @@Version 2023/07/20 17:14:20.410 [D] [mysql.go:92] Execute SQL with DSN(eu-monoprix-all-database.mysql.database.azure.com:3306/poc_storedb_monoprix) : select @@Version 2023/07/20 17:14:20.458 [E] [mysql.go:95] dial tcp: lookup eu-monoprix-all-database.mysql.database.azure.com on 127.0.0.11:53: no such host 2023/07/20 17:14:20.458 [W] [mysql.go:132] (db *Connector) Version() Error: dial tcp: lookup eu-monoprix-all-database.mysql.database.azure.com on 127.0.0.11:53: no such host 2023/07/20 17:14:20.458 [W] [env.go:88] BuildEnv OnlineDSN: azureuser:********@eu-monoprix-all-database.mysql.database.azure.com:3306/poc_storedb_monoprix not available , Error: dial tcp: lookup eu-monoprix-all-database.mysql.database.azure.com on 127.0.0.11:53: no such host 2023/07/20 17:14:20.458 [W] [env.go:104] TestDSN MySQL version older than OnlineDSN(99999), TestDSN(50724) will not be used 2023/07/20 17:14:20.458 [D] [soar.go:127] main loop SQL: select * from hs_esl limit 100 2023/07/20 17:14:20.459 [D] [soar.go:203] start of heuristic advisor Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [meta.go:201] Enter: FindColumn, Caller: github.com/XiaoMi/soar/advisor.(*Query4Audit).RuleNoDeterministicGroupby.func1 2023/07/20 17:14:20.469 [D] [meta.go:201] Enter: FindColumn, Caller: github.com/XiaoMi/soar/advisor.(*Query4Audit).RuleNoDeterministicGroupby.func1 2023/07/20 17:14:20.469 [D] [soar.go:214] end of heuristic advisor Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [soar.go:220] start of index advisor Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [env.go:364] createDatabase, mapping poc_storedb_monoprix :poc_storedb_monoprix-->optimizer_230720171420_ippk2of6yovk0l2e 2023/07/20 17:14:20.469 [W] [env.go:367] createDatabase, rEnv.ShowCreateDatabase Error : dsn is disable 2023/07/20 17:14:20.469 [W] [env.go:377] createDatabase, Error : dsn is disable 2023/07/20 17:14:20.469 [W] [logger.go:122] [env.go:207] dsn is disable 2023/07/20 17:14:20.469 [I] [env.go:211] BuildVirtualEnv TestDSN not config 2023/07/20 17:14:20.469 [D] [index.go:90] Enter: NewAdvisor(), Caller: main.main 2023/07/20 17:14:20.469 [D] [soar.go:228] idxAdvisor by pass Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [soar.go:266] end of index advisor Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [soar.go:271] start of explain Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [soar.go:299] end of explain Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [soar.go:303] start of profiling Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [soar.go:316] end of profiling Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [soar.go:320] start of trace Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [soar.go:333] end of trace Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [soar.go:337] start of rewrite Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [soar.go:371] end of rewrite Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [soar.go:375] start of print suggestions, Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [rules.go:1198] FormatSuggest, Query: select * from hs_esl limit 100 2023/07/20 17:14:20.469 [D] [rules.go:1244] FormatSuggest, format: markdown 2023/07/20 17:14:20.469 [D] [pretty.go:31] Pretty, Query: select * from hs_esl limit 100, method: markdown 2023/07/20 17:14:20.471 [D] [rules.go:1291] FormatSuggest, start of sortedMySQLSuggest 2023/07/20 17:14:20.471 [D] [rules.go:1313] FormatSuggest, start of sortedExplainSuggest 2023/07/20 17:14:20.471 [D] [rules.go:1334] FormatSuggest, start of sortedProfilingSuggest 2023/07/20 17:14:20.471 [D] [rules.go:1351] FormatSuggest, start of sortedTraceSuggest 2023/07/20 17:14:20.471 [D] [rules.go:1368] FormatSuggest, start of sortedIdxSuggest 2023/07/20 17:14:20.471 [D] [rules.go:1397] FormatSuggest, start of sortedHeuristicSuggest 2023/07/20 17:14:20.471 [D] [soar.go:405] end of print suggestions, Query: select * from hs_esl limit 100 2023/07/20 17:14:20.471 [D] [soar.go:109] Ending, buf: '', sql: ''
poc_storedb_monoprix
optimizer_230720171420_ippk2of6yovk0l2e
The text was updated successfully, but these errors were encountered:
No branches or pull requests
2023/07/20 17:14:20.408 [D] [mysql.go:92] Execute SQL with DSN(10.8.0.4:3306/sorttest) : select @@Version
2023/07/20 17:14:20.410 [D] [mysql.go:92] Execute SQL with DSN(eu-monoprix-all-database.mysql.database.azure.com:3306/poc_storedb_monoprix) : select @@Version
2023/07/20 17:14:20.458 [E] [mysql.go:95] dial tcp: lookup eu-monoprix-all-database.mysql.database.azure.com on 127.0.0.11:53: no such host
2023/07/20 17:14:20.458 [W] [mysql.go:132] (db *Connector) Version() Error: dial tcp: lookup eu-monoprix-all-database.mysql.database.azure.com on 127.0.0.11:53: no such host
2023/07/20 17:14:20.458 [W] [env.go:88] BuildEnv OnlineDSN: azureuser:********@eu-monoprix-all-database.mysql.database.azure.com:3306/poc_storedb_monoprix not available , Error: dial tcp: lookup eu-monoprix-all-database.mysql.database.azure.com on 127.0.0.11:53: no such host
2023/07/20 17:14:20.458 [W] [env.go:104] TestDSN MySQL version older than OnlineDSN(99999), TestDSN(50724) will not be used
2023/07/20 17:14:20.458 [D] [soar.go:127] main loop SQL: select * from hs_esl limit 100
2023/07/20 17:14:20.459 [D] [soar.go:203] start of heuristic advisor Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [meta.go:201] Enter: FindColumn, Caller: github.com/XiaoMi/soar/advisor.(*Query4Audit).RuleNoDeterministicGroupby.func1
2023/07/20 17:14:20.469 [D] [meta.go:201] Enter: FindColumn, Caller: github.com/XiaoMi/soar/advisor.(*Query4Audit).RuleNoDeterministicGroupby.func1
2023/07/20 17:14:20.469 [D] [soar.go:214] end of heuristic advisor Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:220] start of index advisor Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [env.go:364] createDatabase, mapping
poc_storedb_monoprix
:poc_storedb_monoprix
-->optimizer_230720171420_ippk2of6yovk0l2e
2023/07/20 17:14:20.469 [W] [env.go:367] createDatabase, rEnv.ShowCreateDatabase Error : dsn is disable
2023/07/20 17:14:20.469 [W] [env.go:377] createDatabase, Error : dsn is disable
2023/07/20 17:14:20.469 [W] [logger.go:122] [env.go:207] dsn is disable
2023/07/20 17:14:20.469 [I] [env.go:211] BuildVirtualEnv TestDSN not config
2023/07/20 17:14:20.469 [D] [index.go:90] Enter: NewAdvisor(), Caller: main.main
2023/07/20 17:14:20.469 [D] [soar.go:228] idxAdvisor by pass Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:266] end of index advisor Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:271] start of explain Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:299] end of explain Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:303] start of profiling Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:316] end of profiling Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:320] start of trace Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:333] end of trace Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:337] start of rewrite Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:371] end of rewrite Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [soar.go:375] start of print suggestions, Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [rules.go:1198] FormatSuggest, Query: select * from hs_esl limit 100
2023/07/20 17:14:20.469 [D] [rules.go:1244] FormatSuggest, format: markdown
2023/07/20 17:14:20.469 [D] [pretty.go:31] Pretty, Query: select * from hs_esl limit 100, method: markdown
2023/07/20 17:14:20.471 [D] [rules.go:1291] FormatSuggest, start of sortedMySQLSuggest
2023/07/20 17:14:20.471 [D] [rules.go:1313] FormatSuggest, start of sortedExplainSuggest
2023/07/20 17:14:20.471 [D] [rules.go:1334] FormatSuggest, start of sortedProfilingSuggest
2023/07/20 17:14:20.471 [D] [rules.go:1351] FormatSuggest, start of sortedTraceSuggest
2023/07/20 17:14:20.471 [D] [rules.go:1368] FormatSuggest, start of sortedIdxSuggest
2023/07/20 17:14:20.471 [D] [rules.go:1397] FormatSuggest, start of sortedHeuristicSuggest
2023/07/20 17:14:20.471 [D] [soar.go:405] end of print suggestions, Query: select * from hs_esl limit 100
2023/07/20 17:14:20.471 [D] [soar.go:109] Ending, buf: '', sql: ''
The text was updated successfully, but these errors were encountered: