Large amount of data in Database

  • Resolved dmarin

    (@dmarin)


    1 week, 3 days ago

    Hi there!

    I have been using your plugin for a long time and it is great because it shows activity in much detail … however, I noticed that my database is getting Big and found out that it’s mostly because of the your plugin. I had a lot of entries (2 months) but I have cleaned it all to last 14 days, but DB files are still very big (wsal_metadata and wsal_occurrences are almost 10GB!) even after I used WP Optimize plugin to optimize database.

    So, can you please explain how I can optimize these files in the database, please?

    Thanks, Danijel

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support robertabela

    (@robert681)

    Thank you for using our plugin @dmarin

    In regards to the number of events stored in your database, you should configure the activity log retention policies. Basically you tell the plugin to delete logs that are older than a certain number of days. We have also written a detailed article about WordPress activity log size and the database. I hope that helps.

    In regards to the optimization, if there is empty space in the database then the size will shrink. If it is not shrinking, it means that the data is still in the database. Can you check the entries in the tables?

    Looking forward to hearing from you.

    Thread Starter dmarin

    (@dmarin)

    Hi there, @robert681 !

    Thanks for your reply. Yes, I have already sorted thing s out … for some reason it was still showing as big 12GB size database in cPanel even though it was already optimized. It is all good now and retention policies adjusted.

    Thank you for support and great plugin with many options! ??

    Regards, Danijel

    Plugin Support robertabela

    (@robert681)

    I am glad to read the issue has been resolved @dmarin

    Please spare a minute to rate our plugin and service. These ratings are really helpful. Thank you again for using our plugin and for the review.

    Have a good day.

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