Skip to main content

some pages are slow

Hello !Friendica Support ..

I don't know what page load times others have, just experience slow responses on my instance. A nice time woud be < 1 second, maybe.

I have some pages that are significantly slower:

- the statistics in admin (loong time, didn't measure)
- network page: 13s
- my profile page: 39s
- friendica support page: 47s
- admin page: 2s

so simetimes slower, sometimes a bit faster. but it currently frustrates me a bit. it is not a joy to use.

I am the only user on my instance and it is running on the "S" model here: https://php-friends.de/vserver-ssd

!Friendica Support
Schmaker
Schmaker  
•

That's definitely not normal (except for admin statistics, these are actually slow. I'm also single-user instance and I don't have issues like these.

Tried to check your instance and it takes hell of a time to load, there is something fishy going on on your server.Aren't you "bombarded" by activitypub trolls or something? (check your worker queue)

xy..
xy..  
•
Thanks for your answer. The worker queue is not very full. maybe <100 entries or so.. I thought maybe, because I use categories on my profile.. but why the network is slow then. strange
Schmaker
Schmaker  
•
@xy.. I also use categories without any issues. I would check if there aren't any CPU load spikes on some process (I can imagine for example database being slow for some reason)
@xy..
xy..
xy..  
•
what I often see, are these messages:
2023-11-21T02:33:50Z worker [ALERT]: Fatal Error (E_ERROR): Allowed memory size of 536870912 bytes exhausted (tried to allocate 96485376 bytes) {"code":1,"message":"Allowed memory size of 536870912 bytes exhausted (tried to allocate 96485376 bytes)","file":"/var/www/localhost/friendica/src/Database/Database.php","line":568,"trace":null} - {"file":null,"line":null,"function":null,"request-id":"655c16e7cbedf","stack":"ErrorHandler::handleFatalError","uid":"52404b","process_id":29538}

2023-11-21T02:39:21Z worker [ALERT]: Fatal Error (E_ERROR): gd-webp cannot allocate temporary buffer {"code":1,"message":"gd-webp cannot allocate temporary buffer","file":"/var/www/localhost/friendica/src/Object/Image.php","line":171,"trace":null} - {"file":null,"line":null,"function":null,"request-id":"655c185668e5e","stack":"ErrorHandler::handleFatalError","uid":"343130","process_id":29745}

but I have already opened an issue on github: https://github.com/friendica/friendica/issues/12777
xy..
xy..  
•
and in mytop there is a point slow: 225.0 . I don't know what exactly it means but its a high number (?) slow queries somehow
xy..
xy..  
•
example for what I believe is a slow query:
9138   amical       localhost    amical  230.6   0.0  Query    Sending data SELECT `id`, `url`, `nurl`, `network`, `poco`, `directory-type` FROM `gserver` WHERE (NOT `blocked` AND NOT `failed` AND `directory-type` != 0 AND `last_p

maybe someone knows what that is
xy..
xy..  
•
I often see "gserver" there in mytop
10198   amical       localhost    amical  225.8   0.0  Query    Sending data SELECT `url`, `nurl` FROM `gserver` WHERE (NOT `blocked` AND `next_contact` < '2023-11-21 17

10302   amical       localhost    amical  156.3   0.0  Query    Sending data SELECT `id`, `url`, `nurl`, `network`, `poco`, `directory-type` FROM `gserver` WHERE (NOT `b
xy..
xy..  
•
currently it's a bit faster, I have done a mysqlcheck and restartet mariadb.
Schmaker
Schmaker  
•
I don't see a difference. On my instance profile loads instantly (1-2 sec), on your site it was like 30 sec or so
xy..
xy..  
•
I hope that maybe some developer joins the thread . maybe its something with the database. I don't know
Michael 🇺🇦
Michael 🇺🇦  
•

Activate the rendertime addon:

Then you will see data like this:

xy..
xy..  
•
@Michael Vogel I think you missed my answer, because I have again answered false, not directly @ you..
Can you please have a look? below this comment
@Michael 🇺🇦
xy..
xy..  
•
Michael 🇺🇦
Michael 🇺🇦  
•
Okay, so the problem is the database server. You can add these lines to the config to exactly see the slow queries:
		'db_log' => '/path/to/logs/friendica-db.log',
		'db_loglimit' => 2,
		'db_callstack' => true,

You will have to have a look at your database server configuration. Possibly you can assign more memory to the database server. Please have got a look at some guides out there in the internet concerning database performance improvements.
xy..
xy..  
•
@Michael Vogel .. my mariadb is in fact completely on default values. I haven't changed anything. Now I have started and set innodb_buffer_pool_size to 6G (from the 128M default)
@Michael 🇺🇦
xy..
xy..  
•
@Michael 🇺🇦
⇧