83 Commits

Author SHA1 Message Date
03bc2507ca planner: track more details about time spent on query optimization (#65096)
close pingcap/tidb#64375
2025-12-29 06:13:11 +00:00
5271f751a0 planner: remove code of the deprecated optimizer trace - 5 (#64945)
ref pingcap/tidb#63725
2025-12-12 04:16:26 +00:00
fc68c74dbb planner: remove code of the deprecated optimizer trace - 4 (#64929)
ref pingcap/tidb#63725
2025-12-10 02:35:39 +00:00
2042309765 planner,executor: fix cannot dump plan replayer when query happen to panic (#64836)
close pingcap/tidb#64835
2025-12-04 12:13:41 +00:00
db1403ed6f planner: remove IsReadOnly function pointer (#64047)
ref pingcap/tidb#52714
2025-10-21 06:16:19 +00:00
f5234c41e8 planner: remove code of the deprecated optimizer trace - 1 (#63731)
ref pingcap/tidb#63725
2025-09-26 02:33:49 +00:00
acc067c5e6 planner: Make explain code call non-recursive functions to build plans instead of planner.Optimize. (#62798)
ref pingcap/tidb#61876
2025-08-26 20:28:58 +00:00
c7003d8d65 planner: Implement ignore_plan_cache hint for non-prepared statements. (#62641)
close pingcap/tidb#62634
2025-07-30 05:50:37 +00:00
be5bc77b73 planner: Remove InPreparedPlanBuilding member from StatementContext. (#62542)
ref pingcap/tidb#61876
2025-07-23 09:43:20 +00:00
e823930fc8 *: fix the issue about the case-insensitive in resource group hint (#62374)
close pingcap/tidb#62361
2025-07-18 21:38:22 +00:00
10c9872c78 planner: Allow prepared and non-prepared queries with set_var and resource_group hints to be cached. (#62367)
close pingcap/tidb#60920
2025-07-14 11:33:06 +00:00
1c612763c8 planner: Simplify plan cache code.gi (#61906)
close pingcap/tidb#61876
2025-07-02 03:16:54 +00:00
a268223774 domain: load system keyspace info schema (#61939)
ref pingcap/tidb#61702
2025-06-25 10:41:57 +00:00
1abbbf02de session: rename GetDomainInfoSchema to GetLatestInfoSchema (#61894)
ref pingcap/tidb#61702
2025-06-23 10:09:21 +00:00
f350b69798 planner: support "explain explore analyze" when exploring new plans offline (#61778)
ref pingcap/tidb#60148
2025-06-18 02:32:33 +00:00
e70afd2a44 planner: Support brief format for explain for connection (#61230)
close pingcap/tidb#60965
2025-06-10 08:20:43 +00:00
0d8e2bb4c5 planner: Make SET_VAR hints restore the correct session variable values after execution. (#61165)
close pingcap/tidb#60905
2025-06-05 17:23:29 +00:00
815130fc9e planner: merge the some code of helper func genPlanWithSCtx with Explain to reduce redundant code (#61224)
ref pingcap/tidb#60148
2025-05-21 00:35:34 +00:00
8ecc397d9c planner: a new helper function GenPlanWithSCtx for SPM (#61153)
ref pingcap/tidb#60148
2025-05-19 19:20:55 +00:00
dfc4eee0b4 planner: a new function to get all relevant optimizer variables related to a certain SQL for SPM (#61119)
ref pingcap/tidb#60148
2025-05-15 18:36:20 +00:00
07333a947f planner: Enable the non-prepared plan cache for queries with bindings. (#61048)
close pingcap/tidb#61047
2025-05-09 23:53:21 +00:00
1b8d15bd14 planner: Enable non-prepared plan cache for queries with hints. (#60952)
ref pingcap/tidb#60920
2025-05-08 19:46:54 +00:00
d9fb3a5337 ddl: Implement TableMode feature (#59009)
ref pingcap/tidb#59008
2025-04-03 11:03:30 +00:00
446952c54b planner: calculate plan_digest in place when fetching plan exec info from stmt_stats in SHOW PLAN FOR <SQL> (#60273)
ref pingcap/tidb#60148
2025-03-31 04:16:16 +00:00
752f18bc86 optimizer: postpone AdviseWarmup after processing binding (#60236)
close pingcap/tidb#60229, close pingcap/tidb#60231
2025-03-24 09:33:36 +00:00
0c83c5efa2 ast: Allow SELECT statements to set user-defined variables in read-only mode. (#59354)
close pingcap/tidb#55281
2025-03-13 22:53:36 +00:00
c778996297 planner: refactor some code related to binding (#59935)
ref pingcap/tidb#51347
2025-03-06 07:55:45 +00:00
b500d9e1eb planner: refactor some code related to binding (#59868)
ref pingcap/tidb#51347
2025-03-04 02:21:34 +00:00
cf4d252af8 *: split definition out of variable pkg and refactor some reorg methods (#59146)
ref pingcap/tidb#57229, ref pingcap/tidb#57497
2025-01-23 09:24:44 +00:00
b2f2faaa95 parser: move 'model' to 'ast' pkg (#58704)
ref pingcap/tidb#54436
2025-01-07 10:20:04 +00:00
77c6d1bd18 planner: simplify the bindinfo package (#58548)
ref pingcap/tidb#51347
2024-12-26 10:48:43 +00:00
1b2a23526c planner: add cascades portal for later optimization. (#58536)
ref pingcap/tidb#51664
2024-12-25 12:25:08 +00:00
457dcc6bbd planner: refactor some code of binding cache (#58504)
ref pingcap/tidb#51347
2024-12-24 09:57:15 +00:00
f3e27f0ca6 planner: remove unnecessary methods in global binding handler (#58350)
ref pingcap/tidb#51347
2024-12-18 05:01:46 +00:00
fe6c9b7d2a planner: move old cascades file into a limited pkg to avoid import core files. (#57246)
ref pingcap/tidb#51664
2024-11-11 06:34:19 +00:00
68fdf55d94 *: rename some packages of context (#56108)
close pingcap/tidb#56107
2024-09-19 07:11:03 +00:00
e00454a7b9 planner: move index advisor into the kernel (#55820)
ref pingcap/tidb#12303
2024-09-04 10:32:16 +00:00
4c23efb10b *: move annotated attributes of AST node to resolve.Context (#55634)
ref pingcap/tidb#54436
2024-08-29 13:39:01 +00:00
1f40cb0bc2 *: support batch create/drop bindings from plan/sql digest (#55315)
close pingcap/tidb#55343
2024-08-12 19:52:31 +00:00
21e48404da planner: support using hint to create hypo-indexes (#54517)
ref pingcap/tidb#43817
2024-07-10 13:46:34 +00:00
f490a98438 *: add context.Context parameter to infoschema TableByName (#54479)
ref pingcap/tidb#50959
2024-07-09 16:04:33 +00:00
ef0a3eb8af planner: support using hint to create hypo-indexes (#54498)
ref pingcap/tidb#43817
2024-07-08 12:55:32 +00:00
6fe4f9e470 variable: add system variable 'tidb_resource_control_strict_mode' (#54033)
ref pingcap/tidb#53440
2024-06-20 04:43:17 +00:00
d0e775dab0 planner: rename session plan cache interface (#54102)
ref pingcap/tidb#54057
2024-06-19 07:34:17 +00:00
01a45732ad planner: fix the issue that bindings with query-level hint can not take effect for replace statements (#54048)
close pingcap/tidb#53834
2024-06-18 05:19:16 +00:00
29fc940ae4 resource_control: introduce privilege RESOURCE_GROUP_USER to restrict the switch of resource group (#53483)
close pingcap/tidb#53440
2024-06-14 07:40:14 +00:00
a74d9a74c6 planner: small refactor for plan cache (#52837)
ref pingcap/tidb#50618
2024-04-23 10:25:40 +00:00
b1baf4d642 planner: move logical interface definition to base pkg (#52732)
ref pingcap/tidb#51664, ref pingcap/tidb#52714
2024-04-23 07:36:10 +00:00
5aa48d8284 planner: move base plan related output of core pkg and make it well-pkged (#52529)
ref pingcap/tidb#51664
2024-04-15 10:51:06 +00:00
68c03cfb65 txn: enable pipelined dml by hint (#51770)
ref pingcap/tidb#50215
2024-03-15 08:59:11 +00:00