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

Performance: phpbb_sessions and innodb

    Details

    • Type: Improvement
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 3.0.11
    • Fix Version/s: 3.1.12-RC1
    • Component/s: Sessions
    • Labels:
      None
    • Environment:
      Percona Server 5.5 with InnoDB/XtraDB Storage

      Description

      The phpbb use the session_id as primary key for php_sessions table. Value of session_id in phpbb is random. The mysql innodb storage internally store the data sorted by primary key. After add new record to the sessions table innodb fully rewrite this table in new order (because the new session_id not at the end of table). On highload forums this make the overhead mysql server.
      To resolve this problem I'm change the session_id to unique key and created the fake id autoincrement field to use it as primary key.

        Attachments

          Activity

            People

            • Assignee:
              CHItA CHItA
              Reporter:
              nissin nissin
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: