WordPress.org

1. tekperson
   Member
   Posted 11 months ago #

   Hi,
   I'm getting these entries in MySQL database that I'm not sure what they are they are like _transient_gad_cache and a long number. I am also getting ones like _transient_timeout_gad_cache I have tried to delete them but 10 minutes later I would check back and they would still be there

2. s_ha_dum (was apljdi)
   Member
   Posted 11 months ago #

   Those are transients.

3. tekperson
   Member
   Posted 11 months ago #

   What are those? Are they supposed to be there?

4. s_ha_dum (was apljdi)
   Member
   Posted 11 months ago #

   Yes and yes. Read the link I provided. The answer to your questions is in the first sentence on the page.

5. tekperson
   Member
   Posted 11 months ago #

   Is it possible to disable them? It uses up lots of MySQL storage and when I clear some options in WP-Options table I always see tons of transients and its really annoying. If I remove them they keep coming up. Can you give me easy step by step instructions?

6. s_ha_dum (was apljdi)
   Member
   Posted 11 months ago #

   Annoying is one thing, but is it actually causing any harm? Remember, it is a caching mechanism. In principal, it should be increasing performance. I don't if you can globally disable the feature, but I wouldn't without really understanding it.

7. Curtiss Grymala
   Member
   Posted 11 months ago #

   You can't disable all of them, but you could probably disable most of them by deactivating all of your plugins and using WordPress without any plugins. WordPress itself doesn't create very many transients; but a lot of plugins use transients to store data.

8. tekperson
   Member
   Posted 11 months ago #

   I don't use plugins that are useless. I use all of my plugins. Is it possible to remove them? I don't really care about caching.

9. s_ha_dum (was apljdi)
   Member
   Posted 11 months ago #

   Is it possible to remove them?

   No, you cannot.

   I don't really care about caching.

   No offense, sincerely, but you seem to care about the transient database entries for what I am tempted call aesthetic reasons, rather than reasons that have to do with how well your site functions. That doesn't make much sense.

10. tekperson
    Member
    Posted 11 months ago #

    I have limited MySQL database storage and when I delete the entries I seem to clear some memory.

11. RavanH
    Member
    Posted 10 months ago #

    I seem to have run into the same problem. The options table in the DB of one of my sites has bloated to nearly 60 MB which I would expect to be about 1 or 2 MB max. It's not a large site, the posts table is about 2.3 MB, and it's hosted low budget. The size of the options table now effectively breaks the site because the DB size has gone over the allowed size of the low budget provider.

    Speed is nice but if one day it is going to break your site up like this, I don't see the advantage. A ticking time bomb...

    Or is this bloating an indication of some faulty plugin? I've yet to find the plugins that is causing all these transient entries.

    From the API documentation I gather these entries are temporary but who/what will actually take care of clearing expired ones form the database? Should WP be doing this or is it left to the plugin that spawned all of them into the DB in the first place?

    Thanks for any info on this subject :)

12. RavanH
    Member
    Posted 10 months ago #

    UPDATE: I found the plugin that spawned all the transient entries ( see http://wordpress.org/support/topic/plugin-google-analytics-dashboard-over-50mb-of-transient-data-in-my-wp_options-table?replies=1 ) but no clue as to why expired entries are not cleared from the table...

    Clearing the table with the MySQL query:
    

    DELETE FROM 'wp_options' WHERE 'option_name' LIKE ('_transient_%')

    did solve the immediate size problem but I fear I'll have to do without the plugin to prevent buildup again...

Reply

You must log in to post.