Today, I had to re-enter my login credentials for this forum. That has fortunately not been necessary for a long time...
Is the need to re-login because of the following change according to yesterday's "Maintenance log" entry?
(An expiry timespan for 1000 days could not be reached for this forum, as the site itself is not that old, methinks...)
If so, I guess I would not consider this an improvement...
Yes, that's why you need to log in again. The way Django saves login information is through a row in a table containing session data. A new row is created every time you connect with a different browser session, i.e. if you connect to the forum and authenticate (whether manually or through a cookie), then close and re-open the browser and do it again, that's two rows. Unless you manually click "Logout", the rows are not deleted until they expire. When I restarted the forum, there were over 2.8 million rows in this table, taking up about 95% of the total database size.
I've moved the table in question to its own dbspace to reduce fragmentation, and I did an unload/reload on the database which reduced its size from 1.1 GB to about 80 MB. We also decided that having three years worth of rows in this table was a waste, and so we reduced the cookie expiry time to 100 days.
answered 23 Oct '13, 06:46