[opencms-dev] opencms 7.0.5 table CMS_CONTENTS gets huge...

Alejandro Alanis alanis at synyx.de
Wed Oct 8 16:14:37 CEST 2008


Hello OpenCms'ers,

i have an Installation of OpenCms7.0.5 (on mysql) here, which, after
deleting and importing modules several times, grows to unexpected sizes
around several GB.

A fresh Installation begins with some little 40MB. After deleting and
importing the same 2-3 modules like 10-20 times (in ~10 days), the table
CMS_CONTETS grew to 2GB. The File-History was turned OFF after Installation.

Inspecting this behaviour i think the problem lies within the
publish-mechanism or the file-history.

Fresh Install:
select count(*) from CMS_CONTENTS where ONLINE_FLAG = 1;
~ 2500 entries
select count(*) from CMS_CONTENTS where ONLINE_FLAG = 0;
~ 5 entries

Same Database after 10 days of module-development:
select count(*) from CMS_CONTENTS where ONLINE_FLAG = 1;
~ 2500 entries
select count(*) from CMS_CONTENTS where ONLINE_FLAG = 0;
~ 12500 entries

The last time i re-installed i had even 25000 entries with online_flag=0

I must be missing some new configuration option for versioning or
similar - or there is a bigger bug in this version :)
I already searched the bugtracker but didnt find any direct hints.

Any ideas?

Thx
-- 
Alejandro Alanis



More information about the opencms-dev mailing list