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

Server slowed down when having high session count

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.3.0-RC1
    • 3.2.1
    • Sessions
    • php 7.1.7, mariadb cluster 10.2

      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?

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

              Created:
              Updated:
              Resolved: