Simon wrote:
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=10
PJS Simon,
PJS This limitation is only relevant for MyISAM tables, and your solution
PJS (MERGE engine) also applies to MyISAM only. Please note however, that
PJS MyISAM is deprecated for dbmail-2.1+ since we've stopped trying to
PJS maintain referential integrety in the database-client (dbmail).
On 11/23/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
PJS Simon,
PJS This limitation is only relevant for MyISAM tables, and your solution
PJS (MERGE engine) also applies to MyISAM only. Please note however, that
PJS MyISAM is deprecated for dbmail-2.1+ since we've stopped trying to
PJS
S ) TYPE=MERGE UNION(dbmail_messageblks_part1, dbmail_messageblks_part2)
S INSERT_METHOD=LAST;
It's rather interesting decision. I wonder is it real to build
something like an array of merged dbmail_messageblks_partX tables?
In previous maillists I have asked about big dbmail_messageblks