It looks like we have reached the Max_data_length for the
dbmail_messageblks table, this is currently 4294967295 (which is 4GB
im gussing - which is about right). From the mysql docs, this can be
easliery solved by running:
ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn;
Any idea what i would put in the AVG_ROW_LENGTH= here?
From the mysql docs: "You have to specify AVG_ROW_LENGTH only for
tables with BLOB or TEXT columns; in this case, MySQL can't optimize the
space required based only on the number of rows."
show table status from dbmail like 'dbmail_messageblks';
give me an AVG_ROW_LENGTH of 35381, is this what i use here?
Thanks!!!
Simon
