Thanks for the \G tip. I wasn't aware of it. MySQL [ReviewBoard]> SELECT COUNT(binary_hash) FROM diffviewer_filediffdata\G *************************** 1. row *************************** COUNT(binary_hash): 4216198 1 row in set (0.00 sec)
The above select query doesn't take even a second. Where else could be the issue? By the way, please let me know if you have any recommendation of mysql version, engine type,... that we need to use for ReviewBoard. Thanks, Hema. On Fri, Apr 27, 2018 at 3:04 AM, Christian Hammond <christ...@beanbaginc.com > wrote: > 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 a topic in the > Google Groups "Review Board Community" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/reviewboard/HZP5szW5_-M/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > reviewboard+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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.
