mahara-contributors team mailing list archive

[Kevin Hipwell <1778889@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

On big sites there is an issue regarding the time it takes cron to run
due to the use of triggers/procedures on the tables when processing
information for elasticsearch.

A solution was developed to drop triggers for this portion of the cron
run and then re-enable triggers.

The issue is that other triggers cannot be executed during the period of
disabling triggers and re-enabling them.

Relevant Bugs: 
https://bugs.launchpad.net/mahara/+bug/1731067?comments=all
https://bugs.launchpad.net/mahara/+bug/1778888

** Affects: mahara
     Importance: Undecided
         Status: New


** Tags: elasticsearch

** Description changed:

  On big sites there is an issue regarding the time it takes cron to run
  due to the use of triggers/procedures on the tables when processing
  information for elasticsearch.
  
  A solution was developed to drop triggers for this portion of the cron
  run and then re-enable triggers.
  
  The issue is that other triggers cannot be executed during the period of
  disabling triggers and re-enabling them.
  
- Relevant Bug:
+ Relevant Bugs: 
  https://bugs.launchpad.net/mahara/+bug/1731067?comments=all
+ https://bugs.launchpad.net/mahara/+bug/1778888

-- 
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/1778889

Title:
  Dropping and re-adding elasticsearch triggers will prevent other
  triggers from executing if some action is made during this period.

Status in Mahara:
  New

Bug description:
  On big sites there is an issue regarding the time it takes cron to run
  due to the use of triggers/procedures on the tables when processing
  information for elasticsearch.

  A solution was developed to drop triggers for this portion of the cron
  run and then re-enable triggers.

  The issue is that other triggers cannot be executed during the period
  of disabling triggers and re-enabling them.

  Relevant Bugs: 
  https://bugs.launchpad.net/mahara/+bug/1731067?comments=all
  https://bugs.launchpad.net/mahara/+bug/1778888

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1778889/+subscriptions