Sessions table cleaniup

RT Users
1

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

2

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 :wink:

3

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: