3.6.3 - Cleaning Sessions

I had it on my todo list to go and read:

http://wiki.bestpractical.com/index.cgi?CleanupSessions

and implement it on our site before it got out of hand. I first looked
to see how many sessions I had, and I had none!

SQL> select count(*) from sessions;

COUNT(*)
0

SQL> select * from sessions;

no rows selected

Should I have sessions here? I have a ton of session files on disk –
is that where sessions are being cached, instead of the DB? If so,
which is better? Is there a way to safely clear up old session files >
XX days old?

Thanks!

Regards,

joe
Joe Casadonte
joe.casadonte@oracle.com

========== ==========
== The statements and opinions expressed here are my own and do not ==
== necessarily represent those of Oracle Corporation. ==
========== ==========

I had it on my todo list to go and read:

Request Tracker Wiki

and implement it on our site before it got out of hand. I first
looked to see how many sessions I had, and I had none!

The default for RT on Oracle (which I presume you’re running :wink: is to
store sessions on disk, due to some historical bugs in
Apache::Session’s oracle support. (Though I believe they’re now
resolved)
-jesse

PGP.sig (186 Bytes)

The default for RT on Oracle (which I presume you’re running :wink:

I had this running initially with MySQL but the second time I started it
up, the hard drive started spinning faster and faster and the heads rose
up and then plunged into the disks, spewing magnetic grey matter all
over the interior of the box. At the same time, red lights started
flashing in the server room and blast doors fell, locking me in. A
camera descended from the ceiling and started panning across the room,
searching. I hid under the desk, whimpering…

is to
store sessions on disk, due to some historical bugs in Apache::Session’s
oracle support. (Though I believe they’re now resolved)

Can I simply delete old files? If I have persistent sessions enabled
via cookies for, say, two weeks, could I simply and safely delete all
session files older than 15 days?

Regards,

joe
Joe Casadonte
joe.casadonte@oracle.com

========== ==========
== The statements and opinions expressed here are my own and do not ==
== necessarily represent those of Oracle Corporation. ==
========== ==========

is to
store sessions on disk, due to some historical bugs in Apache::Session’s
oracle support. (Though I believe they’re now resolved)

Can I simply delete old files? If I have persistent sessions enabled
via cookies for, say, two weeks, could I simply and safely delete all
session files older than 15 days?

100% ok.