[rt-users] Database size limit

[Teo de Hesselle]

On Mon, Jul 15, 2002 at 06:33:18PM +0930, Dan Shearer wrote:
> On Mon, 15 Jul 2002, Teo de Hesselle wrote:
> 
> > Okay... I've hit the 4gb size limit... any recommendations?
> > 
> > We're running Solaris 8/Sparc, so it's not a filesystem thing...
> 
> What database? How many tickets?

MySQL.

Basically what happened is that I reached the mySQL 4gb database size limit,
and had to execute

	ALTER TABLE Attachments MAX_ROWS=500000 AVG_ROW_LENGTH=40000

You can check your own table health by doing:

	show table status from rt2 like 'Attachments';

Relevant Section now shows:

Avg_row_length | Data_length | Max_data_length
         28319 |  4261361424 |   1099511627775

(And yes, that's a bloody big number).


-- 
Teo de Hesselle          | Microsoft has a new version out, Windows XP, which
PGP Key: 18C35A2E Print: | according to everybody is the ``most reliable Windows
443C C43F 57C4 18C3 5A2E | ever.'' To me, this is like saying that asparagus is
5F8D 8A54 ECDF 74B6 990C | ``the most articulate vegetable ever.'' --Dave Barry