Expert [login to view URL] Database LMS Developer - debug mdl_grade_grades offender

Closed Posted 3 years ago Paid on delivery
Closed

Our company uses [login to view URL] to deliver content to end users.

Over the past ~2 months there has been a specific query (mdl_grade_grades) that puts our database's CPU ~100% and results in 504s delivered to students.

We are using AWS RDS for the database, we were using [login to view URL] but after this offender became a regular occurrence we upgraded to [login to view URL] RDS instance.

Since the RDS upgrade the offender has "almost disappeared" however we have had 2 specific instances where the new RDS CPU reached 90% usage and 504s where delivered to end users for this same table/query. As user activity has increased so has the frequency of the offender.

We are in need of a moodle expert to help us figure out the root cause of this offending query.

Moodle 3.5.1 build 20180720

Moodle MySQL Database Administration PHP Amazon Web Services

Project ID: #29077275

About the project

10 proposals Remote project Active 3 years ago

10 freelancers are bidding on average $20/hour for this job

mmadi

Hello usatyamsharma921, I have read your job details in your requirement and as per your need I have more than 11 years of experience in Amazon Web Services, Database Administration, Moodle, MySQL, PHP so I will More

$15 USD / hour
(50 Reviews)
7.1
ajanoopjot8

Hi, I can help you to fix the issues on your Moodle site. I have many experiences of PHP/Moodle LMS web development/management. Let's discuss more details over chat. Please tell me your LMS site url. I will check it a More

$20 USD / hour
(17 Reviews)
6.2
mnkiweb

Hello, My Moodle Skills are:
 * I have long years of hands on experience in Moodle * Payment Gateway plugins creation and integration * Moodle Installation and Configuration * Moodle Customization * Moodle Sites More

$20 USD / hour
(12 Reviews)
5.2