Conversation

Notices

1. Mikael (mikael@social.umeahackerspace.se)'s status on Tuesday, 08-Nov-2016 04:59:23 UTC Mikael

   • Christmas Personified as a Catgirl
   • Annah
   @moonman @maiyannah is queue_item ever cleaned in gnusocial? Its a table with blobs in it and dbs usually tips over with blobs. The processed items have a timestamp instead of null.
   • Claes Wallin (韋嘉誠) repeated this.
   • Annah (maiyannah@community.highlandarrow.com)'s status on Tuesday, 08-Nov-2016 05:00:50 UTC Annah

     in reply to

     • Christmas Personified as a Catgirl
     @mikael @moonman Upgrade.php cleans it.  I'm not sure if anything in normal operation does however.  I know that the TwitterBridge plugin fucks servers up by filling the queue_item table up until the server explodes, though
     Claes Wallin (韋嘉誠) repeated this.
   • Christmas Personified as a Catgirl (moonman@shitposter.club)'s status on Tuesday, 08-Nov-2016 05:05:01 UTC Christmas Personified as a Catgirl

     in reply to

     • Annah
     @maiyannah @mikael I have an offsite backup process (currently broken because the db craps on mysqldump saying a table changed, partway through) but I am gonna set up a cron to run some of these jobs on a nightly basis.
     Claes Wallin (韋嘉誠) repeated this.
   • Annah (maiyannah@community.highlandarrow.com)'s status on Tuesday, 08-Nov-2016 05:06:52 UTC Annah

     in reply to

     • Christmas Personified as a Catgirl
     @moonman @mikael I run /scrips/upgrade.php and the one to clean up the file table nightly prior to my backup process
     Claes Wallin (韋嘉誠) repeated this.
   • Christmas Personified as a Catgirl (moonman@shitposter.club)'s status on Tuesday, 08-Nov-2016 05:07:53 UTC Christmas Personified as a Catgirl

     in reply to

     • Annah
     @maiyannah @mikael For backup I guess I am gonna set up replication on a remote machine and do the mysqldump from there.
     Claes Wallin (韋嘉誠) repeated this.
   • Claes Wallin (韋嘉誠) (clackemovedtoheldscalla@quitter.se)'s status on Tuesday, 08-Nov-2016 05:37:36 UTC Claes Wallin (韋嘉誠)

     in reply to

     • Christmas Personified as a Catgirl
     • Annah
     @moonman @mikael @maiyannah I understand that's the official best practice for backing up a live MySQL db.
   • MMN-o ✅⃠ (mmn@social.umeahackerspace.se)'s status on Tuesday, 08-Nov-2016 06:48:29 UTC MMN-o ✅⃠

     in reply to
     @mikael processed items get removed. If they are still there you failed to delete it or it crashed before completion