SELECT 'autoloaded data in KiB' as name, ROUND(SUM(LENGTH(option_value))/ 1024) as value FROM serbisyo_options WHERE autoload='yes' UNION SELECT 'autoloaded data count', count(*) FROM serbisyo_options WHERE autoload='yes' UNION (SELECT option_name, length(option_value) FROM serbisyo_options WHERE autoload='yes' ORDER BY length(option_value) DESC LIMIT 10)
CLEAN UP TRANSIENTS
SELECT *
FROM `wp_options`
WHERE `autoload` = 'yes'
AND `option_name` LIKE '%transient%'
DELETE
FROM `wp_options`
AND `option_name` LIKE '%transient%'
SELECT *
FROM `wp_options`
WHERE `option_name` LIKE '_wp_session_%'
DELETE FROM `wp_options`
WHERE `option_name` LIKE '_wp_session_%'
SELECT *
FROM `wp_options`
WHERE `option_name` LIKE 'aiowps_%'
DELETE FROM `wp_options`
WHERE `option_name` LIKE 'aiowps_%'