_EDD_LOGS killing my database

  • Resolved flashjunkie

    (@flashjunkie)


    4 years, 7 months ago

    Hi guys,

    Our website has been online for around 7 months now, we have 60k registered users and they are generating a tonne of _edd_log entries in the postmeta database.

    My postmeta database is now approaching 2.5M entries. I have a few questions…

    1) Is it safe to remove any of the meta data?
    For instance, we do not use price_ids (we use ALL ACCESS) for all of our content we also do not need to know which ‘version’ of a file that a user has downloaded so file_id is also redundant, can I safely delete these meta keys from our database without causing adverse effects on the plugin?

    If I could safely delete these keys I could quickly remove over 400k entries from the post meta database.

    2) As our website continues to serve new customers this database is going to increase even more and we are already seeing a HUGE load on our database server during busy periods.

    Are there any plans to move the logging elements of EDD into a dedicated table rather than using post_meta and posts? I should imagine this would streamline the core database tables.

    An SQL search for meta_keys like _edd_log% shows that over 2M of our 2.5M meta entries are log related.

    3) Is there a method available already to do what I mentioned above? I’m happy working with PHP but this feels like a very in-depth modification to the plugins.

    Many thanks ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter flashjunkie

    (@flashjunkie)

    Top meta_keys in our meta table: https://imgur.com/a/gT3bg0N

    Thread Starter flashjunkie

    (@flashjunkie)

    Forgot to ask, are there any other meta entries on that list that aren’t ‘essential’?

    I’m seeing edd_log_version and edd_log_token etc.

    I have a corn task that already does some database cleaning on a daily basis (orphaned data etc) so I can quite easily keep on top of the removal of any non essential or junk meta.

    Many thanks.

    [ Please do not bump. ]

    Hi @flashjunkie,

    We’d like to look into this more deeply and provide you with some instruction specific to your setup. Could you reach out directly to our support team via the support page or email us at [email protected]. Please include your system info with your message so we can provide you with the details you’ll need. Your system info can be downloaded under Downloads > Tools > System Info

    Thank you!

    Thread Starter flashjunkie

    (@flashjunkie)

    I have sent in a support request as requested.

    Many thanks.

    Because there have not been any recent updates to this topic we’ll be changing the status to resolved. If you have any further questions you can start a new thread, or head over to our support page to submit your request if it is related to one of our available add-ons.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘_EDD_LOGS killing my database’ is closed to new replies.