Conversation

Notices

1. nullkal ? (nullkal@mstdn.jp)'s status on Saturday, 08-Sep-2018 07:24:14 JST nullkal ?

   • せのお (妹尾 賢)

   Migration of Mastoson 2.4.4→2.5.0 took about 3 days and mstdn.jp kept returning errors about a half day... I don't want to do it again...

   • monaca :nikukyu:, まめも❄️ and :wa: :se: :ta: :nn: and 7 others repeated this.
   • Eugen (gargron@mastodon.social)'s status on Saturday, 08-Sep-2018 07:25:34 JST Eugen

     in reply to

     • せのお (妹尾 賢)

     @nullkal Sorry ?

     :wa: :se: :ta: :nn: and ぽぷんじゃ@pptdn管理人 repeated this.
   • nullkal ? (nullkal@mstdn.jp)'s status on Saturday, 08-Sep-2018 07:28:14 JST nullkal ?

     in reply to

     • せのお (妹尾 賢)
     • Eugen

     @Gargron I found `find_in_batches` get slower as the migration is proceeding. Maybe it tooks O(n) for query?

   • Eugen (gargron@mastodon.social)'s status on Saturday, 08-Sep-2018 07:29:01 JST Eugen

     in reply to

     • せのお (妹尾 賢)

     @nullkal Weird. It only took 3 hours on mastodon.social.

   • シジMIX (shijimi@gorone.club)'s status on Saturday, 08-Sep-2018 07:29:28 JST シジMIX

     in reply to

     • せのお (妹尾 賢)

     @nullkal
     We appreciate your great work!

   • nullkal ? (nullkal@mstdn.jp)'s status on Saturday, 08-Sep-2018 07:32:38 JST nullkal ?

     in reply to

     • せのお (妹尾 賢)
     • Eugen

     @Gargron mstdn.jp has 120 million toots in `statuses` table. How many toots does mastodon.social have?

     xanac repeated this.
   • Eugen (gargron@mastodon.social)'s status on Saturday, 08-Sep-2018 07:33:24 JST Eugen

     in reply to

     • せのお (妹尾 賢)

     @nullkal I don't have a count but that table is 45.5 GB large

     nullkal ? and xanac repeated this.
   • nullkal ? (nullkal@mstdn.jp)'s status on Saturday, 08-Sep-2018 07:37:26 JST nullkal ?

     in reply to

     • せのお (妹尾 賢)
     • Eugen

     @Gargron Maybe status stats' size is helpful for approximate the number of toots? mstdn.jp's statuses table is 36.6GB, and status_stats table is 9.87GB.

     xanac repeated this.
   • b (imbsky@knzk.me)'s status on Saturday, 08-Sep-2018 07:44:43 JST b

     in reply to

     @nullkal rip

   • b (imbsky@knzk.me)'s status on Saturday, 08-Sep-2018 07:47:02 JST b

     in reply to

     • Eugen

     @Gargron @nullkal it was done in 30 minutes on mastodon.cloud

   • b (imbsky@knzk.me)'s status on Saturday, 08-Sep-2018 07:54:21 JST b

     in reply to

     • Eugen

     @Gargron @nullkal yeah little weird
     it was done in 30 minutes on mastodon.cloud