Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-8523

A patch to always select MyISAM as the temporary dedupe table storage engine for performance reasons; regardless of the MySQL configuration.

    Details

    • Type: Patch
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.3.6
    • Fix Version/s: 3.4.6
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      Adds MyISAM storage engine specification to the queries that create temporary tables are part of the dedupe process. Without this specification a civicrm install using default_storage_engine = InnoDB dedupes much slower because of how much slower InnoDB temporary tables are than MyISAM tables (especially with the file_per_table option).

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              shadesofgraylin Graylin Kim
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: