** Changed in: mahara Status: Confirmed => In Progress -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1731067
Title: Some cron jobs cause elasticsearch queue to populate when it doesn't need to Status in Mahara: In Progress Bug description: We only record certain information in elasticsearch but we queue things even if unrecorded information changes because we use triggers/procedures on the tables Example, when the recalculate_quota cron runs it works out what the user quota should be and then updates all the users in usr table that need fixing. This table has a trigger on it so all users needing updating are added to queue to be indexed. On a big site that can mean thousands of users being indexed. But we don't record quota in elasticsearch so we don't need to index this change. It would be good to be able to drop/add elasticsearch triggers during cron process for certain cron jobs like we do in upgrade.php script eg: drop_elasticsearch_triggers(); ... do cron job ... create_elasticsearch_triggers(); To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1731067/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp