Hi Ferran:
On Mon, 07 Jul 2008, Ferran Jorba wrote:
> I've noted that our sessiongc, executed daily, also lasts about 3
> hours, and I cannot see this index. May anybody teach me (a) how to
> confirm (or deny) that we don't have it
$ echo "SHOW INDEXES FROM session;" | /opt/cds-invenio/bin/dbexec
> and (b) how to create it?
$ echo "ALTER TABLE session ADD INDEX uid (uid);" | ${prefix}/bin/dbexec
> I'm afraid that this index creation hasn't been executed in any update
> procedure.
The index should have been added during upgrade to v0.5.0, please see
"update-v0.5.0-tables" target in Makefile.am.
Note that as of CDS Invenio v0.99.1 (to be released this week) you will
have a new option CFG_WEBSESSION_DIFFERENTIATE_BETWEEN_GUESTS that will
help to keep your 'session' table small.
<https://savannah.cern.ch/task/index.php?6814>
Best regards
--
Tibor Simko ** CERN Document Server ** <http://cds.cern.ch/>
