mahara-contributors team mailing list archive

[Kevin Hipwell <1778888@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 it requires SUPER privileges to do this.

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

** Affects: mahara
     Importance: Undecided
         Status: New


** Tags: cron 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.
  
- This issue is that it requires SUPER privileges to do this.
+ The issue is that it requires SUPER privileges to do this.
  
  Relevant Bug:
  https://bugs.launchpad.net/mahara/+bug/1731067?comments=all

** 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 it requires SUPER privileges to do this.
  
- Relevant Bug:
+ Relevant Bugs: 
  https://bugs.launchpad.net/mahara/+bug/1731067?comments=all
+ https://bugs.launchpad.net/mahara/+bug/1778889

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

Title:
  Dropping and re-adding elasticsearch triggers requires SUPER privilege
  to work.

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 it requires SUPER privileges to do this.

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

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