• We’ve been having issues with wp_options table size and see the ws_menu_editor option_name is very large, see below. The value seems to contain redundant info as well, is there a way to reduce the size of this value safely without losing settings?

    MariaDB [wmnf_www]> SELECT 'autoloaded data in KiB' as name, ROUND(SUM(LENGTH(option_value))/ 1024) as value FROM wp_options WHERE autoload='yes' UNION SELECT 'autoloaded data count', count(*) FROM wp_options WHERE autoload='yes' UNION (SELECT option_name, length(option_value) FROM wp_options WHERE autoload='yes' ORDER BY length(option_value) DESC LIMIT 10);
    +--------------------------------------+--------+
    | name                                 | value  |
    +--------------------------------------+--------+
    | autoloaded data in KiB               |   1312 |
    | autoloaded data count                |   1010 |
    | wordpress-https_secure_external_urls | 355451 |
    | ws_menu_editor                       | 352910 |
    | mw_adminimize                        | 140189 |
    | rewrite_rules                        |  63532 |
    | jetpack_file_data                    |  60871 |
    | ee_active_messengers                 |  44570 |
    | ee_transient_schedule                |  39008 |
    | ai1ec_settings                       |  35248 |
    | old_adminimize                       |  29069 |
    | wp_user_roles                        |  27400 |
    +--------------------------------------+--------+
    12 rows in set (0.10 sec)
Viewing 1 replies (of 1 total)
  • Plugin Author Janis Elsts

    (@whiteshadow)

    You can reduce the size of that database entry by checking this box in the “Settings” tab: “Compress menu configuration data that’s stored in the database”. It’s near the bottom of the page, in the “Debugging” section.

Viewing 1 replies (of 1 total)
  • The topic ‘Large value in wp_options’ is closed to new replies.