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;
Got an updated suggestion on how to tackle this one. Any comments are
welcome:
Instead of dumping/altering etc etc. (Which keeps DBmail offline for a
fair amount of time)... Use a MERGE table:
- Rename dbmail_messageblks to mdbmail_messageblks_part1
- create table dbmail_messageblks_part2 using the dbmail_messageblks
stucture
- CREATE TABLE dbmail_messageblks (column defs,) TYPE=MERGE
UNION(dbmail_messageblks_part1, dbmail_messageblks_part2)
INSERT_METHOD=LAST
Then just keep adding 4GB dbmail_messageblks_partX when needed.
??
Simon