[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