Delete old, expired transients from WordPress options table, to prevent them from bloating your database and even slowing down your website..
It uses PHP time to determine whether transients are expired, not the time.
English — English team.
French — French team.
Hungarian — Hungarian team.
Spanish — Spanish translation team..
Here's few SQL queries to run MySQL when you trying to debug what's happening with transients. -- transients that are not autoloaded select option name, option value from wp options where option name regexp.
order by option value desc -- transient expirations with paired transients select t1.option name, t2.option name, t1.option value, from unixtime as expiry time from wp options t1 left join wp options t2 on t2.option name = replace where t1.option name regexp.
order by t1.option value desc -- expired transient expirations with paired transients select t1.option name, t2.option name, t1.option value, from unixtime as expiry time from wp options t1 left join wp options t2 on t2.option name = replace where t1.option name regexp.
Read more