Hi,
I've tried this tool (index_advisor) in our cluster, and faced several issues:
2024/12/06 10:17:20 tidb_what_if_optimizer.go:105: [ERROR] failed to create hypo index 'create index idx_order type hypo on test.source_photos (order)': Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 65 near "order)"
2024/12/06 10:37:38 advise_offline.go:325: [WARNING] failed to get schema of table payment-service.payment_notifications: Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 26 near "-service.payment_notifications" 2024/12/06 10:37:38 tidb_what_if_optimizer.go:59: [ERROR] error Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 26 near "-service.payments" when running query show create table payment-service.payments
2024/12/06 10:15:37 tidb_what_if_optimizer.go:105: [ERROR] failed to create hypo index 'create index idx_id type hypo on test.types (id)': Error 8242 (HY000): 'Create Index' is unsupported on cache tables. 2024/12/06 10:15:37 utils.go:73: [WARNING] create test.types(id) failed: Error 8242 (HY000): 'Create Index' is unsupported on cache tables.
Seems first 2 issues because of missing escapes in sql requests ? and 3rd - is it possible to ignore cache tables ? @qw4990 Please help )
Hi,
I've tried this tool (index_advisor) in our cluster, and faced several issues:
2024/12/06 10:17:20 tidb_what_if_optimizer.go:105: [ERROR] failed to create hypo index 'create index idx_order type hypo on test.source_photos (order)': Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 65 near "order)"2024/12/06 10:37:38 advise_offline.go:325: [WARNING] failed to get schema of table payment-service.payment_notifications: Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 26 near "-service.payment_notifications" 2024/12/06 10:37:38 tidb_what_if_optimizer.go:59: [ERROR] error Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 26 near "-service.payments" when running query show create table payment-service.payments2024/12/06 10:15:37 tidb_what_if_optimizer.go:105: [ERROR] failed to create hypo index 'create index idx_id type hypo on test.types (id)': Error 8242 (HY000): 'Create Index' is unsupported on cache tables. 2024/12/06 10:15:37 utils.go:73: [WARNING] create test.types(id) failed: Error 8242 (HY000): 'Create Index' is unsupported on cache tables.Seems first 2 issues because of missing escapes in sql requests ? and 3rd - is it possible to ignore cache tables ? @qw4990 Please help )