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 !Friendica Support
Tin
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
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
Tin  
•
@Michael Vogel What do you see in here?
https://put.fedcast.ch/r75l1r5q
@Michael Vogel
Michael Vogel
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
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
Tin  
•
@Michael Vogel I disabled "automatically optimize tables in database". How to run this process manually?
@Michael Vogel
Michael Vogel
Michael Vogel  
•
Why have you deactivated this? This is only needed, if you have got problems while creating backups.
Tin
Tin  
•

@Michael Vogel
See the thread yesterday 😄
https://fedica.ch/display/6ad7505f-8965-b2a8-b993-b3b525177450

Tin

2024-01-25 18:30:17


!Friendica Support Mein Provider meldet sich u.a. auch wegen zu grosser Datenbank. Diese Friendica Instanz ist 8 Monate alt, hat einen aktiven User mit ca, 100 Kontakten. Die Haltezeit der Posts ist auf 90 Tage gesetzt. Die Datenbank ist 3.4 GB gross. Bug or Feature?

@Michael Vogel
Tin
Tin  
•
@Michael Vogel Sorry, still my question: How to start table optimising manually?
@Michael Vogel
Tin
Tin  
•
@Michael Vogel Yes, this one I know - I thought there is a possibility out of the admin panel for all tables...
@Michael Vogel
Michael Vogel
Michael Vogel  
•
Not from the admin panel.
Tin
Tin  
•
Well, the "ADD RAM" is quite difficult on this server...
⇧