Contributions

Useful SQL queries

Here's a few useful SQL queries to run in MySQL when you are trying to debug what's happening with transients.

-- transients that are not autoloaded (should be all with expiration times)
select option_name, option_value
from wp_options
where option_name regexp '^(_site)?_transient_.*'
and autoload='no'
order by option_name;