HomePhabricator

Optimized notification timestamp clearing

Description

Optimized notification timestamp clearing

  • Hint that mariadb can avoid scanning already NULL rows since we want to set them all to NULL. This lets the index with the timestamp be used, which avoids logs of scanning for users with many rows. For non-parallel replication, this also avoids slave lag in particular.

Bug: T107923
Change-Id: I8cded5476ef6adb2f8fea57239afd6e9b2a49708

Details