Reply 325809 to: Oversize wp_options autoload row – et_studio_data how to fix?
bnourse
Participant
June 13, 2022 at 13:55
This is the query:
SELECT
‘Autoload KB’ as name, ROUND( SUM( LENGTH( option_value ) ) / 1024 ) as size, null as autoload
FROM wp_qfda_options
WHERE autoload = ‘yes’
UNION
SELECT ‘Autoload count’, count( * ), null as autoload
FROM wp_qfda_options
WHERE autoload = ‘yes’
UNION (
SELECT option_name, length( option_value ), autoload
FROM wp_qfda_options
WHERE autoload = ‘yes’
ORDER BY length( option_value ) DESC
LIMIT 20
)
UNION (
SELECT option_name, length( option_value ), autoload
FROM wp_qfda_options
WHERE autoload = ‘no’
ORDER BY length( option_value ) DESC
LIMIT 20
)
