Conversation

Notices

1. Embed this notice
   LIBRANET.de Announcements (libranet@mastodon.social)'s status on Monday, 01-Jul-2024 22:42:50 JST LIBRANET.de Announcements

   The Friendica nodes libranet.de and venera.social are currently in maintenance mode. There is an update for the database structure. This has now been running for 26 hours. There is nothing I can do except waiting until it is completed. Sorry for the long service interruption.

   • clacke@libranet.de is my main repeated this.
   • Embed this notice
     LIBRANET.de Announcements (libranet@mastodon.social)'s status on Saturday, 06-Jul-2024 19:19:32 JST LIBRANET.de Announcements

     in reply to

     I found out that ALTER TABLE statements on MySQL/MariaDB can be very, very slow when the query is executed on very large tables with many indices. The post-user table (that's the one that is responsible for the long running update) is huge. The table has a size of 140 GB and has 36 indices.

   • Embed this notice
     LIBRANET.de Announcements (libranet@mastodon.social)'s status on Saturday, 06-Jul-2024 19:19:33 JST LIBRANET.de Announcements

     in reply to

     Update: The database structure update on venera.social is finally done. This node is up and running again. Unfortunately, the structure update on libranet.de isn't completed yet. I can't say how long this will take. The process is painfully slow. I'm very sorry about the terrible situation. But all I can do is waiting until the database update is completed.

     clacke@libranet.de is my main repeated this.