php - Kohana Session Table -


Currently I'm hosting a website with ~ 10k unique visitors and clicks ~ 6 per user.

Watches about 60k pageviews for so many days.

I use Kohana 3.2 and saves session datas from each user in the "Sessions" table. Perform each page request in this table timestamp refresh!

The mysql process is getting very low ..

So my question is:

<<>

    • Should I stop using the table to save the session

    • How do I $ _SESSION Instead of the value from the table?

    • Is there any other option to handle this problem now? We order more server capacity, but wait.

    EDIT: Maybe it's possible to reject all these "updates" by every click is sufficient ..?

    • OK. At least this table was enough to shorten the "session" - for the first moment. There were more than 1kk records - that is why database operations are slowing down ..?

    It may be just a simple mysql problem, and when I change it to NOSQL, then it is enough.


    Comments

    Post a Comment