HUGE MySQL wp_akp_impressions_log

  • Resolved Iamhere

    (@iamhere)


    9 years, 8 months ago

    Hi Ash

    I have an issue with the log in MySQL.

    Currently I have:
    wp_akp_impressions_log 1,275,173 entries (33.6 MiB)
    wp_akp_impressions_expire 141,563 entries (3.8 MiB)

    I need to reduce / remove these – is it possible to set a log expiration time? These entries are bloating the mySQL DB. Can I delete this DB table and it will safely recreate a new one, or should I empty the tables or what do you suggest?

    My current settings are:

    Track Impressions Yes
    Track Clicks Yes
    Click Expiry Time Length 6hrs
    Impression Expiry Time Length 24hrs

    Thanks for help.

    https://wordpress.org/plugins/adkingpro/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Iamhere

    (@iamhere)

    9 years, 7 months ago

    In case anyone else reads this, here’s what I did;

    1) Empty the following tables in MySQL
    wp_akp_impressions_log
    wp_akp_impressions_expire

    2) Turn off tracking in plugin

    Problem solved.

    gone2alpine

    (@gone2alpine)

    9 years, 6 months ago

    Has this issue been resolved? Ad King Pro does exactly what I need, but turning off tracking is not an acceptable solution, as I need the tracking to report to clients.

    Plugin Author Ash Durham

    (@ashdurham)

    9 years, 6 months ago

    Hey guys,

    As mentioned in many previous posts, the built-in tracking setup do not suit high traffic situations (probably even medium traffic over time).

    Due to this, I have implemented a Google Analytics solution which is HIGHLY preferred. I suggest you both adapt to this.

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘HUGE MySQL wp_akp_impressions_log’ is closed to new replies.