Database size limit

Okay… I’ve hit the 4gb size limit… any recommendations?

We’re running Solaris 8/Sparc, so it’s not a filesystem thing…

Teo de Hesselle, Diplomacy is the art of saying
"nice doggy" until you
Unix Systems Administrator, can find a rock.
University of Technology, Sydney.

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?

Dan Shearer
Open Source Manager
Mob: +61 411 49 1800
Tel: +61 8 8130 3104
dan@tellurian.com.au

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