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

Why is logging in to the try.gitea.io homepage very slow #20129

Closed
tyroneyeh opened this issue Jun 25, 2022 · 4 comments · Fixed by #20158
Closed

Why is logging in to the try.gitea.io homepage very slow #20129

tyroneyeh opened this issue Jun 25, 2022 · 4 comments · Fixed by #20158
Labels
type/bug

Comments

@tyroneyeh
Copy link
Contributor

Description

as title

Gitea Version

1.18.0+dev-33-g97bfabc74

Can you reproduce the bug on the Gitea demo site?

Yes

Log Gist

No response

Screenshots

image

Git Version

No response

Operating System

No response

How are you running Gitea?

In try.gitea.io

Database

No response
@devgogo
Copy link

devgogo commented Jun 27, 2022

yes, very low.

@lunny
Copy link
Member

lunny commented Jun 27, 2022

Sometimes CPU is 100% and this is a single core VPS. And I haven't found why CPU is 100% sometimes.

@tyroneyeh
Copy link
Contributor Author

Strange, the home page will get stuck after logging in. If I log in to explore, it's fine, but I can't go to the home page.

@zeripath
Copy link
Contributor

Unfortunately it appears that the new indexes on the action table are bad for big SQLite DBs.

I've been able to correctly ascertain what they should be and will make a PR as soon as I have checked them on MySQL and other dbs.

zeripath added a commit to zeripath/gitea that referenced this issue Jun 27, 2022
@zeripath
Refix indices on actions table
427ecee 
Unforunately the previous PR go-gitea#20035 created indices that were not helpful
for SQLite. This PR adjusts these after testing using the try.gitea.io db.

Fix go-gitea#20129

Signed-off-by: Andrew Thornton <art27@cantab.net>
@zeripath zeripath mentioned this issue Jun 27, 2022
Merged
zeripath added a commit that referenced this issue Jul 1, 2022
@zeripath
Refix indices on actions table (#20158)
5c9c0b8 
Unforunately the previous PR #20035 created indices that were not helpful
for SQLite. This PR adjusts these after testing using the try.gitea.io db.

Fix #20129

Signed-off-by: Andrew Thornton <art27@cantab.net>
zeripath added a commit to zeripath/gitea that referenced this issue Jul 1, 2022
@zeripath
Refix indices on actions table (go-gitea#20158)
9417a90 
Backport go-gitea#20158

Unforunately the previous PR go-gitea#20035 created indices that were not helpful
for SQLite. This PR adjusts these after testing using the try.gitea.io db.

Fix go-gitea#20129

Signed-off-by: Andrew Thornton <art27@cantab.net>
@zeripath zeripath mentioned this issue Jul 1, 2022
Merged
6543 pushed a commit that referenced this issue Jul 2, 2022
@zeripath
Refix indices on actions table (#20158) (#20198)
e321b40 
Backport #20158

Unforunately the previous PR #20035 created indices that were not helpful
for SQLite. This PR adjusts these after testing using the try.gitea.io db.

Fix #20129

Signed-off-by: Andrew Thornton <art27@cantab.net>
vsysoev pushed a commit to IntegraSDL/gitea that referenced this issue Aug 10, 2022
@zeripath
Refix indices on actions table (go-gitea#20158)
cc21a19 
Unforunately the previous PR go-gitea#20035 created indices that were not helpful
for SQLite. This PR adjusts these after testing using the try.gitea.io db.

Fix go-gitea#20129

Signed-off-by: Andrew Thornton <art27@cantab.net>
@go-gitea go-gitea locked and limited conversation to collaborators May 3, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
type/bug
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Refix indices on actions table zeripath/gitea
4 participants
@lunny @tyroneyeh @devgogo @zeripath