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)
Viewing 1 replies (of 1 total)
- The topic ‘Large value in wp_options’ is closed to new replies.