Transients in the wp_options database

  • Resolved andymiller

    (@andymiller)


    6 years, 11 months ago

    Hi

    I’ve just done a search in phpMyAdmin to find out why my wp_options file is so big. 13 of the top 14 largest items are all transients that, I’m assuming from the names, are from WP Typography. I’ve listed them below. My question is am I safe to delete these?

    I have been using a database optimising plugin and changed the settings to delete expired transients, but that doesn’t seem to have deleted them. So I don’t know if they are unexpired transients, or if there is some other reason why they weren’t deleted.

    I hope this isn’t a dumb question!

    Thanks for your help and for your work on the plugin.

    EDIT: I thought that this might be connected to W3TC, so I tried emptying the object cache, but that doesn’t seem to have made much difference.

    _transient_typo_php_hyphenator_cache_E@C
_transient_typo_php_hyphenator_cache_E@D
_transient_typo_php_settings_e4d7889432e47c08c61071da5bd54fff_E@D
_transient_typo_php_hyphenator_DAA
_transient_typo_php_hyphenator_DA@
_transient_typo_php_hyphenator_DBB
_transient_typo_php_settings_e4d7889432e47c08c61071da5bd54fff_E@C
_transient_yst_sm_page_1:4mf24_3lpAo
_transient_typo_php_7b8f351f6f402656521938cfb59dd1dd_D@B
_transient_typo_php_87bf4e7dd7f0e171aaa8f911301c4ca7_DBB
_transient_typo_php_7b8f351f6f402656521938cfb59dd1dd_DA@
_transient_typo_php_ec6d0efd886059805da15a10851c730b_DA@
_transient_typo_php_ec6d0efd886059805da15a10851c730b_DAA
_transient_typo_php_e9f23548b1272c55acd0fd7dfd31308f_DA@
    • This topic was modified 6 years, 11 months ago by andymiller.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author pepe

    (@pputzer)

    @andymiller: You can safely delete all transients named _transient_typo_php*, they are all outdated. If you were not using a persistent object cache, only three transients would be re-created by the current version of wp-Typography (with slightly different naming, but the same prefix).

    (When you have a persistent object cache plugin enabled, transients are not stored in the options table, so clearing the object cache has no effect on old entries in that table.)

    PS: Please note that _transient_yst_sm_page_1:4mf24_3lpAo in the list above is not one of mine.

    • This reply was modified 6 years, 11 months ago by pepe. Reason: Clarified the relationship between OC and options
    Thread Starter andymiller

    (@andymiller)

    Hi Pepe

    Thanks for the speedy reply.

    Yep, I’m guessing the yst in the other one stands for Yoast.

    Have a good Sunday!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Transients in the wp_options database’ is closed to new replies.