SAFE Clean-Up table

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_%'