Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-41030

Slow reindexing since Confluence 5.9.x with MySQL 5.5.x

XMLWordPrintable

      We would like to upgrade from Confluence 5.8.10 to Confluence 5.9.x, but so far we find the re-indexing performance intolerable. Our Prod instance is at 5.8.10 and we have 3 test instances. One at 5.8.10, one at 5.8.18 and one at 5.9.6. We are using MySQL 5.5.22 for all and the test instances are all on the same server.

      The two 5.8.x test instances change reindex 32K objects in about 15 minutes. We have tried 5.9.3 and now 5.9.6 for our 3rd test instance and both 5.9.3 and 5.9.6 take just under 4 hours to rebuild the same 32K objects.

      We were hopeful that the fix mentioned in CONF-40544 and part of 5.9.5 would correct our situation, but it appears to have done nothing for the problem. We will not be able to keep Confluence current until this is resolved.

        1. exec-plan-AFTER.png
          exec-plan-AFTER.png
          201 kB
        2. exec-plan-BEFORE.png
          exec-plan-BEFORE.png
          211 kB

          Form Name

            [CONFSERVER-41030] Slow reindexing since Confluence 5.9.x with MySQL 5.5.x

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2898542 ] New: CONFSERVER Bug Workflow v4 [ 2993163 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2790929 ] New: JAC Bug Workflow v3 [ 2898542 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2737074 ] New: JAC Bug Workflow v2 [ 2790929 ]
            Tony D. made changes -
            Remote Link New: This issue links to "PSR-84 (Bulldog)" [ 383711 ]
            Owen made changes -
            Symptom Severity Original: Major [ 14431 ] New: Severity 2 - Major [ 15831 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2392987 ] New: JAC Bug Workflow [ 2737074 ]
            Nick made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 374216 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2277028 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2392987 ]
            Michael Andreacchio made changes -
            UIS Original: 64
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2219195 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2277028 ]

              zzhou Zhenhuan Zhou (Inactive)
              1221119a5bb8 John Love
              Affected customers:
              20 This affects my team
              Watchers:
              32 Start watching this issue

                Created:
                Updated:
                Resolved: