Details

    • Documentation Required?:
      None
    • Sprint:
      4.7.10 Performance
    • Funding Source:
      Contributed Code

      Description

      The query to determine if the DB is myIsam is taking a whopping 13 seconds. It seems the mysql config will affect the speed of 'SHOW TABLE STATUS ' queries

      http://dba.stackexchange.com/questions/39993/show-table-status-very-slow-on-innodb

      However, this alternate query

      {{SELECT count
      FROM information_schema.TABLES
      WHERE ENGINE <> 'MyISAM'
      AND TABLE_SCHEMA = ''" . CRM_Core_DAO::getDatabaseName() . "'
      AND TABLE_NAME LIKE 'civicrm_%'
      AND TABLE_NAME NOT LIKE 'civicrm_import_job_%'
      AND TABLE_NAME NOT LIKE '%temp';}}

      Saves 12.99 of those 13 seconds

        Attachments

          Activity

            People

            • Assignee:
              eileen Eileen McNaughton
              Reporter:
              eileen Eileen McNaughton
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: