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

fulltext_native.php on innodb loading deadly slow for big indexes

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • 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: