<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
if using MySQL with MyISAM it is normally that the size of the
database file on the harddisk (that doesn't mean the number of
database records !!!) is not decrease instantly until the database
table was optimized by an db-admin or an cron-job.<br>
<br>
Regards<br>
<br>
Am 28.07.2011 15:15, schrieb gleb makarov:
<blockquote
id="mid_CABiGHAFSez4c56uHuwM6iVFadA24Xg-JG0e6oO7qpMz1aY3B9Q_mail_gmail_com"
cite="mid:CABiGHAFSez4c56uHuwM6iVFadA24Xg-JG0e6oO7qpMz1aY3B9Q@mail.gmail.com"
type="cite">Hi Deiverson,<br>
<br>
Thanks for your reply. <br>
<br>
I know that this issue was announced as fixed, but as I wrote we
still have it. So I`d like to understand whether it is our local
problem, or not. <br>
<br>
<div class="gmail_quote">
2011/7/28 Deiverson Silveira <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:deiverson@solutioncms.com">deiverson@solutioncms.com</a>></span><br>
<blockquote id="StationeryCiteGenerated_1" class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt
0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,
<div><br>
</div>
<div>In version 7.5.4, is fixed this problem:</div>
<div>* Fixed issue #1949: Database size does not decrease
after (completely) deleting resources </div>
<div><br>
</div>
<div>Regards,</div>
<div><br>
</div>
<div>
Deiverson Silveira
<div>
<div class="h5"><br>
<br>
<div class="gmail_quote">2011/7/28 gleb makarov <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:gleb.a.makarov@gmail.com"
target="_blank">gleb.a.makarov@gmail.com</a>></span><br>
<blockquote id="StationeryCiteGenerated_2"
class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex;
padding-left: 1ex;">
Hello everyone,<br>
<br>
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.<br>
<br>
Does someone still has the same problem on 7.5.4? <br>
<br>
<div class="gmail_quote">2011/3/11 Mario Jäger <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:m.jaeger@alkacon.com"
target="_blank">m.jaeger@alkacon.com</a>></span><br>
<blockquote id="StationeryCiteGenerated_3"
class="gmail_quote" style="border-left: 1px
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt
0.8ex; padding-left: 1ex;">
Hello,<br>
<br>
FYI: This issue is fixed in the CVS Head now:<br>
<a moz-do-not-send="true"
href="http://bugzilla.opencms.org/show_bug.cgi?id=1949"
target="_blank">http://bugzilla.opencms.org/show_bug.cgi?id=1949</a><br>
<br>
Kind Regards,<br>
Mario.<br>
<br>
Am 11.02.2011 11:11, schrieb Michael Emmerich:<br>
<div>
<div>> Hello Ignacio,<br>
><br>
> I made a little test here to try to
reproduce this (on OpenCms 7.5.3)<br>
><br>
> 1) Copy a complete site and publish it<br>
><br>
> -> Number of entries in
CMS_CONTENTS table increases as expected<br>
><br>
> 2) Touch the copied site (including
rewrite content)<br>
><br>
> -> Number of entries in
CMS_CONTENTS table increases as expected<br>
><br>
> 3) Delete the copied site and publish
it<br>
><br>
> -> Number of entries in
CMS_CONTENTS table increases, this seems<br>
> strange and I would not have expected
this<br>
><br>
> 4) Cleanup History tables, keep one
version, delete al deleted<br>
><br>
> -> Number of entries in
CMS_CONTENTS stays the same as in 3), this
seems<br>
> to be not correct.<br>
><br>
> So steps 3 and 4 bring up results that
must be investigated.<br>
><br>
> We will take a look at this for the
OpenCms 8 release, it would be good<br>
> if you could add a enty in <a
moz-do-not-send="true"
href="http://bugzilla.opencms.org"
target="_blank">bugzilla.opencms.org</a>.<br>
><br>
> Kind Regards,<br>
> Michael<br>
><br>
><br>
><br>
><br>
> Am 10.02.2011 21:10, schrieb Ignacio
Martelli:<br>
>> Hi,<br>
>><br>
>> I found something strange while
trying to reduce the size of a big<br>
>> (13GB+) OpenCMS 7.5.2 instance by
deleting old content. I first tried<br>
>> to delete the content in the
server, but the DB did not decrease it's<br>
>> size. In order to do the process
correctly I copied the entire server<br>
>> into a dev VM, and tried to delete
ALL the content. Here is what I<br>
>> did:<br>
>><br>
>> - Delete all the contents of
/sites/MySite<br>
>> - In "Administration -> File
History -> History Settings": change<br>
>> settings to leave 1 stored version
and not keep deleted resources.<br>
>> - In "Administration -> File
History -> Clear History": Cleared all<br>
>> history including all versions of
deleted files, left only 1 file<br>
>> versions of normal content.<br>
>> - In MySql: Optimized all tables to
reclaim hard disk space.<br>
>><br>
>> After doing all these steps, I
checked the DB size, and found it still<br>
>> weights at over 10GB! Looking at
table sizes, the table CMS_CONTENTS<br>
>> is taking 90% of that space.<br>
>><br>
>> I checked the contents of that
table and found content linked only to<br>
>> CMS_HISTORY_RESOURCES and
CMS_PUBLISH_HISTORY but not linked to<br>
>> CMS_ONLINE_RESOURCES,
CMS_HISTORY_RESOURCES, CMS_ONLINE_STRUCTURE
or<br>
>> CMS_HISTORY_STRUCTURE.<br>
>><br>
>> Checking the CMS_PUBLISH_HISTORY
table I found that the path of said<br>
>> content was in a subfolder of
/sites/MySite. I see no way to access<br>
>> that path from the workplace.<br>
>><br>
>><br>
>> If I understand correctly I have
content that I cannot access from the<br>
>> workplace (because it has no
resources or structure associated with<br>
>> it). Shouldn't that content have
been deleted?????? Is this a bug, or<br>
>> is the content necessary?<br>
>><br>
>><br>
>> Regards,<br>
>> IM<br>
>><br>
>>
_______________________________________________<br>
>> This mail is sent to you from the
opencms-dev mailing list<br>
>> To change your list options, or to
unsubscribe from the list, please visit<br>
>> <a moz-do-not-send="true"
href="http://lists.opencms.org/mailman/listinfo/opencms-dev"
target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br>
><br>
<br>
<br>
--<br>
</div>
</div>
-------------------<br>
<font color="#888888">Mario Jäger<br>
</font>
<div>
<div><br>
Visit OpenCms Days 2011 Conference and Expo<br>
May 9 to May 10 2011 in Cologne, Germany<br>
<a moz-do-not-send="true"
href="http://www.opencms-days.org"
target="_blank">http://www.opencms-days.org</a><br>
<br>
Alkacon Software GmbH - The OpenCms Experts<br>
<a moz-do-not-send="true"
href="http://www.alkacon.com"
target="_blank">http://www.alkacon.com</a>
- <a moz-do-not-send="true"
href="http://www.opencms.org"
target="_blank">http://www.opencms.org</a><br>
<br>
_______________________________________________<br>
This mail is sent to you from the
opencms-dev mailing list<br>
To change your list options, or to
unsubscribe from the list, please visit<br>
<a moz-do-not-send="true"
href="http://lists.opencms.org/mailman/listinfo/opencms-dev"
target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
Best regards,<br>
<font color="#888888">Gleb Makarov<br>
</font><br>
<br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev
mailing list<br>
To change your list options, or to unsubscribe from
the list, please visit<br>
<a moz-do-not-send="true"
href="http://lists.opencms.org/mailman/listinfo/opencms-dev"
target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
</div>
</div>
<i>
<div><span style="font-style: normal;"><i>
<div>
<span style="font-style: normal;"><i>
<div style="display: inline ! important;"><span
style="font-style: normal;"><i><a
moz-do-not-send="true"
href="http://www.solutioncms.com"
target="_blank">www.solutioncms.com</a></i></span></div>
</i></span></div>
<div>
<span style="font-style: normal;"><i><span
style="font-style: normal;"><i>
<div><span style="font-style: normal;"><i>
<div style="display: inline !
important;"><span
style="font-style: normal;"><i><span
style="font-style: normal;"><i>
<div style="display:
inline ! important;">
<i>The Brazilian </i><span
style="font-style:
normal;"><i>
<div style="display:
inline !
important;"><span
style="font-style:
normal;"><i><span
style="font-style:
normal;"><i>
<div
style="display:
inline !
important;"><i>Official
Provider
OpenCms</i></div>
</i></span></i></span></div>
</i></span></div>
</i></span></i></span></div>
</i></span></div>
</i></span></i></span></div>
</i></span></div>
</i><br>
</div>
<br>
<br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list,
please visit<br>
<a moz-do-not-send="true"
href="http://lists.opencms.org/mailman/listinfo/opencms-dev"
target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
Best regards,<br>
Gleb Makarov<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
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
<a class="moz-txt-link-freetext" href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</a></pre>
</blockquote>
<br>
</body>
</html>