yanknudtskov
10/10/2017 - 8:02 AM

Select large database entries with autoload true in options table and display size in bytes #optimization #database #wordpress

Select large database entries with autoload true in options table and display size in bytes #optimization #database #wordpress

wp-options-large-entries.sql
content_copyfile_download
SELECT option_name, length(option_value) AS option_value_length FROM wp_options WHERE autoload='yes' ORDER BY option_value_length DESC LIMIT 200;