SQL Kepekan + Redis

gistfile1.md

Cek string pada options yang panjang

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