Re: diffviewer_filediffdata table after 1.7.27 to 2.5.9 upgrade

[Christian Hammond]

Hi Daniel,

You can't get rid of the table (Review Board will break), but you can have
MySQL optimize the table, which should bring the size down:

OPTIMIZE TABLE diffviewer_filediffdata;

Christian


On Thu, Mar 16, 2017 at 09:00 Daniel Kuecker  wrote:

> I recently moved our RB 1.7.27 instance to a 2.5.9 instance.  I restored a
> backup of the 1.7.27 db to the 2.5.9 instance and ran rb-site install and
> waited and waited.  Everything converted successfully and we are now
> running 2.5.9 (our users love it! yay!)
>
> NOTE:  Before the restore, to avoid the InnoDB conversion evolution, I
> manually edited the sql dump, changed the table engines to InnoDB and the
> charset to UTF8 for all tables.
>
> I noticed I still have a diffviewer_filediffdata table that is the same
> size as the original but has zero records.  Is that table needed anymore?
> I'd like to get rid of it as it is 28GB in size.
>
> Thanks!
>
> --DK
>
> --
> Supercharge your Review Board with Power Pack:
> https://www.reviewboard.org/powerpack/
> Want us to host Review Board for you? Check out RBCommons:
> https://rbcommons.com/
> Happy user? Let us know! https://www.reviewboard.org/users/
> ---
> You received this message because you are subscribed to the Google Groups
> "reviewboard" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to reviewboard+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
-- 
-- 
Christian Hammond
President/CEO of Beanbag 
Makers of Review Board 

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

diffviewer_filediffdata table after 1.7.27 to 2.5.9 upgrade

[Daniel Kuecker]

I recently moved our RB 1.7.27 instance to a 2.5.9 instance.  I restored a 
backup of the 1.7.27 db to the 2.5.9 instance and ran rb-site install and 
waited and waited.  Everything converted successfully and we are now 
running 2.5.9 (our users love it! yay!)

NOTE:  Before the restore, to avoid the InnoDB conversion evolution, I 
manually edited the sql dump, changed the table engines to InnoDB and the 
charset to UTF8 for all tables. 

I noticed I still have a diffviewer_filediffdata table that is the same 
size as the original but has zero records.  Is that table needed anymore? 
 I'd like to get rid of it as it is 28GB in size.

Thanks!

--DK

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.