FWIW we have a large installation of reviewboard as well and it was running MyISAM engine.
We upgraded from 1.X some to 2.0 recently and also moved to Innodb which has row level locking. This is what we did: 1. Turned off foreign key constraints 2. Ran alter table query on on all tables and change the engine to innodb 3. Ran the Reviewboard update 4. Turned on the key constraints again. Needless to say we scheduled a downtime for this and also backed up the data . On Friday, 27 April 2018 03:50:29 UTC-7, Hema wrote: > > Is there any way that we can migrate only the open review requests or the > review requests created over a specific period of time? > > Regards, > Hema. > > On Fri, Apr 27, 2018 at 9:56 AM, Hemapriya <[email protected] > <javascript:>> wrote: > >> 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 < >> [email protected] <javascript:>> 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 <[email protected] >>> <javascript:>> 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 [email protected] <javascript:>. >>>> 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 >>> [email protected] <javascript:>. >>> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
