Skip to content
This repository was archived by the owner on Apr 26, 2024. It is now read-only.
This repository was archived by the owner on Apr 26, 2024. It is now read-only.

Improve performance of background update populate_user_directory_process_rooms #15264

Closed
Closed
Improve performance of background update populate_user_directory_process_rooms#15264
Labels
A-Background-UpdatesFilling in database columns, making the database eventually up-to-dateA-DatabaseDB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the dbO-OccasionalAffects or can be seen by some users regularly or most users rarelyS-MinorBlocks non-critical functionality, workarounds exist.T-TaskRefactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
@H-Shay

Description

@H-Shay
H-Shay
opened on Mar 13, 2023

Relevant code begins here:

synapse/synapse/storage/databases/main/user_directory.py

Line 87 in 335f52d

self.db_pool.updates.register_background_update_handler(

This process can cause excess load on the DB, perhaps need to reconfigure the batch size to make it less resource-intensive.

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-Background-UpdatesFilling in database columns, making the database eventually up-to-dateA-DatabaseDB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the dbO-OccasionalAffects or can be seen by some users regularly or most users rarelyS-MinorBlocks non-critical functionality, workarounds exist.T-TaskRefactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions