An upgrade might help, but I'm not sure whether it'll solve the issue.
I want to narrow down whether it's traversal over the index that's slowing
down some of our lookups. How long does this take? (If the answer is more
than a couple minutes, Control-C it).
SELECT COUNT(binary_hash) FROM diffviewer_filediffdata;
By the way, using \G instead of ; at the end of a statement will result in
more readable output for e-mail (doesn't rely on fixed-width text). Useful
trick.
Christian
On Thu, Apr 26, 2018 at 2:33 AM, Hemapriya <m.hemapr...@gmail.com> wrote:
> We created a copy of the actual database and working on it. Once it works
> perfect, we'll upgrade to ReviewBoard3.0 in production environment.
>
> Here are the requested detail.
>
> ------------------------------------------------------------
> ----------------------------------------------------
>
> MySQL [ReviewBoard]> SHOW INDEXES FROM diffviewer_filediffdata;
> +-------------------------+------------+----------+---------
> -----+-------------+-----------+-------------+----------+---
> -----+------+------------+---------+
> | Table | Non_unique | Key_name | Seq_in_index |
> Column_name | Collation | Cardinality | Sub_part | Packed | Null |
> Index_type | Comment |
> +-------------------------+------------+----------+---------
> -----+-------------+-----------+-------------+----------+---
> -----+------+------------+---------+
> | diffviewer_filediffdata | 0 | PRIMARY | 1 |
> binary_hash | A | 4216198 | NULL | NULL | | BTREE
> | |
> +-------------------------+------------+----------+---------
> -----+-------------+-----------+-------------+----------+---
> -----+------+------------+---------+
> 1 row in set (1.18 sec)
>
>
> MySQL [ReviewBoard]> EXPLAIN EXTENDED SELECT COUNT(binary_hash) FROM
> diffviewer_filediffdata;
> +----+-------------+-------+------+---------------+------+--
> -------+------+------+----------+------------------------------+
> | id | select_type | table | type | possible_keys | key | key_len | ref
> | rows | filtered | Extra |
> +----+-------------+-------+------+---------------+------+--
> -------+------+------+----------+------------------------------+
> | 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL
> | NULL | NULL | Select tables optimized away |
> +----+-------------+-------+------+---------------+------+--
> -------+------+------+----------+------------------------------+
> 1 row in set, 1 warning (0.03 sec)
>
>
> MySQL [ReviewBoard]> ANALYZE TABLE diffviewer_filediffdata;
> +------------------------------------------+---------+------
> ----+----------+
> | Table | Op | Msg_type | Msg_text
> |
> +------------------------------------------+---------+------
> ----+----------+
> | RAT_ReviewBoard3.diffviewer_filediffdata | analyze | status | OK
> |
> +------------------------------------------+---------+------
> ----+----------+
> 1 row in set (5 min 23.74 sec)
> ------------------------------------------------------------
> ----------------------------------------------------
>
> Do you think upgrading mysql to a higher version will help here?
>
> Regards,
> Hemapriya.
>
> --
> 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.
