Post A37t34W7FtxmbOsjVQ by utzer@social.yl.ms
 (DIR) More posts by utzer@social.yl.ms
 (DIR) Post #A37oXHOtQ5txTb5WNc by admin@friendica.utzer.de
       2021-01-11T10:11:25Z
       
       0 likes, 0 repeats
       
       I deleted about 90 users, which gave me 180000 tasks in the queue. Didn't think about that before, but that will take a few hours now. @helpers #Friendica
       
 (DIR) Post #A37oXIAkYABNs1TjyS by heluecht@pirati.ca
       2021-01-11T10:28:03Z
       
       0 likes, 0 repeats
       
       If there are a lot of deffered posts, then you can decrease that with the configuration value "worker_defer_limit". I had set it to 6 on squeet.me.Which kind of jobs are there the most?
       
 (DIR) Post #A37q3735XhPialdG8O by heluecht@pirati.ca
       2021-01-11T10:45:06Z
       
       0 likes, 0 repeats
       
       Please execute: select command,count(*) from workerqueue where not done group by command;
       
 (DIR) Post #A37qcaWtvQruA1UcOu by utzer@social.yl.ms
       2021-01-11T10:47:33Z
       
       0 likes, 0 repeats
       
       @heluecht let me ask about this, is this "worker_defer_limit" about the first number in /admin (above 1284 in the picture)? What I would like is to make the server more usable for the users on it, so the "every day" things should work faster, like delivery of posts and fetching of posts.
       
 (DIR) Post #A37qcbJT0riUaeDP6G by heluecht@pirati.ca
       2021-01-11T10:50:43Z
       
       0 likes, 0 repeats
       
       Well, your system should have no problems with the "every day" work, since the masses of tasks are having priority 50.
       
 (DIR) Post #A37r0aokVTHy0HHso4 by utzer@social.yl.ms
       2021-01-11T10:48:42Z
       
       0 likes, 0 repeats
       
       @heluecht hmmm I think I see where this is going to. +-------------------------+----------+| command                 | count(*) |+-------------------------+----------+| APDelivery              |   294421 || CleanWorkerQueue        |        1 || ClearCache              |        1 || ContactDiscovery        |        9 || Delivery                |      749 || ForkHook                |        3 || Notifier                |       18 || PostUpdate              |        1 || PullDirectory           |        1 || RemoveUser              |       86 || SpoolPost               |        1 || UpdateContact           |      527 || UpdateContacts          |        1 || UpdateGServers          |        1 || UpdateServerDirectories |        1 |+-------------------------+----------+15 rows in set (0.756 sec)
       
 (DIR) Post #A37r0bHSmiG1RKioYy by heluecht@pirati.ca
       2021-01-11T10:55:51Z
       
       0 likes, 0 repeats
       
       Then execute this one: select command,substr(parameter, 3, locate('"', parameter, 3)-3) as para, priority, count(*) from workerqueue where command = 'apdelivery' and not done group by para,priority;
       
 (DIR) Post #A37t34W7FtxmbOsjVQ by utzer@social.yl.ms
       2021-01-11T10:58:44Z
       
       0 likes, 0 repeats
       
       @heluecht select command,substr(parameter, 3, locate('"', parameter, 3)-3) as para, priority, count(*) from workerqueue where command = 'apdelivery' and not done group by para,priority;+------------+----------+----------+----------+| command    | para     | priority | count(*) |+------------+----------+----------+----------+| APDelivery | removeme |       50 |   319020 || APDelivery | wall-new |       20 |       10 || APDelivery | wall-new |       40 |        3 || APDelivery | wall-new |       50 |       38 |+------------+----------+----------+----------+4 rows in set (1.486 sec)
       
 (DIR) Post #A37t379tQyyAnLVWme by heluecht@pirati.ca
       2021-01-11T11:18:20Z
       
       0 likes, 0 repeats
       
       Okay. Some user removed their account. This will trigger this "removeme". But it shouldn't create that much jobs. I have to check. I will try to have a look at it in the evening.