[opencms-dev] Deleting resources and database size

Tue May 26 16:14:55 CEST 2009

If you want the actual disk usage to go down, you should:

1. Delete the resources in OpenCMS
2. Purge the history in OpenCMS
3. Repair/Optimize the tables in MySQL.

The reasoning is that when MySQL deletes a row, it doesn't neccessarily remove the data there.  It dereferences it and reserves it for the next insert.  This is for performance purposes much the same way Windows manages an NTFS partition.  With a database of 10G, I'd suggest scheduling a job to optimize tables once a week or maybe every 2 weeks depending on the activity in your installation.

http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html

Tables can also be optimized from MySQL Administrator
http://dev.mysql.com/downloads/gui-tools/5.0.html

-----Original Message-----
From: opencms-dev-bounces at opencms.org on behalf of Christian Steinert
Sent: Tue 5/26/2009 6:34 AM
To: The OpenCms mailing list
Subject: Re: [opencms-dev] Deleting resources and database size

Since the version history was mentioned: OpenCms will keep old content 
around in its version history. The default is either 10 or even 20 old 
copies, I am not sure right now, which of the two it was.
You can set the amount of historic copies lower, although as far as I 
know, this can only be done globally, not per file type. The setting 
should be in opencms-vfs.xml. So, it's not necessary to export and 
re-import content, just to get rid of the version history.

Best Regards
Christian
> Hi
>
> I found this problem myself - mysteriously the DB size does not shrink on
> deletion even when the history settings are set to not keep deleted objects.
> Perhaps the developers can comment?
>
> One work around is to export all the content and modules into a new 'empty'
> opencms installation. You'll lose all the version history but the size will
> shrink. You could use the opportunity to upgrade to the latest version of
> opencms at the same time.
>
> If you have particularly large content items such as video, you could keep
> this outside of opencms to reduce the db size (of course you'll lose the
> content management for these items!). This is the downside of keeping all
> content in the database.
>
> Steve
>
> -----Original Message-----
> Message: 2
> Date: Fri, 22 May 2009 17:23:10 +0300
> From: Chuck Mysak <chuck.mysak at gmail.com>
> Subject: [opencms-dev] Deleting resources and database size
> To: The OpenCms mailing list <opencms-dev at opencms.org>
> Message-ID:
> 	<439e528c0905220723w5fbbb8fft6135cb97f55c7292 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello all,
>
> I'm maintaining quite a big content rich website using OpenCms 7, and the
> mysql database is gone way over 10GB. I deleted about 1.3 GB of content from
> the VFS by creating a module, exporting it and the deleting it.
>
> After that, the database size actually grew with about 1 GB. I deleted the
> history for the deleted files from the administration view and still, the
> database isn't getting any smaller.
>
> Have you ever encountered such a situation? There has to be a solution,
> otherwhise, the database will never get smaller as the content is dropped
> from the website.
>
> Thank you,
>
> Chuck
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.opencms.org/pipermail/opencms-dev/attachments/20090522/0c85b2f8
> /attachment.html 
>
> ------------------------------
>
> Message: 3
> Date: Fri, 22 May 2009 16:23:34 +0200
> From: Jordi Mart? <jmarti at theinit.com>
> Subject: [opencms-dev] scheduled publishing
> To: "'The OpenCms mailing list'" <opencms-dev at opencms.org>
> Message-ID:
> 	<200905221423.n4MENVNE027106 at omr8.networksolutionsemail.com>
> Content-Type: text/plain;	charset="iso-8859-1"
>
> Hi,
>
> Is there any module (or bult-in functionality) for scheduled publishing in
> opencms 7 (I know there was not in 6), or if my customer wants it, should I
> have to develop it myself?
>
> When is opencms 7.5 beta launch scheduled? What will be its primary new
> funcionalities? 
>
> Why a 7.0 - 7.5 sudden jump?
>
> Thanks!!!...
>    
>  
> JORDI MART? 
> Email: jmarti _at_ theinit *com* 
>
> U like tv shows? I doo to! Check my itortv.com profile:
> http://itortv.com/user/jmarti/
>
>
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 22 May 2009 16:39:21 +0200
> From: Jordi Mart? <jmarti at theinit.com>
> Subject: Re: [opencms-dev] scheduled publishing
> To: "'The OpenCms mailing list'" <opencms-dev at opencms.org>
> Message-ID:
> 	<200905221439.n4MEdJvl009077 at omr13.networksolutionsemail.com>
> Content-Type: text/plain;	charset="iso-8859-1"
>
>   
>> When is opencms 7.5 beta launch scheduled?
>>     
>
> Sorry, I meant:
>
>   
>> When is REAL opencms 7.5 (NO-beta) launch scheduled?
>>     
>
> ;-)))
>
> Thanks again
>
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 22 May 2009 14:38:55 -0700
> From: "Padilla, Patricia" <PPadilla at riversidecountyit.org>
> Subject: [opencms-dev] Confirmation page with correct values does not
> 	submit when using Alkacon OAMP Webuser Registration Module
> To: "'opencms-dev at opencms.org'" <opencms-dev at opencms.org>
> Message-ID:
> 	<16C04D94787E634D8AAAF619565FC3463B3CCC94D8 at excor02.cor.rivcnty.lcl>
> Content-Type: text/plain; charset="us-ascii"
>
> When I set up a confirmation page for the user registration page, if the
> button to go back and fix an entry, you are returned to the registration
> page to make the corrections (works as expected).  However, if the entries
> are correct and you hit the submit button, the submission fails.  I checked
> the logs and don't see any errors there.  It appears the form never submits.
>
> I set up the profile page and the confirmation page works correctly.  The
> confirmation email is generated as well. Has anyone experienced this
> behavior?
>
> I am using OpenCms 7.0.5
> Alkacon OAMP Webuser Registration Module: Module Version 0.9.0
> Alkacon OAMP Webform Module: Module Version 1.3
>
>
> Patricia  Padilla
> Applications Developer
> Riverside County Information Technology (RCIT)
>
>
>
>   ________________________________
> This email is confidential and intended solely for the use of the
> individual(s) to whom it is addressed. The information contained in this
> message may be privileged and confidential and protected from disclosure.
>
> If you are not the author's intended recipient, be advised that you have
> received this email in error and that any use, dissemination, forwarding,
> printing, or copying of this email is strictly prohibited. If you have
> received this email in error please delete all copies, both electronic and
> printed, and contact the author immediately.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.opencms.org/pipermail/opencms-dev/attachments/20090522/608e9647
> /attachment-0001.htm 
>
> ------------------------------
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
>
> End of opencms-dev Digest, Vol 241, Issue 6
> *******************************************
>
>
> _______________________________________________
> 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
>
>   

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 6435 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20090526/ad6fd029/attachment.bin>