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.
