Skip to content

Include storage engine in slow logs and statements summary #61736

Closed
#61737
Closed
Include storage engine in slow logs and statements summary#61736
#61737
Assignees
henrybw
Labels
affects-8.5This bug affects the 8.5.x(LTS) versions.sig/executionSIG executiontype/enhancementThe issue or PR belongs to an enhancement.

Description

@henrybw
henrybw
opened on Jun 13, 2025

Enhancement

For deployments involving both TiKV and TiFlash, it's not easy to identify the queries from TiFlash in slow query logs, which makes troubleshooting inconvenient for customers and support engineers. Including extra attributes to identify the storage engine in both the statements summary tables and slow query log would help alleviate this issue.

Activity

  1. henrybw
    added
    type/enhancementThe issue or PR belongs to an enhancement.
    on Jun 13, 2025

  2. henrybw commented on Jun 13, 2025

    @henrybw
    henrybw
    on Jun 13, 2025
    ContributorAuthor

    /assign

  3. ti-chi-bot
    assigned
    henrybw
    on Jun 13, 2025
  4. ti-chi-bot
    closed this as completedin #61737on Jul 29, 2025
  5. ti-chi-bot
    added a commit that references this issue on Jul 29, 2025

    slowlog, stmtsummary: include the storage engine(s) a query read from (…

    a53894a
  6. JaySon-Huang
    added a commit that references this issue on Aug 10, 2025

    slowlog, stmtsummary: include the storage engine(s) a query read from (…

    774e00d

  7. JaySon-Huang commented on Nov 27, 2025

    @JaySon-Huang
    JaySon-Huang
    on Nov 27, 2025
    Contributor

    I found this field in the slow logs is very useful for identifying the slow queries executing on TiFlash! Hope it could be cherry-pick to release-8.5 branch. /cc @terry1purcell @fixdb

  8. ti-chi-bot
    added
    affects-8.5This bug affects the 8.5.x(LTS) versions.
    on Dec 2, 2025
  9. fixdb
    added
    sig/executionSIG execution
    on Dec 2, 2025
  10. ti-chi-bot
    added a commit that references this issue on Dec 4, 2025

    slowlog, stmtsummary: include the storage engine(s) a query read from (…

    9dbb53e
  11. kennedy8312
    added a commit that references this issue on Dec 26, 2025

    slowlog, stmtsummary: include the storage engine(s) a query read from (…

    ab668a8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

affects-8.5This bug affects the 8.5.x(LTS) versions.sig/executionSIG executiontype/enhancementThe issue or PR belongs to an enhancement.

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions