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

feat(guardian-prover-health-check): add indexer in MySQL #16060

Merged
merged 2 commits into from
Feb 26, 2024
Merged

feat(guardian-prover-health-check): add indexer in MySQL #16060

merged 2 commits into from
Feb 26, 2024

Conversation

xiaodino
Copy link
Contributor

@xiaodino xiaodino commented Feb 25, 2024 •
edited
Loading

It's to to optimize these queries:

SELECT * FROM `health_checks` WHERE `guardian_prover_id` = ? ORDER BY `created_at` DESC LIMIT ?

SELECT COUNT ( * ) FROM `health_checks` WHERE `guardian_prover_id` = ? AND `created_at` > NOW ( ) - INTERVAL ? SQL_TSI_DAY

@xiaodino xiaodino added this pull request to the merge queue Feb 26, 2024
Merged via the queue into main with commit 87a4876 Feb 26, 2024
8 checks passed
@xiaodino xiaodino deleted the xiaodino/add-index-guardian-prover-health-check-created-at branch February 26, 2024 09:53
@taiko-kitty taiko-kitty mentioned this pull request Feb 26, 2024
Closed
@taiko-kitty taiko-kitty mentioned this pull request May 13, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@davidtaikocha davidtaikocha davidtaikocha approved these changes

@dantaik dantaik dantaik approved these changes

@mask-pp mask-pp Awaiting requested review from mask-pp

@cyberhorsey cyberhorsey Awaiting requested review from cyberhorsey

Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
3 participants
@xiaodino @dantaik @davidtaikocha