Conversation:

Notices

1. ⒿⓅⓄⓅⒺ (jpope)'s status on Wednesday, 29-May-2013 15:45:49 EDT ⒿⓅⓄⓅⒺ

   Remote profile options...
   After the identi.ca migration, I will move to my new SN instance. My webfinger will be jpope@sn.jpope.org
   • Joshua Judson Rosen likes this.
   • Joshua Judson Rosen (rozzin)'s status on Thursday, 30-May-2013 21:37:31 EDT Joshua Judson Rosen

     • ⒿⓅⓄⓅⒺ
     Cripes, @jpope—I really hope you don't start a trend. A StatusNet site-shutdown/`reboot' wave across the federation would *suck*.
   • ⒿⓅⓄⓅⒺ (jpope)'s status on Thursday, 30-May-2013 21:51:50 EDT ⒿⓅⓄⓅⒺ

     Remote profile options...

     • Joshua Judson Rosen
     @rozzin Maybe so. I just want to see less resources being used on my old gateway. This instance is holding over 1,000,000 notices. Starting fresh will clear that bulk plus stop the pushing to non-existant instances. ;)
   • jk (jk)'s status on Thursday, 30-May-2013 22:14:53 EDT jk

     Remote profile options...

     • ⒿⓅⓄⓅⒺ
     @jpope you should just delete a bunch of the old messages. delete everything but the last 4 months or so.
   • ⒿⓅⓄⓅⒺ (jpope)'s status on Thursday, 30-May-2013 23:14:06 EDT ⒿⓅⓄⓅⒺ

     Remote profile options...

     • jk
     @jk That wouldn’t help anything. Innodb does not give back the space it takes. If I delete notices, the db size will not shrink.
   • Joshua Judson Rosen (rozzin)'s status on Friday, 31-May-2013 11:53:02 EDT Joshua Judson Rosen

     • ⒿⓅⓄⓅⒺ
     @jpope, is this what you want? http://lists.mysql.com/mysql/152344
   • Joshua Judson Rosen (rozzin)'s status on Friday, 31-May-2013 11:56:56 EDT Joshua Judson Rosen

     • ⒿⓅⓄⓅⒺ
     @jpope, I'm more of a #PostgreSQL guy, but it looks like #MySQL has "ALTER TABLE tbl_name ENGINE=INNODB" as an analog to Postgres' "VACUUM FULL", which releases disk-space to the OS.
   • Joshua Judson Rosen (rozzin)'s status on Friday, 31-May-2013 11:59:49 EDT Joshua Judson Rosen

     • ⒿⓅⓄⓅⒺ
     @jpope, how much space does 1 million ~140-char messages actually take up after all the DB overhead? More than 140 MB, I guess?
   • ⒿⓅⓄⓅⒺ (jpope)'s status on Friday, 31-May-2013 13:20:05 EDT ⒿⓅⓄⓅⒺ

     Remote profile options...

     • Joshua Judson Rosen
     @rozzin My innodb buffer is at 1.2GB…
   • ⒿⓅⓄⓅⒺ (jpope)'s status on Friday, 31-May-2013 13:23:35 EDT ⒿⓅⓄⓅⒺ

     Remote profile options...

     • Joshua Judson Rosen
     @rozzin An ALTER TABLE statement doesn’t give back anything for innodb as far as I know. I’ve tried that one before actually. ;)
   • marjoleink (marjoleink)'s status on Friday, 31-May-2013 13:34:30 EDT marjoleink

     Remote profile options...
     @jpope maybe some clues here: http://is.gd/psQMuA
   • Joshua Judson Rosen (rozzin)'s status on Friday, 31-May-2013 14:17:04 EDT Joshua Judson Rosen

     • marjoleink
     Cheezus. Fucking #MySQL.
   • marjoleink (marjoleink)'s status on Friday, 31-May-2013 14:21:06 EDT marjoleink

     Remote profile options...

     • Joshua Judson Rosen
     Fucking InnoDB, rather ;)
   • ⒿⓅⓄⓅⒺ (jpope)'s status on Friday, 31-May-2013 18:03:31 EDT ⒿⓅⓄⓅⒺ

     Remote profile options...

     • marjoleink
     @marjoleink I can’t get the is.gd link to open.. :(