<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"HelveticaNeueLT Pro 55 Roman";
panose-1:2 11 6 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.E-MailFormatvorlage19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.CodeFett
{mso-style-name:"Code + Fett";
font-family:Consolas;
border:none windowtext 1.0pt;
padding:0cm;
background:#E7E6E6;
font-weight:bold;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hi Franck,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">I had to do some statistics when migrating from version 6.2 to 9.5. Maybe it is interesting for you. With that figures, we had no problem at all. Of course some things take longer, when having a
large amount of data. E.g publishing of about 80000 resources took about 3 hours.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Here are the figures:<o:p></o:p></span></p>
<p class="MsoNormal">OpenCms 6.2:<o:p></o:p></p>
<p class="MsoNormal">Size of database dump: <span class="CodeFett"><span style="font-size:10.0pt">53 GB</span></span><span style="font-family:"HelveticaNeueLT Pro 55 Roman",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal">Size of OpenCms DB export: <span class="CodeFett"><span style="font-size:10.0pt">6 GB</span></span><o:p></o:p></p>
<p class="MsoNormal">Amount of resources (files and folders) of OpenCms DB import:
<span class="CodeFett"><span style="font-size:10.0pt">103842</span></span><o:p></o:p></p>
<p class="MsoNormal">Amount of resources (files and folders) of OpenCms static export:
<span class="CodeFett"><span style="font-size:10.0pt">9807</span></span><o:p></o:p></p>
<p class="MsoNormal">Size of export folder (<span class="CodeFett"><span style="font-size:10.0pt">[TOMCAT_HOME/webapps/opencms/export/</span></span>):
<span class="CodeFett"><span style="font-size:10.0pt">885 MB</span></span><o:p></o:p></p>
<p class="MsoNormal">OpenCms 9.5:<o:p></o:p></p>
<p class="MsoNormal">Initial size of OpenCms database after OpenCms DB import (<span class="CodeFett"><span style="font-size:10.0pt">Workplace Server</span></span>): about
<span class="CodeFett"><span style="font-size:10.0pt">14,9 GB</span></span><o:p></o:p></p>
<p class="MsoNormal">Initial size of OpenCms database after OpenCms DB (<span class="CodeFett"><span style="font-size:10.0pt">Frontend Server</span></span>): about
<span class="CodeFett"><span style="font-size:10.0pt">7,2 GB </span></span>(about half the size, because there is no Offline project)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hope this helps you and maybe others as well.<o:p></o:p></p>
<p class="MsoNormal">Best regards<o:p></o:p></p>
<p class="MsoNormal">Kai <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Von:</b> opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org]
<b>Im Auftrag von </b>Lorenz Lammersdorf<br>
<b>Gesendet:</b> Mittwoch, 16. August 2017 16:53<br>
<b>An:</b> The OpenCms mailing list <opencms-dev@opencms.org><br>
<b>Betreff:</b> Re: [opencms-dev] Question : maximum database size ?<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">ours was about 150 GB without any problems. static export may become a problem.
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">lorenz<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Am 16.08.2017 16:38 schrieb <a href="mailto:vswm@free.fr">vswm@free.fr</a>:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt">Hello List,<br>
<br>
We are using opencms 7.5.4 (without OCEE) with mysql 5.5.8.<br>
We have now 15 sites, and we plan to add more and more !<br>
Our database's size have reached 64 GB.<br>
<br>
We are wondering if there is a limit in the size of the database ( other than mysql / OS restrictions ) : in other word, which size have reached your database without any dysfonctionnement (bad response time, ... ) of openCMS ?<br>
<br>
Regards,<br>
Franck<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 href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a><br>
<br>
<br>
<o:p></o:p></span></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Lorenz Lammersdorf<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial",sans-serif">Web Developer<br>
+41 58 255 13 06<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial",sans-serif">Kernbrand AG<br>
Teufener Strasse 11<br>
9000 St. Gallen<br>
<a href="https://kernbrand.ch">www.kernbrand.ch</a> <o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial",sans-serif">Unser neustes Werk: Redesign der Website
<a href="http://eishockeylager.ch/" target="_blank">C.A.M.P.S.</a> <br>
<br>
Folgen Sie uns: <a href="https://www.facebook.com/kernbrandag/">Facebook</a> | <a href="https://www.instagram.com/kernbrand/%22">Instagram</a> | <a href="https://www.linkedin.com/company/kernbrand">LinkedIn</a> | <a href="https://twitter.com/kernbrand1">Twitter</a> | <a href="https://www.youtube.com/channel/UCNPqHyrqpCmfmFAZGVtp_uw">Youtube</a>
<o:p></o:p></span></p>
</div>
</div>
</body>
</html>