[rt-users] sessions table cleaniup

[Joby Walker]

There is a script in the BestPractical wiki to do this.  We purge any 
Session older than 1 day, but might soon move that to 2 hours.

jbw

Jesse Vincent wrote:
> 
> 
> On Tue, Jan 31, 2006 at 11:33:18AM +1030, Luke Vanderfluit wrote:
>> Hi.
>>
>> At our organisation we use RT intensively (and try to deal with 
>> performance problems :-).
>> We are trying to improve performance and have noticed that the Sessions 
>> table is extremely large.
>>
>> I'm wondering if it would help to clean up this table regularly to keep 
>> it small.
>> Any input appreciated.
> 
> We released a tool a while ago to do just that. But yes, that's not a
> bad plan ;)
>> This is the output from the 'show table status' command for the sessions 
>> table:
>> sessions                | InnoDB | Dynamic    | 1539242 |           3497 
>> |  5383782400 |            NULL |            0 |         0 |           
>> NULL | NULL        | NULL        | NULL       |                | InnoDB 
>> free: 11264 kB
>>
>> as you can see the data is 5383782400.
>> Any comments on the session table and its use would be welcome.
>>
>> Thanks.
>> Kind regards.
>>
>> -- 
>> Luke
>>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>>
>> Download a free sample chapter of RT Essentials from O'Reilly Media at 
>> http://rtbook.bestpractical.com
>>
>> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
>> San Francisco - Find out more at 
>> http://bestpractical.com/services/training.html
>>
>