[rt-users] sessions table cleaniup

[Jesse Vincent]

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
> 

--