Forums » SEPHP Help and Tips

Empty table "engine4_core_session"

    • 43 posts
    January 10, 2018 4:14 AM EST

    Hello everyone,

    i just figured out that the table engine4_core_session is about 1,6GiB with about 3mio datasets.

    Rumors after google search telling me that i can empty the table, because this is for temporary reasons only. @SocialEngine. Can I? 

    thx!

    • Moderator
    • 4263 posts
    January 10, 2018 5:34 AM EST

    I suggest backing up the database and trying it on a development site. I've never tried it. Be careful the sites you go on as there are unsafe sites out there. Sites with nulled products are pirate sites and contain hackers, malware and other bad things.

    • 43 posts
    January 10, 2018 9:06 AM EST

    hmm... actually it's not possible to move the data to a dev env.

    contract and privacy regulations apply to us

    would be great to get an official info if this is recommended or not.

    the DB-Table is quite large. is this a wanted product result or not?


    This post was edited by oddity Code at January 10, 2018 9:06 AM EST
    • Moderator
    • 4263 posts
    January 10, 2018 10:10 AM EST
    Sebastian Freytag said:

    hmm... actually it's not possible to move the data to a dev env.

    contract and privacy regulations apply to us

    would be great to get an official info if this is recommended or not.

    the DB-Table is quite large. is this a wanted product result or not?

    Then you could just create a test environment and generate some sessions. Delete the sessions and see if it works. I'll see if I can find an old thread about this as well.

    • Moderator
    • 4263 posts
    January 10, 2018 10:18 AM EST

    I thought we had an old forum thread for this but can't find it. It may have been in github.

    *Update - I found it in our github list of improvements. We will be making an improvement in an upcoming release to delete the entry in the engine4_core_session table when a user logs out in order to keep this table from becoming massive. I suggest to backup the database and try truncating this table. The only issue that it may cause will be that the users who are currently logged in will be logged out.


    This post was edited by Donna at January 10, 2018 10:18 AM EST
    • 43 posts
    January 11, 2018 9:18 AM EST

    improvement sounds nice to me