Hello Tibor,
>> 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
So I do have it, right? (sorry for my low MySQL skills ;-)
$ echo "SHOW INDEXES FROM session;" | dbexec
Table Non_unique Key_name Seq_in_index Column_name
Collation Cardinality Sub_part Packed Null Index_type
Comment
session 0 session_key 1 session_key A 752002 NULL
NULL BTREE
session 1 uid 1 uid A 752002 NULL NULL
BTREE
>> and (b) how to create it?
>
> $ echo "ALTER TABLE session ADD INDEX uid (uid);" | ${prefix}/bin/dbexec
Hmmm. I believe that I can execute it even with concurrent users,
right, and probably it is safe even if this index already exists, but
your advices will be much welcome.
However, if we do have it, it still takes too much in our site. I'm
afraid we'll have to do some MySQL maintenance.
> The index should have been added during upgrade to v0.5.0, please see
> "update-v0.5.0-tables" target in Makefile.am.
I see. I was looking at a recent (0.92.1) tabcreate.sql, so I didn't
spot it.
> 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>
Good!
Thanks again,
Ferran
PS Tomorrow I won't be in the office, sorry if I don't reply promptly
