Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-3438

Improve Alfresco performance by creating an index on the field is_root of the table avm_nodes

    Details

    • Type: Information
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Not a bug
    • Affects Version/s: 3.2.1
    • Fix Version/s: 4.0.1
    • Component/s: Installer
    • Labels:
      None
    • Environment:
      Tomcat, MySQL, RHEL

      Description

      A customer is proposing the following index to improve database performance .

      CREATE INDEX idx_is_root ON avm_nodes (is_root) USING BTREE;

      The query to benefit from this index is:

      select an.* from avm_child_entries ce right outer join avm_nodes an on an.id = ce.child_id where ce.parent_id is null and an.is_root = 0;

      The query plan for this query is:

      ----------------------------------------------------------------------------------------------------------------------+

      id select_type table type possible_keys key key_len ref rows Extra

      ----------------------------------------------------------------------------------------------------------------------+

      1 SIMPLE an ALL NULL NULL NULL NULL 3 Using where
      1 SIMPLE ce ref fk_avm_ce_child fk_avm_ce_child 8 alfresco310.an.id 1 Using where; Using index; Not exists

      ----------------------------------------------------------------------------------------------------------------------+
      2 rows in set (0.00 sec)

        Attachments

          Activity

          mrodriguez Miguel Rodriguez created issue -
          ahunt Andrew Hunt made changes -
          Field Original Value New Value
          Status New [ 10001 ] Open [ 1 ]
          ahunt Andrew Hunt made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Assignee Sustaining Support Team [ alf_sustaining ] QA Backlog Unassigned [ qabacklog ]
          Fix Version/s 4.0.1 [ 11020 ]
          Resolution Not a bug [ 6 ]
          rmanthena Ravi Manthena made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Assignee QA Backlog Unassigned [ qabacklog ] Closed Issues [ closedissues ]
          adavis Alan Davis made changes -
          Status Closed [ 6 ] Editable Closed [ 10061 ]
          adavis Alan Davis made changes -
          Component/s ZZ Do not use [ 12819 ]
          Component/s Sustaining [ 10760 ]
          adavis Alan Davis made changes -
          Project Alfresco [ 10281 ] Service Packs and Hot Fixes [ 11350 ]
          Key ALF-13368 MNT-3438
          Workflow Alfjira_II_PM [ 140949 ] Service Packs and Hot Fixes [ 175232 ]
          Fix Version/s 4.0.1 [ 12749 ]
          Fix Version/s 4.0.1 [ 11020 ]
          Status Transition Date 10/Apr/12 3:49 PM [ 2012-04-10T15:49+0100 ]
          Affects Version/s 3.2 SP1 [ 12727 ]
          Affects Version/s 3.2 SP1 [ 10594 ]
          Rank (Obsolete) 61910000000
          Component/s ZZ Do not use [ 12815 ]
          Component/s ZZ Do not use [ 12819 ]
          adavis Alan Davis made changes -
          Status Editable Closed [ 10061 ] Closed [ 6 ]
          adavis Alan Davis made changes -
          Workflow Service Packs and Hot Fixes [ 175232 ] Service Packs and Hot Fixes - rm EC [ 184798 ]
          adavis Alan Davis made changes -
          Workflow Service Packs and Hot Fixes - rm EC [ 184798 ] Service Packs and Hot Fixes [ 192089 ]
          adavis Alan Davis made changes -
          Component/s Installation [ 12296 ]
          Component/s ZZ Do not use [ 12815 ]

            People

            • Assignee:
              closedissues Closed Issues
              Reporter:
              mrodriguez Miguel Rodriguez
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: