cannt show slow query records
Nobody has claimed this yet.
- Dominant language
- Go
- Stars
- 14.5k
- Forks
- 984
- Avg merge
- 15h 58m
- Merged PRs (30d)
- 256
Description
Provide the Bytebase version you are using
2.11.0
Describe the bug
when i enter /slow-query page，
log occur error:
time=2023-12-04T09:13:11.075Z level=ERROR source=server/routers.go:37 msg="echo request logger" method=GET uri=/slow-query status=404 error="code=404, message=Not Found"
time=2023-12-04T09:15:55.165Z level=WARN source=v1/instance_service.go:313 msg="slow query log is not enabled" instance=flbn-ygabczmuaf error="slow query log is not enabled: slow_query_log = OFF
Steps to reproduce
1、mysql 5.7 slow_log table exists slow log records
2、mysql instances enable slow log function config
Expected behavior
i can see slow-log
Provide the database type and version you are using
No response
Provide the GitLab version you are using
No response
Additional context
No response
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the /slow-query request against Bytebase 2.11.0 with a MySQL 5.7 instance and slow_query_log enabled. Read server/routers.go:37 and v1/instance_service.go:313, then trace how the slow_log table is queried. Done means the slow-query page loads and displays the available slow-log records instead of returning 404 or reporting that logging is disabled.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, mysql
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100