• Resolved Poorang

    (@poorang)


    Hi

    My Slimstats DB size is huge (more than 1 GB).

    I just need pageviews number, so is there any way that I can delete or prevent records related to properties like screen resolution and other?

    I heard that it’s possible to have slimstat on a second server, but I dont know how. Is there any guide about configuring Slimstat on a second server?

    Thanks

    https://wordpress.org/plugins/wp-slimstat/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Jason Crouse

    (@coolmann)

    Hi,

    you can definitely configure Slimstat to not track client-side information. In order to do this, set the tracker to Server Mode and then enable Stealth Mode (that’s what the setting was called in versions prior to 4.3.6) or turn off Track Client Info (in version 4.3.6). This way the tracker will only track user agent, operating system and other server-side information (referrer, permalink, etc).

    You can use SQL queries to delete the data from existing columns (please make sure you backup your data first!!!):

    UPDATE wp_slim_stats
    SET resolution = NULL
    WHERE id IS NOT NULL;

    Please refer to our knowledge base to find out what the table schema is:

    https://slimstat.freshdesk.com/support/solutions/articles/5000650210-what-is-the-table-schema-used-to-store-all-the-information-

    As for using an external database on a separate server, you can purchase our premium add-on Custom DB:

    https://www.wp-slimstat.com/downloads/custom-db/

    Follow the instructions to configure it, or feel free to contact our support team at http://support.wp-slimstat.com if you have any questions.

    Best,
    Jason

    Thread Starter Poorang

    (@poorang)

    Thanks for reply.

    Because I’m using super cache plugin, I can’t set slimstat on server-side.

    Unfortunately the person who I made the website for can’t afford buying the add-on.

    Do I need this add-on for configuring slimstat on a second server?
    If not, please help me to put the plugin on a second server, please.

    I did use the query for resolution, screen_height and width and the columns are nulled, but I don’t see any change in DB size.

    Plugin Author Jason Crouse

    (@coolmann)

    Unfortunately the person who I made the website for can’t afford buying the add-on.

    I understand, however at this time that’s the only way to configure Slimstat to work with an external database. The other solution would be to install Slimstat somewhere else and then use the external tracking code (see Slimstat > Settings > Tracker) on your main site, by copying and pasting it in your theme.

    HTH,
    Jason

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