You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT option_name, LENGTH(option_value), autoload FROM wp_options ORDER BY autoload DESC, option_name ASC;
Delete transient
DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient_%');
DELETE FROM `wp_options` WHERE `option_name` LIKE ('_site_transient_%');
redis-cli -a [password] --bigkeys
Find long wp options
SELECT option_name, length(option_value)
FROM `wp_2_options`
where autoload='yes'
order by length(option_value) desc
SELECT option_name, length(option_value)/1024
FROM `wp_options`
where autoload='yes'
order by length(option_value) desc