Comment on Hi. Since last update of # PHP8.4 , I'm struggling with poor # perfo
tobias@social.diekershoff.de 3 weeks ago
@lassegismo not DB related, but I remembered that I had once performance issues when I had a unclean PHP setup with php8.0-fpm and php8.2-fpm (or something like that) running on my raspi and I was all the time optimizing the pool that was not in use for some reason.
How large is you DB in file size? It needs to be managed in RAM next to PHP and the other things running. I am kind of aggressive deleting uninteresting / unclaimed content on my node.
lassegismo@lassegismo-social.dnsuser.info 3 weeks ago
It's currently 9 GB, and I delete everything older than 30 days, except for my posts.
tobias@social.diekershoff.de 2 weeks ago
@lassegismo with "unclaimed items" (stuff that is arriving via relay servers) I am deleting those after 1 day, but rest should be fine.
Do you have the rendertime addon on? How long is the time for the "Database" section?
The "mysql tuner" perl script / tool can give some hinds of what to enhance with the mysql settings. With mytop you can see if there are long running tasks on the DB (that should also be logged but at the moment I don't remember how to do that 😅). Which might help to identify the bottleneck.