WordPress.org
Get WordPress

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #54221, comment 59


Ignore:
Timestamp:
12/09/2024 08:56:06 AM (7 months ago)
Author:
kc3302
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #54221, comment 59

    initial v1  
    66
    77N.B. Anyone finding this page to resolve either issue, the SQL query in the top post needs to change from:
     8
     9{{{
    810SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
     11}}}
     12
    913to:
     14
     15{{{
    1016SELECT option_name, option_value FROM wp_options WHERE autoload IN ( 'yes', 'on', 'auto-on', 'auto')
     17}}}
     18
    1119
    1220You can also use the following which will list the size of each autoloaded option:
     21
     22{{{
    1323SELECT option_id, option_name, autoload, ROUND(LENGTH(option_value)/1024,2) AS Size_in_KB
    1424FROM wp_options
    1525WHERE autoload IN ('yes', 'on', 'auto-on', 'auto')
    1626ORDER BY Size_in_KB DESC;
     27}}}
     28
     29''[Edit: added code block tags on SQL code examples to aid readability]''