Probably, definately the transients that have expired.
To get a list of expired transients execute the SQL command below from phpMyAdmin:
select * from wp_options where option_name in (
SELECT replace( option_name, '_transient_timeout', '_transient' ) FROM wp_options WHERE option_name like '_transient_timeout_itsec_ipcheck_%' and option_value < unix_timestamp()
union
SELECT option_name FROM wp_options WHERE option_name like '_transient_timeout_itsec_ipcheck_%' and option_value < unix_timestamp()
)
To delete:
delete from wp_options where option_name in (
SELECT replace( option_name, '_transient_timeout', '_transient' ) FROM wp_options WHERE option_name like '_transient_timeout_itsec_ipcheck_%' and option_value < unix_timestamp()
union
SELECT option_name FROM wp_options WHERE option_name like '_transient_timeout_itsec_ipcheck_%' and option_value < unix_timestamp()
)
-
This reply was modified 7 years, 7 months ago by
nlpro.
@nlpro
Thanks for the clear response. This should help.
Do note that as of the WordPress 4.9.0 release the delete_expired_transients() core function was introduced. Probably best to use this WordPress core function 😉
It seems there is also a daily CRON job running named delete_expired_transients.
So certainly worth to verify whether CRON is functioning properly in your env.