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