Skip to content Skip to main navigation Skip to footer

Query bug

Tagged: 

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #3871
    martin@lovingpenguin.com[email protected]
    Participant

    Hi,

    About a month ago (aprox around the 20th of April), a new version of the QSM plugin was released. Unfortunately, this has caused a lot of load on our Database and also caused several hundred dollars of AWS traffic costs. The problem is that the QSM plugin constantly seems to be executing the query ‘SELECT * FROM wp_mlw_results’.

    As we were having more than 12000 results in our DB, this query took almost a minute to execute each time and all the data from the table was submitted from our RDS instance to our web servers constantly. We are talking about many GB of additional traffic every day.

    Once I disable QSM, the problem is fixed.

    As a (temporary) workaround we jsut deleted all results from the wp_mlw_results table now. They query is still executed all the time, but as there are no (and soon few) results only, it will be affecting much less.

    Can you please have a look into this? I imagine this probably affects all QSM users in a way.

    Cheers,
    Martin

    #3883
    Kriti SharmaKriti Sharma
    Keymaster

    Hi Martin, I need to talk to the development team regarding this issue. I will get back to you as soon as I hear back from them.

    Regards,
    Kriti

    #4087
    Kriti SharmaKriti Sharma
    Keymaster

    Hi,

    Please use the following zip copy for testing.

    https://drive.google.com/open?id=10qM9o7c5fbGLjsiwy-LGjagUcFXkNA8C

    Please upload using FTP to overwrite existing copy on your server.

    NOTE: Do not do a manual update from WordPress admin, because deleting QSM from WordPress admin will delete all of the quiz!

    Please do tell me whether this fix works for you in reducing database load or not.

    Regards,
    Kriti

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.