PDA

View Full Version : What Happens When Server, DB is Restarted


emailapphost
03-17-2009, 07:01 AM
I have a hosting provider that is having problems with the servers.
So he restarts the DB and boots the server several times per day.

For me I am back logged in automatically when the server comes up again, I do not quite know how this happens (is there a cookie in the browser?).

But I see that my list of guests (sometimes hundreds) are gone when the boot is done.

Does restarting db or booting the server "kick out" registered users so they need to log in again?

Marco van Herwaarden
03-17-2009, 08:34 AM
Restarting the (MySQL) server will clear all HEAP (in memory) tables. vBulletin used 2 HEAP tables to store sessions: "session" & "cpsession". These tables are cleared on the start of the MySQL server, destroying any active sessions. If you had checked the Remeber Me when previously logging in, a new session will be created based on the cookies stored on your PC when you visit the board again.