Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

#

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Jump to bottom

Query to is.tables is slow in infoschema cache v2 #57295

Closed
tangenta opened this issue Nov 11, 2024 · 1 comment · Fixed by #57296
Closed

Query to is.tables is slow in infoschema cache v2 #57295

tangenta opened this issue Nov 11, 2024 · 1 comment · Fixed by #57296
Assignees
@tangenta
Labels
affects-8.5 This bug affects the 8.5.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-6.5 may-affects-7.1 may-affects-7.5 may-affects-8.1 severity/major type/bug The issue is confirmed as a bug.

Comments

@tangenta
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

  1. Create a TiDB cluster that has a lot of schemas and tables.
  2. Execute select * from information_schema.tables where table_name = 'xx'

2. What did you expect to see? (Required)

It should complete fast.

3. What did you see instead (Required)

It takes about 400ms to finish a query. From the CPU profile, we can see there are many cache misses.

image

4. What is your TiDB version? (Required)

e16613d
@tangenta tangenta added the type/bug The issue is confirmed as a bug. label Nov 11, 2024
@tangenta tangenta changed the title Query to is.tables is slow when infoschema cache v2 is enabled Query to is.tables is slow in infoschema cache v2 Nov 11, 2024
@tangenta
Copy link
Contributor Author

executor.getAutoIncrementID() should not trigger loadTableInfo().

@tangenta tangenta self-assigned this Nov 11, 2024
@tangenta tangenta mentioned this issue Nov 11, 2024
Merged
13 tasks
@tangenta tangenta added affects-8.5 This bug affects the 8.5.x(LTS) versions. severity/moderate labels Nov 11, 2024
@jebter jebter added the component/ddl This issue is related to DDL of TiDB. label Nov 12, 2024
@ti-chi-bot ti-chi-bot bot closed this as completed in eea72ec Nov 13, 2024
@ti-chi-bot ti-chi-bot mentioned this issue Nov 19, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Nov 20, 2024
@ti-chi-bot
infoschema: don't load table info to get auto_increment value (#57296) (
ed6d669 
#57494)

close #57295
# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees

@tangenta tangenta

Labels
affects-8.5 This bug affects the 8.5.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-6.5 may-affects-7.1 may-affects-7.5 may-affects-8.1 severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

infoschema: don't load table info to get auto_increment value tangenta/tidb
2 participants
@jebter @tangenta