stream_meta table cleanup?

  • victorkun

    (@victorkun)


    3 months, 1 week ago

    Seems it keeps logs going back to 2014.
    Yes, we have an old site.
    How do we clean it up and only keep Jan 1, 2025 until now? Is it via mysql command? Because I don’t see any way to do so in the limited “Settings” selections…

    The “Settings” seems to have only few options :

    General tab :
    Keep records indefinitely –> is NOT checked…never has been…
    Role access –> only Administrator

    Exclude tab :
    No rules specified, but no option for date retention

    Advanced tab :
    Comment Flood Tracking –> is NOT checked…never has been
    WP Cron Tracking –> is NOT checked…never has been

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter victorkun

    (@victorkun)

    3 months, 1 week ago

    I have a feeling I would also need to delete items in the “stream” table as well???

    Thread Starter victorkun

    (@victorkun)

    3 months, 1 week ago

    Our stream_meta table’s last meta_id = 2949233

    If I start deleting older records, should I have to re-order all remaining/retained records starting from “1”? Same with the stream table?

    That’s why I’m hesitant to just use mysql to do all these actions…if there were in-plugin records maintenance, I’m sure the plugin would have done all that automatically…

    Hence I hope to get guidance here…..thx!!!

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

You must be logged in to reply to this topic.