Why is clicks table so large?

  • Resolved bkjproductions

    (@bkjproductions)


    3 years, 3 months ago

    wp_ta_link_clicks_meta has 355K rows, taking up 38MB of space. Is there a reason this table gets so large? Can it auto-flush after a certain amount of time?

    I see there is a setting for Trim stats older than X months
    So with a value 0, that means “store an infinite number of clicks”?

    Is there a way to flush it, maybe by entering -1 or something? (I hate to have to truck all the way into PHPmyadmin to clear this, just testing something at the moment…)

Viewing 1 replies (of 1 total)
  • Plugin Author Caseproof

    (@caseproof)

    Hi,

    Enabling the option to auto-trim the clicks table should help keep its size down.

    Start with 90 days or so and see how that goes. The trimming happens in the background, so it won’t work immediately after you enable the setting, it will take some time.

    Or

    You would need to truncate these two tables:

    TRUNCATE TABLE wp_ta_link_clicks;
    TRUNCATE TABLE wp_ta_link_clicks_meta;

    You might need to change the wp_ part if your database uses a different prefix.

    Please make sure to create a database backup before proceeding in case something goes wrong.

Viewing 1 replies (of 1 total)
  • The topic ‘Why is clicks table so large?’ is closed to new replies.