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

fulltext_native.php on innodb loading deadly slow for big indexes

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 3.0.7-PL1
    • 3.0.11-RC1
    • ACP
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: