[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