- This topic has 5 replies, 2 voices, and was last updated 10 years, 6 months ago by .
Viewing 6 posts - 1 through 6 (of 6 total)
Viewing 6 posts - 1 through 6 (of 6 total)
- You must be logged in to reply to this topic.
Support site for Tips and Tricks HQ premium products
by
Tips and Tricks HQ Support Portal › Forums › WP eMember › WP eMember General Questions › Big table and cleaning procedure
Tagged: clean database, database
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
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.
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
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?
the website has just 4 months activity but yes i can imagine now with over 1400 users that this table can grow fast
Congratulations