Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

Big table and cleaning procedure

by

Tips and Tricks HQ Support Portal › Forums › WP eMember › WP eMember General Questions › Big table and cleaning procedure

Tagged: clean database, database

  • This topic has 5 replies, 2 voices, and was last updated 10 years, 12 months ago by wzp.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • May 12, 2014 at 10:08 pm #10817
    totalwebdesign
    Member

    Hello again ;-)

    I made a backup last night of the database (i do my homeworks) and notice that the wp_wp_auth_session_tbl was quite big compare to others (like 10mb).

    Can i clean this table?

    I assume it’s strange question but i want to be sure before i proceed (+1400 user on this website)

    Thank you

    May 12, 2014 at 10:34 pm #62920
    wzp
    Moderator

    It’s supposed to delete entries as users log out, or if it detects an “invalid entry” that is more than 6 hours old.

    I suppose, if it is really bothering you; you can wait until a time when you’re sure nobody is logged in, and then delete all the rows.

    May 12, 2014 at 10:40 pm #62921
    totalwebdesign
    Member

    well i am just asking because i was suprise to have this table so big. Do you think there is something i forgot to set propely that explain this size of table?

    It s 1am here so i guess i can empty it

    May 12, 2014 at 10:59 pm #62922
    wzp
    Moderator

    No, but imagine this: how many times over the years have you or anyone else logged into this forum, and then closed the browser without first logging out?

    May 13, 2014 at 12:57 am #62923
    totalwebdesign
    Member

    the website has just 4 months activity but yes i can imagine now with over 1400 users that this table can grow fast ;-)

    May 13, 2014 at 12:59 am #62924
    wzp
    Moderator

    Congratulations 8)

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2025 | Tips and Tricks HQ