I saw that behavior on an older version of MySQL locally a long time back.
If I remember correctly, rebooting MySQL fixed it, and newer versions
didn't seem to exhibit the problem. It had to do with indexing the primary
key hashes. For some reason, it was being incredibly slow with this.
However, I never encountered this when just using the product. I only saw
it when performing SQL statements by hand for testing I was doing.
Review Board 3.0 stopped adding to that table, instead storing new diffs in
diffviewer_rawfilediffdata, which uses a different design. Accessing
existing diffs performs a migration for that diff, and all diffs can be
migrated in one go using `rb-site manage /path/to/sitedir condensediffs`.
Do you see slowdown when posting brand new diffs for review?
Can you tell me more about the MySQL version, table types, and general
hardware specs and setup?
Christian
On Wed, Apr 25, 2018 at 2:19 AM, Hema <m.hemapr...@gmail.com> wrote:
> Hi Christian,
>
> Yes. ReviewBoard can see memcached servers. Cause I can see messages
> getting printed when I use "-vv" switch with memcached.
>
> A query especially the following one gets stuck at the db end.
>
> SELECT `diffviewer_filediffdata`.`binary_hash`,
> `diffviewer_filediffdata`.`binary`, `diffviewer_filediffdata`.`extra_data`
> FROM `diffviewer_filediffdata` WHERE (`diffviewer_filediffdata`.`binary_hash`
> IN ('de97317bfd39313d60016c365948bbb5f108b412') AND NOT
> ((`diffviewer_filediffdata`.`binary_hash` IN (SELECT U1.`diff_hash_id`
> FROM `diffviewer_filediff` U1 WHERE (U1.`id` > 0 AND U1.`diff_hash_id`
> IS NOT NULL)) OR `diffviewer_filediffdata`.`binary_hash` IN (SELECT
> U1.`parent_diff_hash_id` FROM `diffviewer_filediff` U1 WHERE (U1.`id` > 0
> AND U1.`parent_diff_hash_id` IS NOT NULL))))) ;
>
> Do you have any idea on this?
>
> Regards,
> Hema.
>
> --
> 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
> "Review Board Community" 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 <https://www.beanbaginc.com/>
Makers of Review Board <https://www.reviewboard.org/>
--
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
"Review Board Community" 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.
