Author: Riya Ray
Updated: September 2024
Audience: Everyone
Environmental details below:
- Recently upgraded to Jama Connect® 8.74.1 (Self-Hosted, Air-gapped: DEV) from Jama Connect® 8.62.2
- Database: MySQL 8.0
- Docker Version: 20.10.7
- Replicated Version: 2.53.2
- Application Server OS: CentOS
Summary
Users must perform a full reindex on their instance when upgrading to a new version. Sometimes, users need help with problems where the reindexing speed becomes extremely slow and takes an unusual amount of time to complete.
Solution
To improve the Reindexing process, check the following points:
- Check CPU and RAM resources: Ensure that the instance has sufficient resources for both CPU Cores and the RAM. Check the below articles for Jama's recommendations:
- Ensure mysql.conf file is correctly set up.
- Ensure Advanced Memory settings are enabled and correctly set up per this article.
- Add the following parameters to the Replicated console to improve Reindexing. These values should be updated on Advanced Startup Settings under Add services configuration (key=value pairs on separate lines) text box. With these configurations, we are increasing the system capabilities and the load it can process per item.
-
reindexBrokenItemThreshold=1000000
-
jamasearch.multithreadindex.enabled=true
-
jamasearch.multithreadindex.chunksize=500
-
jamasearch.multithreadindex.poolsize=10
-
jamasearch.tenantReindexingMaxPayloadSizeInBytes=5242880
-
tenantReindexingMaxPayloadSizeInBytes=5242880
-
- For many users in their instances, the performance (especially relating to reindexing) has improved after running the SQL commands below. Run the below queries on the database server, followed by a full reindex (traditional/KOTS) from the root (traditional/KOTS) menu.
-
mysqldump db_name > dump.sql
-
mysql db_name < dump.sql
-
-
If the above also does not fix the issue, the user may need to force the database to update the database index stats by running the below query:
-
mysqlcheck -u root -p --auto-repair --optimize contour
-
Additional Information/Metadata
- Performance
- Slowness
- Full Reindexing
- Troubleshooting
Related to
Comments
0 comments
Article is closed for comments.