Huge server load processing digests after import

gerhard · May 7, 2018, 2:51pm

It sounds like most of your users have the same last_seen_at value. Usually import scripts set it to the user’s created_at or last_posted_at date & time.

github.com/discourse/discourse

script/import_scripts/base.rb

main


      
              UPDATE topics t
                 SET bumped_at = COALESCE((SELECT MAX(created_at) FROM posts WHERE topic_id = t.id AND post_type = #{Post.types[:regular]}), bumped_at)
            SQL
          end
          
          def update_last_posted_at
            puts "", "Updating last posted at on users"

Maybe that didn’t happen or lots of users have it set to the same time… Try updating the last_seen_at column with random times so that it evenly distributes the digest mails throughout the day.

Topic		Replies	Views
Post import, how many automated emails will suddenly start being sent daily? Product Support	3	533	April 25, 2020
Schedule Weekly Digest Product Support activity-summary	3	1056	October 27, 2020
Optimize Discourse digest period Product Support activity-summary	11	904	March 22, 2020
Feature Request: Make the Digest Job "Sending Time Window" Configurable Feature activity-summary	5	652	December 7, 2020
Digests all sending at the same time Product Support activity-summary	5	966	August 23, 2018

Huge server load processing digests after import

Related topics