jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeroen Reijn <j.re...@onehippo.com>
Subject Re: JCR/MySQL backup performance
Date Thu, 22 Aug 2013 13:36:11 GMT
Hi,

I do not have a lot of experience with backup performance, but have you
looked into what the different table sizes are? It might point you into a
direction. I know that the journal table can grow quite fast and you can
clean up old entries if necessary.

Jeroen



On Tue, Aug 20, 2013 at 6:22 AM, Vikram Vaswani <
vikram.vaswani@loudcloudsystems.com> wrote:

> Hi all
>
> We are using Jackrabbit + MySQL as the data store. The current size of the
> JCR database is ~25 GB and we've seen that our application adds ~1GB of new
> data daily. We're using InnoDB as the table storage engine.
>
> We have a daily backup process for the database. We've seen that this
> daily backup takes ~5 hrs to complete. We've been unable to identify why it
> takes so long and are concerned that backup time will continue to increase
> as the size of the database grows.
>
> Would others on this list be able to help diagnose this issue or suggest
> how we could improve the backup performance?
>
> TIA,
>
> Vikram
>
> ________________________________
> This email may contain proprietary, privileged and confidential
> information and is sent for the intended recipient(s) only. If, by an
> addressing or transmission error, this mail has been misdirected to you,
> you are requested to notify us immediately by return email message and
> delete this email and its attachments. You are also hereby notified that
> any use, any form of reproduction, dissemination, copying, disclosure,
> modification, distribution and/or publication of this email message,
> contents or its attachment(s) other than by its intended recipient(s) is
> strictly prohibited. Any opinions expressed in this email are those of the
> individual and may not necessarily represent those of LoudCloud Systems.
> Before opening attachment(s), please scan for viruses. It is further
> notified that email transmission cannot be guaranteed to be secure or
> error-free as information could be intercepted, corrupted, lost, destroyed,
> arrive late or incomplete, or may contain viruses. The sender therefore
> does not accept liability for any error or omission in the contents of this
> message, which arise as a result of email transmission. LoudCloud Systems
> Inc. and its subsidiaries do not accept liability for damage caused by this
> email or any attachments and may monitor email traffic.
> ________________________________
>



-- 
Jeroen Reijn
Solution Architect
Hippo

Amsterdam - Oosteinde 11, 1017 WT Amsterdam
Boston - 101 Main Street, Cambridge, MA 02142

US +1 877 414 4776 (toll free)
Europe +31(0)20 522 4466
www.onehippo.com

http://about.me/jeroenreijn

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message