Big size of nodebb.sessions in MongoDB



  • Hi. I have a little problem with MongoDB storage - my collection named "nodebb.sessions" grows too fast after only few month of live working
    {
    "name": "nodebb.sessions",
    "count": 2821032,
    "size": 687468454,
    "avgObjSize": 243,
    "storageSize": 304398336,
    "totalIndexSize": 215842816,
    "indexSizes": {
    "id": 188940288,
    "expires_1": 26902528
    }
    }
    can I truncate it? or something else happened with forum? or its normal& thanks in advise.


  • Admin

    In mongo cli you can run db.sessions.find().pretty() and check the max age and expires values, see if there is anything wrong there.



  • Thanks. here is output
    .......
    {
    "_id" : "zudIEAcDN-TdO1EoY8ezdf_TEd6btx3a",
    "session" : "{"cookie":{"originalMaxAge":1209600000,"expires":"2017-11-18T15:29:02.913Z","secure":true,"httpOnly":true,"path":"/"}}",
    "expires" : ISODate("2017-11-18T15:29:02.913Z")
    }
    {
    "_id" : "yoLR3qVOSjfv3_lEjza0FKKcgagQJ24P",
    "session" : "{"cookie":{"originalMaxAge":1209600000,"expires":"2017-11-23T06:12:31.671Z","secure":true,"httpOnly":true,"path":"/"}}",
    "expires" : ISODate("2017-11-23T06:12:31.671Z")
    }
    {
    "_id" : "15-HQ7qqcI6mlu2I7w569qtteZm2fkIm",
    "session" : "{"cookie":{"originalMaxAge":1209599999,"expires":"2017-11-30T12:25:04.445Z","secure":true,"httpOnly":true,"path":"/"}}",
    "expires" : ISODate("2017-11-30T12:25:04.445Z")
    }
    .......
    what do you think - is everything normal?


  • Admin

    Looks normal, the first entry should expire and get removed from the sessions collection in 2 days, you can check back and see if it was actually removed. Do you have a lot of traffic?



  • Thanks - I will check. Not a lot of traffic for now, but few days ago it was ddos attack on us - may it be the reason of my trouble?


  • Admin

    That would certainly do it, you can remove all the sessions from that date by running a mongo query if you want.



  • Thanks a lot and for fast answer!



  • Everything good. session was sucsessfully deleted after expired. and NodeBB has good resistant to attacks like ddos under 1.5 million requests by day!


 

Suggested Topics

  • 2
  • 47
  • 1
  • 1
  • 2
| |