Useful SQL queries for dealing with WordPress optimizations.

queries.mysql

# Get a particular option entry.
SELECT * FROM wp_options WHERE option_name="<OPTION_NAME>" LIMIT 1000;

# Make sure an option to not autoloaded.
UPDATE wp_options SET autoload = 'no' WHERE option_name="<OPTION_NAME>";

# Get the size of total autoladed values.
SELECT SUM(LENGTH(option_value)) as autoload_size FROM wp_options WHERE autoload='yes';
                  
# Get the top 10 most "expensive" autoloaded values.                  
SELECT option_name, length(option_value) AS option_value_length FROM wp_options WHERE autoload='yes' ORDER BY option_value_length DESC LIMIT 10;
                  
# Get transient values.                  
SELECT * FROM wp_options WHERE option_name LIKE("%transient%") LIMIT 1000;

# Get the size of total transient values.
SELECT SUM(LENGTH(option_value)) as transients_size FROM wp_options WHERE option_name LIKE("%transient%") ;