We noticed that the database was slower to respond to queries the last few days.
This was caused by a specific query that is executed for quota calculation. This query took longer than normal (bad query plan) to get a result. MariaDB spent most of its CPU time on those queries.
We instructed MariaDB to re-analyze the relevant tables; this resulted in MariaDB using a better query plan and giving the expected performance for the query.
This unfortunately caused some not planned downtime.
Codeberg Status
npub1z0…mdh9p
2026-09-29 16:19:25 UTC
Author Public Key
npub1z0ase7phympjeflh9wqm6j3gyuwcftpu7udummcfnr49s5yf0p5qfmdh9pSeen on
wss://relay.momostr.pinkPublished at
2026-09-29 16:19:25 UTCEvent JSON
{
"id": "18702435c876fb9159b8d9b8881208d01a1f827d3007dee47231cdd962b75413",
"pubkey": "13fb0cf83726c32ca7f72b81bd4a28271d84ac3cf71bcdef0998ea5850897868",
"created_at": 1790698765,
"kind": 1,
"tags": [
[
"proxy",
"https://social.anoxinon.de/@codebergstatus/117355234306268886",
"web"
],
[
"proxy",
"https://social.anoxinon.de/ap/users/115651402898351746/statuses/117355234306268886",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://social.anoxinon.de/ap/users/115651402898351746/statuses/117355234306268886",
"pink.momostr"
],
[
"-"
]
],
"content": "We noticed that the database was slower to respond to queries the last few days.\n\nThis was caused by a specific query that is executed for quota calculation. This query took longer than normal (bad query plan) to get a result. MariaDB spent most of its CPU time on those queries.\n\nWe instructed MariaDB to re-analyze the relevant tables; this resulted in MariaDB using a better query plan and giving the expected performance for the query.\n\nThis unfortunately caused some not planned downtime.",
"sig": "fe5b02510299d341e6601ee871417a053df69f934418ccdc88b2cf52100244e1ce8f220fa654c25d3d37fe435cbbc97a4677fc85bd4d0e740f01304309b17503"
}