299350 - sanitycheck should warn if the attachments table is near full

Status: NEW

(Bugzilla :: Administration, task)

Description

[timeless]

bmo's attachment table got full, this is probably a bad thing. but worse is that
we only found out when it happened, assuming people run sanity checks
occasionally, it'd be good if those warned about such a problem in advance of it
happening.

the following is my poor summary of justdave's description:
When the table 'attachments' is full (or near full) admins should see section
2.2.2.3 in the Bugzilla tip docs.

there's differing definitions of full, it'd have to query the DDL structure to
find out the capacity...

that max_rows and avg_row_length get multiplied by each other to get the
capacity and assume 4GB if those aren't present that max_data_length field seems
to imply a TB

that might be usable though...  all the dynamic tables seem to have 4 GB in that
column

Comment 1

[Douglas Calvert]

I don't see a 2.2.2.3 did you mean:

2.2.2.1.3. Permit attachments table to grow beyond 4GB

http://www.bugzilla.org/docs/tip/html/configuration.html#AEN448