Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-70724

Throughput issues due to the increased number of search write requests after LPS-65978



      There are throughput issues in both search engine and Liferay installation after installing LPS-65978 solution

      That LPS increases reindexation requests to elasticsearch/solr/lucene

      CPU consumption is also increased: all the Indexer "doReindex" logic is executed but only one field is modified (ratings, viewCount, etc...) so a lot of unnecessary database queries and calculations are done.

      Solution Notes

      Changes introduced in the fix for LPS-65978 (affecting when fields 'ratings' and 'viewCount' get updated in the search index) have been reverted. In addition, these fields will no longer be indexed in the BaseIndexer class for AssetEntry objects as of the next Liferay version.

      Why was this change made?

      Keeping the Ratings and View Count options in the search index in sync with the database has a negative impact on normal operations due to the significantly increased number of index Write requests causing throughput issues and, therefore, performance degradation.

      In addition, the view count is not always up-to-date in the database. This behavior is controlled by the Buffered Increment mechanism. You can find more information about this in the portal.properties file.


        Issue Links



              raven.song Raven Song
              jorge.diaz Jorge Diaz
              Tibor Lipusz Tibor Lipusz
              0 Vote for this issue
              3 Start watching this issue


                5 years, 39 weeks, 6 days ago


                  Version Package
                  6.2.X EE
                  7.0.0 DXP FP18
                  7.0.3 CE GA4
                  7.0.0 DXP SP4
                  7.0.X EE
                  7.1.0 CE GA1
                  7.1.10 DXP GA1