Sessions table size

RT Users
1

My sessions table in rt (MySQL) is 1.2Gb. Is this normal? I thought it
was fairly temporary data? We have only about 100 users, more automated
jobs really but I was surprised to see this so large. It’s accounts for
nearly 50% of the size of the whole DB.

PK

Philip Kime
NOPS Systems Architect
310 401 0407

2

|# My sessions table in rt (MySQL) is 1.2Gb. Is this normal? I thought it
|# was fairly temporary data? We have only about 100 users, more automated
|# jobs really but I was surprised to see this so large. It’s accounts for
|# nearly 50% of the size of the whole DB.
|#

http://wiki.bestpractical.com/index.cgi?CleanupSessions

            Tim Rosmus <trosmus@nwnexus.net>
               Postmaster / USENET / DNS
            Northwest Nexus Inc. / NetOS Inc.
3

Groan, can’t believe I missed this, many thanks.

PK-----Original Message-----
From: Tim Rosmus [mailto:trosmus@nwnexus.net]
Sent: Wednesday, February 28, 2007 1:44 PM
To: Philip Kime
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] sessions table size

On Wed, 28 Feb 2007, Philip Kime wrote:

|# My sessions table in rt (MySQL) is 1.2Gb. Is this normal? I thought
|it # was fairly temporary data? We have only about 100 users, more
|automated # jobs really but I was surprised to see this so large. It’s
|accounts for # nearly 50% of the size of the whole DB.
|#

http://wiki.bestpractical.com/index.cgi?CleanupSessions

            Tim Rosmus <trosmus@nwnexus.net>
               Postmaster / USENET / DNS
            Northwest Nexus Inc. / NetOS Inc.