[rt-users] sessions table cleaniup

Luke Vanderfluit lvanderf at internode.com.au
Mon Jan 30 20:03:18 EST 2006


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.

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




More information about the rt-users mailing list