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).
PJS> So you better start thinking about moving to innodb, I guess. PJS> Simon wrote: >> Hi There, >> >> 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; >> >> But before i do this, im just wondering if there is anyone out there >> who has done this before, and it there was any issues/TFYPs in doing >> so? >> >> Thanks for any replies in advance! >> >> Simon >> _______________________________________________ >> Dbmail mailing list >> Dbmail@dbmail.org >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> Yes, my previous question about merged tables is not valid anymore :) But question about big dbmail_messageblks still actual. Will dbmail 2.0.x solve this problem ?
