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

    Details

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 37 weeks, 3 days ago