Skip to main content
!Friendica Support Very very slow. My #Friendica instance is very very slow - it is a private instance with only one active account, running about 8 months. There must be a severe problem with the database - it is not really big (as I learned yesterday)

Calling the "network" page:
Datenbank: 36.89/0, Netzwerk: 0, Darstellung: 0.94, Sitzung: 0, I/O: 0.02, Sonstiges: 0.1, Gesamt: 37.94
#friendica
Tin
btw
Friendica 'Yellow Archangel' 2024.03-dev - 154
php version 8.0.30
mysql Ver 15.1 Distrib 10.6.16-MariaDB
Michael Vogel
Your database is slow. I guess you have to assign more memory for it. Use mysqltuner.pl to get a hint for the parameters and then have a quick look at these parameters in the documentation, since you never should simply copy the suggested values from that script.
Tin
@Michael Vogel What do you see in here?
https://put.fedcast.ch/r75l1r5q
Michael Vogel
See here:
MEMORY USAGE
Max Memory Ever Allocated : 418 M
Configured Max Per-thread Buffers : 5.68 G
Configured Max Global Buffers : 273 M
Configured Max Memory Limit : 5.95 G
Physical Memory : 15.50 G


It looks like you can allocate a lot more memory.
Michael Vogel
I guerss* you could increase innodb_buffer_pool_size **a lot. And at the same time you should decrease max_connections, since 2000 is much too high. I guess 100 should be enough.
Tin
@Michael Vogel I disabled "automatically optimize tables in database". How to run this process manually?
Michael Vogel
Why have you deactivated this? This is only needed, if you have got problems while creating backups.
Tin
@Michael Vogel Sorry, still my question: How to start table optimising manually?
Tin
@Michael Vogel Yes, this one I know - I thought there is a possibility out of the admin panel for all tables...
Michael Vogel
Not from the admin panel.
Tin
Well, the "ADD RAM" is quite difficult on this server...
⇧