[opencms-dev] Question : maximum database size ?

[Schliemann, Kai]

Hi Franck,
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.
Here are the figures:
OpenCms 6.2:
Size of database dump: 53 GB
Size of OpenCms DB export: 6 GB
Amount of resources (files and folders) of OpenCms DB import: 103842
Amount of resources (files and folders) of OpenCms static export: 9807
Size of export folder ([TOMCAT_HOME/webapps/opencms/export/): 885 MB
OpenCms 9.5:
Initial size of OpenCms database after OpenCms DB import (Workplace Server): about 14,9 GB
Initial size of OpenCms database after OpenCms DB (Frontend Server): about 7,2 GB (about half the size, because there is no Offline project)

Hope this helps you and maybe others as well.
Best regards
Kai



Von: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] Im Auftrag von Lorenz Lammersdorf
Gesendet: Mittwoch, 16. August 2017 16:53
An: The OpenCms mailing list <opencms-dev at opencms.org>
Betreff: Re: [opencms-dev] Question : maximum database size ?

ours was about 150 GB without any problems. static export may become a problem.

lorenz

Am 16.08.2017 16:38 schrieb vswm at free.fr<mailto:vswm at free.fr>:
Hello List,

We are using opencms 7.5.4 (without OCEE) with mysql 5.5.8.
We have now 15 sites, and we plan to add more and more !
Our database's size have reached 64 GB.

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 ?

Regards,
Franck

_______________________________________________
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/cgi-bin/mailman/listinfo/opencms-dev




Lorenz Lammersdorf
Web Developer
+41 58 255 13 06

Kernbrand AG
Teufener Strasse 11
9000 St. Gallen
www.kernbrand.ch<https://kernbrand.ch>

Unser neustes Werk: Redesign der Website C.A.M.P.S.<http://eishockeylager.ch/>

Folgen Sie uns: Facebook<https://www.facebook.com/kernbrandag/> | Instagram<https://www.instagram.com/kernbrand/%22> | LinkedIn<https://www.linkedin.com/company/kernbrand> | Twitter<https://twitter.com/kernbrand1> | Youtube<https://www.youtube.com/channel/UCNPqHyrqpCmfmFAZGVtp_uw>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20170816/86c29fb6/attachment.htm>