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

Optimize database index generation for mapping tables

    Details

      Description

      Redundant indexes are created for mapping tables.

      Steps to Reproduce:

      1. Start Liferay in a clean MySQL database.
      2. Use a tool like Percona (pt-duplicate-key-checker) to check redundant indexes.

      Expected Result:
      No redundant indexes should exist for mapping tables like Users_Teams, Groups_Roles,...

      Actual Result:
      Redundant indexes exist.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 years, 28 weeks ago

                  Packages

                  Version Package