WP_Options table size

  • Resolved aLjaz

    (@aljaz)


    2 years, 3 months ago

    Hi,

    I noticed that my database was big and when i checked it, I saw that wp_options table was 4.1 GB large, first i tried to delete all transit records from table but the table size didn’t change.

    After checking which records are filling up the table I found that this records are consumin most of my space wp_example_process_batch. I was not able to find out which plugin or functions creates this, and my main question is: Can this be safely deleted from the table ?

    I found which records use the most space with following command: 

    SELECT 'autoloaded data in KiB' as name, ROUND(SUM(LENGTH(option_value))/ 1024) as value FROM beloved_options WHERE autoload='no'
UNION
SELECT 'autoloaded data count', count(*) FROM beloved_options WHERE autoload='no'
UNION
(SELECT option_name, length(option_value) FROM beloved_options WHERE autoload='no' ORDER BY length(option_value) DESC LIMIT 10)

    Thank you.
    Br, Alja?.

    • This topic was modified 2 years, 3 months ago by aLjaz.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    It seems to be coming from this plugin: https://github.com/gdarko/wp-batch-processing. Do you have it installed?

    I *think* it’s probably safe to delete the entries, but make a backup first.

    That’s one massive table. Personally, I don’t think it’s the wisest of idea’s to delete things in your database like that. I did something similar once, and suddenly all the permissions of the website were gone!

    I use WP-Optimize as a plugin to remove the overhead of the tables, remove things left behind by old & removed plugins and such.

    I’m not the right person to tell you if it’s safe or not to remove, but I did find an article that has some other options that might be able to help: https://www.hongkiat.com/blog/trimming-wordpress-database/

    Also, like Steven said. Do back-up your database. Like in the example I gave, you never know what might happen and a backup is a godsend in those cases.

    Thread Starter aLjaz

    (@aljaz)

    Hi,

    thanks for advice I will look into that. I also found that plugin, but i don’t use that plugin or any other batch plugin that is why it is strange to me why this records are created.

    I have 2 same websites but only one is creating so many records in table, the plugin difference i found are bellow. I don’t think any of this plugins is createing this records in DB.

    Counter Visitor for Woocommerce
    Facebook for WooCommerce
    Facebook for WordPress
    PixelYourSite Pinterest
    WP Woocommerce to Google merchant center
    WooCommerce Cheapest & Most Expensive Product Promotions!
    REST API Log
    Product Feed PRO for WooCommerce

    Br, Alja?.

    • This reply was modified 2 years, 3 months ago by aLjaz.
    Thread Starter aLjaz

    (@aljaz)

    Plugin WP Woocommerce to Google merchant center was making issue in DB. Deleting records from wp_options didn’t effect website.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WP_Options table size’ is closed to new replies.

Tags