• Resolved katart17

    (@katart17)


    I noticed that the wp_options table in my WordPress database is very large and it looks as if most of the rows are for _transient_itsec_ipcheck_xx.xx

    Can these be removed?

Viewing 3 replies - 1 through 3 (of 3 total)
  • 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.
    Thread Starter katart17

    (@katart17)

    @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.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘WP_Options Table is full of itsec_ipcheck Rows’ is closed to new replies.