Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-11748

Performance: phpbb_sessions and innodb

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Won't Fix
    • Icon: Major Major
    • 3.1.12-RC1
    • 3.0.11
    • Sessions
    • None
    • Percona Server 5.5 with InnoDB/XtraDB Storage

      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.

            CHItA CHItA
            nissin nissin [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: