wfLocs table very huge

  • Resolved Treebeard

    (@malawimama)


    5 years, 1 month ago

    I noticed that the wfLocs table is getting ginormous. What exactly is stored in that, live traffic? Is there any reason why this needs to be so big?

Viewing 1 replies (of 1 total)
  • wfdave

    (@wfdave)

    5 years, 1 month ago

    Hi @malawimama,

    The wfLocs table keeps track of the city, region, and country of IP addresses that visit your site.

    If you’re getting a large amount of unique traffic, I would recommend clearing out this table with the following query:

    DELETE FROM wp_wflocs WHERE ctime < UNIX_TIMESTAMP(DATE_ADD(CURDATE(),INTERVAL -7 DAY));

    This will delete location data from IP addresses older than a week.

    Dave

Viewing 1 replies (of 1 total)
  • The topic ‘wfLocs table very huge’ is closed to new replies.