Hi Ferran: On Mon, 07 Jul 2008, Ferran Jorba wrote: > So I do have it, right?
Yes, you have. > However, if we do have it, it still takes too much in our site. If you can afford to (1) stop the service for a short time, (2) force logout on every user, and (3) delete all temporary baskets that your guest users might have created even recently, then you can run sessiongc in the following way: $ sudo apachectl stop $ echo "TRUNCATE session" | /opt/cds-invenio/bin/dbexec $ echo "DELETE FROM user WHERE email=''" | /opt/cds-invenio/bin/dbexec $ sudo apachectl start $ sessiongc e.g. once per week every Sunday at 23:30. This should be much better for you than running sessiongc in the usual way. The price to pay is notably the (short) downtime of the service while the session/user tables are being cleaned, which is why I'd advise you to run it only seldomly (e.g. when your 'session' table becomes ~2 GB big or so) and only during the time when your users are not usually active (e.g. every Sunday night at 23:30). As I mentioned, this won't be needed after you upgrade to the forthcoming CDS Invenio v0.99.1. Best regards -- Tibor Simko ** CERN Document Server ** <http://cds.cern.ch/>
