@liaizon@hypolite Well, it would be an honor. ☺️ But isn't friendica@libranet.de some default system actor? That name is configured at admin > site > general > name of the system actor. I'm not sure what happens when I change that name and use 'friendica' as a regular nickname instead. ?
Also, maybe it would be better to set up such an account on forum.friendi.ca. What do you think?
When I click on a forum in the forums widget it takes a lot of time until the content is loaded and displayed. Sometimes it takes one minute and sometimes upt to three or four minutes.
Loading additional posts with infinite scroll enabled is very fast on the other hand. The normal network feed is loading pretty fast, too.
The query is very slow. ? Yes. I'm sorry @heluecht it's me and my DB again. ?
Is it just my node or do others experience the same?
The query: # Time: 221216 17:00:42 # Query_time: 65.951453 Lock_time: 0.000055 Rows_sent: 20 Rows_examined: 37489 # Rows_affected: 0 Bytes_sent: 0 # Tmp_tables: 2 Tmp_disk_tables: 0 Tmp_table_sizes: 253976# Full_scan: No Full_join: No Tmp_table: Yes Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No use friendica; SET timestamp=1671210042; SELECT * FROM `network-thread-view` WHERE (`uid` = 2 AND ((`contact-id` = '2047239') OR `uri-id` IN (SELECT `parent-uri-id` FROM `post-user-view` WHERE (`contact-id` = '2047239' AND `gravity` = 3 AND `vid` = 7 AND `uid` = 2)))) ORDER BY `received` DESC LIMIT 20;
That relay was running very smoothly until recently. But it looks like that the amount of data from/to some connected Mastodon instances is currently a burden for that rather small VPS.
I need to investigate this and find a solution before I can lift the ban again.
Hello I have a super slow DB query again. ? There are up to 30 of these queries running at the same time and they're running for hours. In fact I have to kill them after 6-8 hours because they are producing an incredible high load on the system.
SELECT `uri-id` FROM `post-view` WHERE (`gravity` IN (0, 6) AND `private` = 0 AND `network` IN ('dfrn', 'dspr', 'stat', 'apub') AND `parent-author-blocked` = 0 AND `parent-author-hidden` = 0 AND `visible` AND NOT `deleted` AND NOT `author-blocked` AND NOT `owner-blocked` AND (NOT `causer-blocked` OR `causer-id` = 0 OR `causer-id` IS NULL) AND NOT `contact-blocked` AND ((NOT `contact-readonly` AND NOT `contact-pending` AND (`contact-rel` IN (2, 3))) OR `self` OR `gravity` != 0 OR `contact-uid` = 0) AND NOT `post-view`.`uri-id` IN (SELECT `uri-id` ... ... (truncated) Line is truncated because it doesn't fit into my terminal window. ?
Maybe @heluecht has an idea what that query is doing and why it is so slow.
Operator of LIBRANET.de, venera.social and misskey.de, #Fediverse enthusiast, #Coffee addict. I like #Music #Cycling #Relaxing #ScienceFiction #Linux #Nextcloud #Friendica #Misskey and you! 😀