Skip to content
New issue

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

Sign up for GitHub

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

Already on GitHub? Sign in to your account

Jump to bottom

[Question][MySQL] MySQL Performance #8260

Open
jeffschaper opened this issue Jan 8, 2025 · 1 comment
Open

[Question][MySQL] MySQL Performance #8260

jeffschaper opened this issue Jan 8, 2025 · 1 comment
Labels
type/question This issue is a question

Comments

@jeffschaper
Copy link
Contributor

Question

My company is running DevLake at scale with approximately 1,000 projects. The out-of-the-box MySQL database (running in Azure) seems to struggle when loading the Grafana dashboard despite a generous compute size of 16 cores and 64 GB of memory.
Is there a way to optimize performance of the MySQL database. Are there any slam-dunk server parameters I should change to optimize performance?

Screenshots

Screenshot 2025-01-08 at 2 44 12 PM

Additional context

The CPU and memory seem to spike when loading the Grafana dashboard.
@jeffschaper jeffschaper added the type/question This issue is a question label Jan 8, 2025
@klesh
Copy link
Contributor

klesh commented Jan 14, 2025

Try increasing the memory and use ssd storage.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/question This issue is a question
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@klesh @jeffschaper