Title: Large value in wp_options
Last modified: November 13, 2017

---

# Large value in wp_options

 *  [webtent](https://wordpress.org/support/users/webtent/)
 * (@webtent)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/large-value-in-wp_options/)
 * 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](https://wordpress.org/support/users/whiteshadow/)
 * (@whiteshadow)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/large-value-in-wp_options/#post-9677803)
 * 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.

 * ![](https://ps.w.org/admin-menu-editor/assets/icon-128x128.png?rev=1418604)
 * [Admin Menu Editor](https://wordpress.org/plugins/admin-menu-editor/)
 * [Support Threads](https://wordpress.org/support/plugin/admin-menu-editor/)
 * [Active Topics](https://wordpress.org/support/plugin/admin-menu-editor/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/admin-menu-editor/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/admin-menu-editor/reviews/)

## Tags

 * [wp_options](https://wordpress.org/support/topic-tag/wp_options/)

 * 1 reply
 * 2 participants
 * Last reply from: [Janis Elsts](https://wordpress.org/support/users/whiteshadow/)
 * Last activity: [8 years, 7 months ago](https://wordpress.org/support/topic/large-value-in-wp_options/#post-9677803)
 * Status: not resolved