Table options is 532mb, still growing with tribe events info!

  • Resolved kabeza

    (@kabeza)


    6 years, 9 months ago

    Hi
    I’ve noticed my whole db dump is over 600mb
    Then I noticed the myprefix_options table is around 532mb !! so I’ve dumped it only and searched for blob stuff, but could not find anything.

    View post on imgur.com

    I noticed that maybe there’s something automated related to tribe events that is autoloading some stuff into the table.

    Please someone check these lines. This is 0.001% of the whole dump
    Notice the autoload option repeating through the whole dump with html related to tribe events

    https://pastebin.com/VM0utDZ1

    INSERT INTO au3_options(option_id,option_name,option_value,autoload)

    Is there I could do to stop this?

    Thanks a lot in advance

    • This topic was modified 6 years, 9 months ago by kabeza. Reason: added image showing line count in dump
Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter kabeza

    (@kabeza)

    Solved by installing this plugin
    https://www.ads-software.com/plugins/artiss-transient-cleaner/

    As far I’ve read, this problem seems to happen when plug-in’s author stores plug-in’s options in the wp_options table without taking care of erasing expired ones or not used

    Is this right?

    Hey @kabeza,

    Yes, you’re correct. Transients can be set with an expiration, or manually deleted.

    We have a pending bug ticket for this. Hopefully we can get some insight soon — until then, I’d say you’re doing the right thing to keep that DB under control.

    Will update when I hear something!

    Take care,
    Ed ??

    Hey there,

    Since this thread has been inactive for a while, I’m going to go ahead and mark it as resolved. Don’t hesitate to create a new thread any time you help again!

    Ed ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Table options is 532mb, still growing with tribe events info!’ is closed to new replies.