[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bacula-users
Subject:    Re: [Bacula-users] Despooling attributes very slow
From:       Dan Langille <dan () langille ! org>
Date:       2014-11-20 17:01:32
Message-ID: E1B69076-4716-479A-8910-D31B9625F749 () langille ! org
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


On Nov 15, 2014, at 4:16 PM, Will Twomey <termina@gmail.com> wrote:
> 
> Hey John,
> 
> Thanks for the response.
> 
> That hdparm was run during the despooling process which is likely impacting those \
> numbers.  (Although I would argue that 125MB/sec should be more than enough to \
> despool a 45MB file! :)) 
> This does seem to be a mysql issue, as switching to postgres has resolved this. \
> Oddly enough, running myqltuner.pl <http://myqltuner.pl/> didn't show any cause for \
> concern. 
> Thanks again for the prompt response

I think you'll be much happier with PostgreSQL in the long term.

One of my tuning expeditions, for future reference: \
https://plus.google.com/106386350930626759085/posts/hhKemT3UQE7 \
<https://plus.google.com/106386350930626759085/posts/hhKemT3UQE7>

disclosure: I wrote the PostgreSQL backend for Bacula.

— 
Dan Langille
http://langille <http://langille/>.org/


[Attachment #5 (unknown)]

<html><head><meta http-equiv="Content-Type" content="text/html \
charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; \
-webkit-line-break: after-white-space;" class="">On Nov 15, 2014, at 4:16 PM, Will \
Twomey &lt;<a href="mailto:termina@gmail.com" class="">termina@gmail.com</a>&gt; \
wrote:<br class=""><div><blockquote type="cite" class=""><br \
class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div \
class=""><div class=""><div class=""><div class="">Hey John,<br class=""><br \
class="">Thanks for the response.<br class=""><br class=""></div>That hdparm was run \
during the despooling process which is likely impacting those numbers.&nbsp; \
(Although I would argue that 125MB/sec should be more than enough to despool a 45MB \
file! :))<br class=""><br class=""></div>This does seem to be a mysql issue, as \
switching to postgres has resolved this. Oddly enough, running <a \
href="http://myqltuner.pl/" class="">myqltuner.pl</a> didn't show any cause for \
concern.<br class=""><br class=""></div>Thanks again for the prompt response<br \
class=""></div></div></div></blockquote><br class=""></div><div>I think you'll be \
much happier with PostgreSQL in the long term.</div><div><br class=""></div><div>One \
of my tuning expeditions, for future reference:&nbsp;<a \
href="https://plus.google.com/106386350930626759085/posts/hhKemT3UQE7" \
class="">https://plus.google.com/106386350930626759085/posts/hhKemT3UQE7</a></div><div><br \
class=""></div><div>disclosure: I wrote the PostgreSQL backend for \
Bacula.</div><div><br class=""></div><div>—&nbsp;</div><div \
apple-content-edited="true" class=""> <div style="color: rgb(0, 0, 0); \
letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; \
text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; \
-webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; \
-webkit-line-break: after-white-space;" class=""><div class="">Dan Langille</div><div \
class=""><a href="http://langille" class="">http://langille</a>.org/</div><div \
class=""><br class=""></div></div></div></body></html>



------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk

_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic