Closed
Description
Description
Our current DELETE query for actions is rather inefficient on MariaDB:
DELETE FROM action WHERE comment_id IN (SELECT id FROM comment WHERE issue_id=?)
gitea/models/activities/action.go
Lines 688 to 702 in ab388de
Caused by https://jira.mariadb.org/browse/MDEV-16289
see https://codeberg.org/forgejo/forgejo/issues/1161 and https://codeberg.org/forgejo/forgejo/pulls/1165
Gitea Version
1.20.2
Can you reproduce the bug on the Gitea demo site?
Yes
Log Gist
No response
Screenshots
No response
Git Version
No response
Operating System
No response
How are you running Gitea?
Binary started via systemd behind a caddy reverse proxy.
Database
None