Conversation

Notices

1. Embed this notice
   heluecht (heluecht@pirati.ca)'s status on Thursday, 10-Nov-2022 02:44:30 JST heluecht

   in reply to

   • alfred
   • heluecht
   • Friendica Support
   @alfred Yeah, I took a shortcut.
   • Steffen K9 ? likes this.
   • Embed this notice
     alfred (alfred@libranet.de)'s status on Thursday, 10-Nov-2022 02:44:31 JST alfred

     in reply to

     • alfred
     • Friendica Support
     @heluecht Looks like the latest dbstructure change fixed the problem. I checked the public timelines with Tusky. They are loaded very fast now and that infinitely running query doesn't appear in the process list.
   • Embed this notice
     alfred (alfred@libranet.de)'s status on Thursday, 10-Nov-2022 02:44:32 JST alfred

     • Friendica Support
     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.
     
     Thank you.