[opencms-dev] OpenCMS bug? Delete content everywhere, DB is still too large (10GB+)

[Deiverson Silveira]

Hi,

In version 7.5.4, is fixed this problem:
* Fixed issue #1949: Database size does not decrease after (completely)
deleting resources

Regards,

Deiverson Silveira

2011/7/28 gleb makarov <gleb.a.makarov at gmail.com>

> Hello everyone,
>
> We were trying to reduce the size of the DB by deleting the content and
> history versions, but its size wasn`t decreased. We had the same problem on
> 7.5.2 version, and tried to clean up the DB after upgrading to 7.5.4, but
> still couldn`t reduce its size.
>
> Does someone still has the same problem on 7.5.4?
>
> 2011/3/11 Mario Jäger <m.jaeger at alkacon.com>
>
>> Hello,
>>
>> FYI: This issue is fixed in the CVS Head now:
>> http://bugzilla.opencms.org/show_bug.cgi?id=1949
>>
>> Kind Regards,
>> Mario.
>>
>> Am 11.02.2011 11:11, schrieb Michael Emmerich:
>> > Hello Ignacio,
>> >
>> > I made a little test here to try to reproduce this (on OpenCms 7.5.3)
>> >
>> > 1) Copy a complete site and publish it
>> >
>> > ->  Number of entries in CMS_CONTENTS table increases as expected
>> >
>> > 2) Touch the copied site (including rewrite content)
>> >
>> > ->   Number of entries in CMS_CONTENTS table increases as expected
>> >
>> > 3) Delete the copied site and publish it
>> >
>> > ->   Number of entries in CMS_CONTENTS table increases, this seems
>> > strange and I would not have expected this
>> >
>> > 4) Cleanup History tables, keep one version, delete al deleted
>> >
>> > ->  Number of entries in CMS_CONTENTS stays the same as in 3), this
>> seems
>> > to be not correct.
>> >
>> > So steps 3 and 4 bring up results that must be investigated.
>> >
>> > We will take a look at this for the OpenCms 8 release, it would be good
>> > if you could add a enty in bugzilla.opencms.org.
>> >
>> > Kind Regards,
>> > Michael
>> >
>> >
>> >
>> >
>> > Am 10.02.2011 21:10, schrieb Ignacio Martelli:
>> >> Hi,
>> >>
>> >> I found something strange while trying to reduce the size of a big
>> >> (13GB+) OpenCMS 7.5.2 instance by deleting old content. I first tried
>> >> to delete the content in the server, but the DB did not decrease it's
>> >> size. In order to do the process correctly I copied the entire server
>> >> into a dev VM, and tried to delete ALL the content. Here is what I
>> >> did:
>> >>
>> >> - Delete all the contents of /sites/MySite
>> >> - In "Administration ->   File History ->   History Settings": change
>> >> settings to leave 1 stored version and not keep deleted resources.
>> >> - In "Administration ->   File History ->   Clear History": Cleared all
>> >> history including all versions of deleted files, left only 1 file
>> >> versions of normal content.
>> >> - In MySql: Optimized all tables to reclaim hard disk space.
>> >>
>> >> After doing all these steps, I checked the DB size, and found it still
>> >> weights at over 10GB! Looking at table sizes, the table CMS_CONTENTS
>> >> is taking 90% of that space.
>> >>
>> >> I checked the contents of that table and found content linked only to
>> >> CMS_HISTORY_RESOURCES and CMS_PUBLISH_HISTORY but not linked to
>> >> CMS_ONLINE_RESOURCES, CMS_HISTORY_RESOURCES, CMS_ONLINE_STRUCTURE or
>> >> CMS_HISTORY_STRUCTURE.
>> >>
>> >> Checking the CMS_PUBLISH_HISTORY table I found that the path of said
>> >> content was in a subfolder of /sites/MySite. I see no way to access
>> >> that path from the workplace.
>> >>
>> >>
>> >> If I understand correctly I have content that I cannot access from the
>> >> workplace (because it has no resources or structure associated with
>> >> it). Shouldn't that content have been deleted?????? Is this a bug, or
>> >> is the content necessary?
>> >>
>> >>
>> >> Regards,
>> >> IM
>> >>
>> >> _______________________________________________
>> >> This mail is sent to you from the opencms-dev mailing list
>> >> To change your list options, or to unsubscribe from the list, please
>> visit
>> >> http://lists.opencms.org/mailman/listinfo/opencms-dev
>> >
>>
>>
>> --
>> -------------------
>> Mario Jäger
>>
>> Visit OpenCms Days 2011 Conference and Expo
>> May 9 to May 10 2011 in Cologne, Germany
>> http://www.opencms-days.org
>>
>> Alkacon Software GmbH  - The OpenCms Experts
>> http://www.alkacon.com - http://www.opencms.org
>>
>> _______________________________________________
>> This mail is sent to you from the opencms-dev mailing list
>> To change your list options, or to unsubscribe from the list, please visit
>> http://lists.opencms.org/mailman/listinfo/opencms-dev
>>
>
>
>
> --
> Best regards,
> Gleb Makarov
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>



-- 
*
www.solutioncms.com
The Brazilian
Official Provider OpenCms
*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20110728/e5fda73d/attachment.htm>