Yuanjia Zhang

planner: move logic of plan cache stmt checking to plan cache backend

6

### What problem does this PR solve? Issue Number: ref #36598 Problem Summary: planner: move logic of plan cache stmt checking to plan cache backend ### What is changed and...

[WIP] general plan cache demo

3

### What problem does this PR solve? Issue Number: close #xxx Problem Summary: ### What is changed and how it works? ### Check List Tests - [ ] Unit test...

planner: add docs for some variables

3

### First-time contributors' checklist - [ ] I've signed [**Contributor License Agreement**](https://cla-assistant.io/pingcap/docs) that's required for repo owners to accept my contribution. ### What is changed, added or deleted? (Required) ###...

Incubating Program: Plan Change Capturer

1

## Project Incubating Request Plan Change Capturer ### Describe the project you want to incubate: #### Summary **User story**: as a user, I want to ensure there is no performance...

Meta2 make DBFile invalid

1

Write-Transactions update Meta1 on commit, and Meta2 only be updated at Backup (invoke tx.WriteTo); **So, please consider this case:** 1. Assume my DB's freelist is stored in Page34, and I...

Why the default number of iteration is 10000?

1

These four lines: 32: hmacKey := pbkdf2.Key([]byte(password), hmacSalt, 10000, 32, sha1.New) 45: cipherKey := pbkdf2.Key([]byte(password), encSalt, 10000, 32, sha1.New) 91: encKey := pbkdf2.Key([]byte(password), encSalt, 10000, 32, sha1.New) 92: hmacKey :=...

planner: the optimizer can't produce an optimal plan for queries with sub-queries in select list since it always decorrelate sub-queries

1

## Enhancement See the case below: ``` create table t_small (a int, b int); create table t_big (a int, b int, key(a)); explain select * from t_small join (select *,...

planner: the optimizer can't produce an optimal plan for queries with sub-queries in select list since it always decorrelate sub-queries

2

## Enhancement For queries like `select t_small join {subquery} t_big on t_small.c=t_big.c` or `select * from t_small, {subquery} t_big where t_small.c=t_big.c`, TiDB always tries to decorrelate sub-queries (this operator is...

Not clear existing filter conditions in the Slow-Query page after entering the slow-query detail page

2

## Feature Request **Is your feature request related to a problem? Please describe:** 1. Set some filter conditions in the Slow-Query page;  2. Then enter the detail page of...

planner: update Plan Cache doc

1

### First-time contributors' checklist - [ ] I've signed [**Contributor License Agreement**](https://cla-assistant.io/pingcap/docs-cn) that's required for repo owners to accept my contribution. ### What is changed, added or deleted? (Required) ###...