Developers,

 

 

After performing a software upgrade and server reboot, I came across this problem.  My koha.sessions table is over 13 million entries.  This seems to indicate that entries into the table were never removed, and that may help to explain why my backup mysqldumps are increasing by around 4MB daily.

 

Chris Cormack suggested that I do a mysqldump of sessions with the no-data option set, then reimport it into the database to clear it out.  I’ve finally gotten sessions to tell me what indexes it has on it, so that can be recreated as well.  Are there any risks to doing this that I’m not factoring in?

 

More generally, what could be causing my sessions table to get so out of hand?  Permissions, perhaps?  Something in the code being off?

 

Any ideas or feedback would be appreciated.  Thanks!

 

 

 

Ian Walls

Systems Integration Librarian

NYU Health Sciences Libraries

550 First Ave., New York, NY 10016

(212) 263-8687

 

 




------------------------------------------------------------

This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is proprietary, confidential, and exempt from disclosure under applicable law. Any unauthorized review, use, disclosure, or distribution is prohibited. If you have received this email in error please notify the sender by return email and delete the original message. Please note, the recipient should check this email and any attachments for the presence of viruses. The organization accepts no liability for any damage caused by any virus transmitted by this email.

=================================