Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-9813

fulltext_native.php on innodb loading deadly slow for big indexes

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.0.7-PL1
    • Fix Version/s: 3.0.11-RC1
    • Component/s: ACP
    • Labels:
      None
    • Environment:
      php-5.3.3 mysql 5.1.37

      Description

      when using INNODB and having a BIG search index (like 25 million entries) on heavily loaded database, opening the maintenance->search index page is deadly slow (like 5+ minutes to load).

      After tracing the issue, I notices phpBB is issuing a SELECT count on that tables, which causes a full table scan on innoDB.
      It would be better to use SHOW TABLE STATUS here to obtain the row count.

      I'll attack a patch that uses show table status instead count when using MySQL.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bantu Andreas Fischer
                Reporter:
                chibisuke chibisuke
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: