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

Server slowed down when having high session count

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Unverified Fix (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.2.1
    • Fix Version/s: 3.3.0-RC1
    • Component/s: Sessions
    • Labels:
    • Environment:
      php 7.1.7, mariadb cluster 10.2

      Description

      Story. we change domain of forum. then bots starts reindex. But sow whats too much CPU usage on mysql process..

      And found this - > much sessions slows down mysql .

      SELECT * FROM phpbb_sessions  where session_browser = 'Mozilla/5.0 (compatible; YandexImages/3.0; +http://yandex.com/bots)' or session_browser = 'Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)';

      where was 257000 rows

      then add new bot with partial "Yandex" and delete all bot sessions.

      CPU goes down by half.

      GRAPH CPU usage blue.

      where was about 120 request/s via workbench viewer.

      Have suggestion? maybe need keep up to date some popular search engine bots?

        Attachments

          Activity

            People

            Assignee:
            Marc Marc
            Reporter:
            agrisv agrisv [X] (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: