How to Clear Data from mycred-cache-keys Table

  • Resolved Tranny

    (@tranny)


    4 years, 4 months ago

    Hello, the size of the auto-load table mycred-cache-keys on my site is 76MB, crippling my server and causing a lot of headache. I deactivated the plugin, but the auto-load remains. I would like to ask what is the proper way to clear that up.

    Thank you

Viewing 8 replies - 1 through 8 (of 8 total)

  • Hi @tranny,
    Thanks for using myCred, Can you please let us know the version of the plugin you are using.

    Thread Starter Tranny

    (@tranny)

    @wpexpertssupportteam thanks for responding. I used the latest version of the plugin, updated 2 weeks ago to 1.8.12. Somehow it seems to me as though it was this latest update that sent things spiriling out of control, as after a few years of use, this was the first time it happened that it would cripple my database.

    As I said earlier, I had deactivated the plugin, but since then, I also deleted it in hopes that the deletion would remove the bloated mycred-cache-keys section of the database. Unfortunately, the 76MB of data was left in the database after the deletion of the plugin.

    I have requested my host to change the autoload setting in the database to NO, but still waiting for them to do it, because I have no direct access to the database.

    Still, my question remains – how can I get rid of it properly from the database, especially now after I have already deleted the plugin.

    • This reply was modified 4 years, 4 months ago by Tranny.

    Hi @tranny,
    Thank you reporting this issue, We have forwarded the details to the QA Team we will get back to you once we hear back from them.

    Thread Starter Tranny

    (@tranny)

    @wpexpertssupportteam I appreciate the care. I can now report that my webhost changed autoload for mycred-cache-keys to NO, and the server load came down so my site is responsive again. Unfortunately it took me 5 days to narrow the issue down, so it was very stressful 5 days when nomatter what I did, the DB server would always time out.

    I’m still hoping you can follow up with the instruction on how to properly remove the orphaned records from the database.

    Hi @tranny,

    Thanks for sharing the details, We have passed on the info you shared to our Technical team they will be looking into it.

    Hi @tranny,

    As we have looked at the table of “mycred-cache-leaderboard-keys”. We haven’t found the MBs values in the Length column. as you mentioned above.

    Have similar problem with ‘mycred-cache-keys’, over 50mb in wp_options. My project 130-150K user per day and server have big problem with more than 40TB traffic per day.
    When I set ‘mycred-cache-keys’ to NO autoload and disable myCred plugin problem gone.
    Have idea how fix this problem?

    Hi @kingstakh,

    Our technical team needs some more info from your side can you please open a support ticket on our official website.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘How to Clear Data from mycred-cache-keys Table’ is closed to new replies.

Tags