Hi Christian,
The condensediffs command takes days and days together. Hence, I stopped it
in between. After seeing your reply, started it again.
--------------------------------------------------------------------------------------------------------------------------
[root@reviewboard html]# /opt/software/bin/rb-site manage
/var/www/reviewboard.com condensediffs
Processing 6054597 diffs for duplicates...
This may take a while. It is safe to continue using Review Board while this
is
processing, but it may temporarily run slower.
[0%] 57600/6054597 - 0 seconds remaining
--------------------------------------------------------------------------------------------------------------------------
Here are the details of the setup.
App server:
No. of processors: 12
Processor Speed: 2.7 GHz
Memory: 24 GB
Memcache size: 2GB
DB server:
No. of processors: 2
Processor Speed: 2.13GHz
Memory: 10GB
--------------------------------------------------------------------------------------------------------
MySQL [ReviewBoard]> SHOW VARIABLES LIKE "%version%";
+-------------------------+---------------------+
| Variable_name | Value |
+-------------------------+---------------------+
| protocol_version | 10 |
| version | 5.1.52-log |
| version_comment | Source distribution |
| version_compile_machine | x86_64 |
| version_compile_os | redhat-linux-gnu |
+-------------------------+---------------------+
5 rows in set (0.00 sec)
MySQL [ReviewBoard]> SHOW TABLE STATUS WHERE Name =
'diffviewer_filediffdata';
+-------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows |
Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_time | Update_time | Check_time
| Collation | Checksum | Create_options | Comment |
+-------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
| diffviewer_filediffdata | MyISAM | 10 | Dynamic | 4216198 |
11479 | 48398494548 | 281474976710655 | 264371200 | 252356 |
NULL | 2018-04-09 09:27:12 | 2018-04-25 02:33:16 | 2018-04-10 09:13:02
| latin1_swedish_ci | NULL | | |
+-------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
1 row in set (0.00 sec)
--------------------------------------------------------------------------------------------------------
And yes. I don't see any slowdown when posting new diffs.
Please let me know if we have any work-around other than running
condensediffs.
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
