Simon,

This limitation is only relevant for MyISAM tables, and your solution
(MERGE engine) also applies to MyISAM only. Please note however, that
MyISAM is deprecated for dbmail-2.1+ since we've stopped trying to
maintain referential integrety in the database-client (dbmail).

So you better start thinking about moving to innodb, I guess.


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
> 

-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl

Reply via email to