The Prancing Pony In(n) | Display

friendica - Link to source

Schmaker via Friendica Support

1 week ago • •

Schmaker
1 week ago • •

!Friendica Support
Hi guys. So far I'm quite often getting table locked and can't interact for minutes.

Can somebody explain me what's happening? I think it's the first query that's causing the issue

MariaDB processlist

MariaDB [(none)]> show processlist;
+--------+-----------+-----------+-----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id     | User      | Host      | db        | Command | Time | State                           | Info                                                                                                 | Progress |
+--------+-----------+-----------+-----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+--

... show more

!Friendica Support
Hi guys. So far I'm quite often getting table locked and can't interact for minutes.

Can somebody explain me what's happening? I think it's the first query that's causing the issue

MariaDB processlist

MariaDB [(none)]> show processlist;
+--------+-----------+-----------+-----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id     | User      | Host      | db        | Command | Time | State                           | Info                                                                                                 | Progress |
+--------+-----------+-----------+-----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
| 118178 | friendica | localhost | friendica | Query   |  580 | Sending data                    | SELECT `id` FROM `item-uri` WHERE (`id` < 12098300 AND NOT EXISTS(SELECT `uri-id` FROM `post-user` W |    0.000 |
| 122966 | friendica | localhost | friendica | Query   |  577 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('tag:mastodonczech.cz,2025-04-05:objectId=24551028:obj |    0.000 |
| 123368 | friendica | localhost | friendica | Query   |   96 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://cum.camp/users/shitpisscum')                  |    0.000 |
| 123374 | friendica | localhost | friendica | Query   |  578 | Waiting for table metadata lock | OPTIMIZE TABLE `post-delivery`                                                                       |    0.000 |
| 123376 | friendica | localhost | friendica | Query   |  578 | Waiting for table metadata lock | DELETE FROM `post-delivery` WHERE (`uri-id` = 12110298 AND `inbox-id` = 555134)                      |    0.000 |
| 123414 | friendica | localhost | friendica | Query   |  578 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://societas.online/objects/ae8a63f0f4110 |    0.000 |
| 123416 | friendica | localhost | friendica | Query   |  576 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- |    0.000 |
| 123423 | friendica | localhost | friendica | Query   |  577 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://diaspora.psyco.fr/objects/af4fc4f0f41 |    0.000 |
| 123430 | friendica | localhost | friendica | Query   |  574 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.arch-linux.cz/users/Erebos/s |    0.000 |
| 123431 | friendica | localhost | friendica | Query   |  572 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 |    0.000 |
| 123432 | friendica | localhost | friendica | Query   |  569 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodonczech.cz/users/365tipu/status |    0.000 |
| 123435 | friendica | localhost | friendica | Query   |  566 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha')            |    0.000 |
| 123441 | friendica | localhost | friendica | Query   |  536 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 |    0.000 |
| 123445 | friendica | localhost | friendica | Query   |  532 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha')            |    0.000 |
| 123446 | friendica | localhost | friendica | Query   |  531 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.social/users/FrancoisPrague/ |    0.000 |
| 123456 | friendica | localhost | friendica | Query   |  528 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodonczech.cz/users/Zvedatori/stat |    0.000 |
| 123457 | friendica | localhost | friendica | Query   |  527 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://qoto.org/users/justcbdstorea')                |    0.000 |
| 123463 | friendica | localhost | friendica | Query   |  503 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 |    0.000 |
| 123464 | friendica | localhost | friendica | Query   |  503 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha')            |    0.000 |
| 123466 | friendica | localhost | friendica | Query   |  498 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 |    0.000 |
| 123468 | friendica | localhost | friendica | Query   |  493 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://imaginair.es/users/ELeGarben')                |    0.000 |
| 123485 | friendica | localhost | friendica | Query   |  462 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 |    0.000 |
| 123486 | friendica | localhost | friendica | Query   |  455 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.online/users/Psychonaut/stat |    0.000 |
| 123498 | friendica | localhost | friendica | Query   |  451 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- |    0.000 |
| 123509 | friendica | localhost | friendica | Query   |  444 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha')            |    0.000 |
| 123510 | friendica | localhost | friendica | Query   |  443 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 |    0.000 |
| 123525 | friendica | localhost | friendica | Query   |  420 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 |    0.000 |
| 123532 | friendica | localhost | friendica | Query   |  389 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990', ' |    0.000 |
| 123540 | friendica | localhost | friendica | Query   |  358 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990', ' |    0.000 |
| 123541 | friendica | localhost | friendica | Query   |  354 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 |    0.000 |
| 123560 | friendica | localhost | friendica | Query   |  326 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 |    0.000 |
| 123561 | friendica | localhost | friendica | Query   |  325 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- |    0.000 |
| 123565 | friendica | localhost | friendica | Query   |  314 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990', ' |    0.000 |
| 123581 | friendica | localhost | friendica | Query   |  289 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz')                  |    0.000 |
| 123583 | friendica | localhost | friendica | Query   |  285 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://societas.online/objects/ae8a63f0f4110 |    0.000 |
| 123586 | friendica | localhost | friendica | Query   |  275 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha')            |    0.000 |
| 123589 | friendica | localhost | friendica | Query   |  258 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://diaspora.psyco.fr/objects/af4fc4f0f41 |    0.000 |
| 123590 | friendica | localhost | friendica | Query   |  255 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990', ' |    0.000 |
| 123594 | friendica | localhost | friendica | Query   |  233 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 |    0.000 |
| 123597 | friendica | localhost | friendica | Query   |  223 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz')                  |    0.000 |
| 123603 | friendica | localhost | friendica | Query   |  198 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- |    0.000 |
| 123604 | friendica | localhost | friendica | Query   |  190 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz')                  |    0.000 |
| 123615 | friendica | localhost | friendica | Query   |  133 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz')                  |    0.000 |
| 123617 | friendica | localhost | friendica | Query   |  126 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://qoto.org/users/justcbdstorea')                |    0.000 |
| 123620 | friendica | localhost | friendica | Query   |  104 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990', ' |    0.000 |
| 123625 | friendica | localhost | friendica | Query   |   82 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://noc.social/users/ThatAltair')                 |    0.000 |
| 123627 | friendica | localhost | friendica | Query   |   71 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- |    0.000 |
| 123636 | friendica | localhost | friendica | Query   |   43 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://schmaker.eu/objects/c83e3896-1167-f0c |    0.000 |
| 123642 | root      | localhost | NULL      | Query   |    0 | starting                        | show processlist                                                                                     |    0.000 |
+--------+-----------+-----------+-----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+

!Friendica Support

in reply to Schmaker

friendica (DFRN) - Link to source

Ⓜ3️⃣3️⃣ 🌌

in reply to Schmaker • 1 week ago •

There was a post on Friendica's matrix channel that helped me quite a lot about database performance. That plus php-fpm tunning is really needed as default settings are obsolete or at least doesn't scale well.
Can't find the original post, see at the end of this updated 50-server.cnf file : codeberg.org/m33/Friendica-cad…

Friendica Support reshared this.

in reply to Ⓜ3️⃣3️⃣ 🌌

friendica - Link to source

Schmaker

in reply to Ⓜ3️⃣3️⃣ 🌌 • 1 week ago • •

I'll check it out. Thanks for showing a direction

in reply to Schmaker

friendica - Link to source

Jerry on Friendica

in reply to Schmaker • 1 week ago • •

It's probably this. It's killing performance on my server as well: github.com/friendica/friendica…

in reply to Jerry on Friendica

friendica - Link to source

Schmaker

in reply to Jerry on Friendica • 1 week ago • •

So guess I'm not the only one affected and it will be fixed in next release.

Fair enough, works for me.

Thank you

⇧