Schmaker (nprofile…d8lr) There was a post on Friendica's matrix channel that helped me quite a lot about database performance. That plus php-fpm tunning is really needed as default settings are obsolete or at least doesn't scale well.
Can't find the original post, see at the end of this updated 50-server.cnf file : codeberg.org/m33/Friendica-cad…
Ⓜ3️⃣3️⃣ 🌌 /
npub1qx…cyqs8
2025-04-05 07:28:17
in reply to nevent1q…dzjt
Author Public Key
npub1qxjvvgw63adlww80hrquwwklj93070pne4zv4leafhh4aw5mfy2q8cyqs8Seen on
wss://relay.nostr.bandPublished at
2025-04-05 07:28:17Event JSON
{
"id": "8651294e260169473e8eb7969da99f2f514499e66af0638371ade47ed0a9e60f",
"pubkey": "01a4c621da8f5bf738efb8c1c73adf9162ff3c33cd44caff3d4def5eba9b4914",
"created_at": 1743838097,
"kind": 1,
"tags": [
[
"p",
"ba8dc5313fc926e9d00e9cde9cf1a46c114d75b1951e398dfc854d8c2ddc1014",
"wss://relay.mostr.pub"
],
[
"p",
"15b7758904cd6ec9c4d780aed7cca01019b61be45945dea8a68e2d2322a45ecd",
"wss://relay.mostr.pub"
],
[
"e",
"e97ddfbbc3b4f0a9e879a2cc3f952397416391e214856f0530c7c8851cb90d26",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://theprancingpony.in/objects/883cc655-2067-f0db-9198-caa579112067",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.mostr.pub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqh2xu2vfleynwn5qwnn0feudydsg56ad3j50rnr0us4xcctwuzq2q8rd8lr There was a post on Friendica's matrix channel that helped me quite a lot about database performance. That plus php-fpm tunning is really needed as default settings are obsolete or at least doesn't scale well.\nCan't find the original post, see at the end of this updated 50-server.cnf file : codeberg.org/m33/Friendica-cad…",
"sig": "d54782e45e915cb0acbd09178bf5aa6f77e96519f21a5fa72b48d77d0ba9e2ac9bb5483cf6bd60447f93714c6149681f41e188ccec12c22d1c0e42ec2eb17f64"
}