[opencms-dev] installing opencms for big sites on mysql

Hein van der Kallen hvanderkallen at xs4all.nl
Fri May 14 17:26:13 CEST 2010


When you use mysql as a databse for a big site you might end up with a table > 4Gb. 

To avoid a "table is full" error like http://www.opencms-forum.de/opencms-forum/viewthread?thread=3545

I installed the next time with two lines extra near the end of  the install-file :
ALTER TABLE CMS_CONTENTS MAX_ROWS=1000000000 AVG_ROW_LENGTH=50;

ALTER TABLE CMS_OFFLINE_CONTENTS MAX_ROWS=1000000000 AVG_ROW_LENGTH=50;

In my case in /ROOT/setup/database/mysql_41/create_tables.sql.

Hein van der Kallen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100514/7d684598/attachment.htm>


More information about the opencms-dev mailing list