On 25/03/2010 11:36 a.m., James Harper wrote:
>>
>> We've used Legato networker before (we still do, as we're not yet
>> successfully completed the migration; and it's looking more and more
>> grim prospect by the day), and on approximately the same dataset (of
>> about 500 million records spread o
>
> We've used Legato networker before (we still do, as we're not yet
> successfully completed the migration; and it's looking more and more
> grim prospect by the day), and on approximately the same dataset (of
> about 500 million records spread over 100 servers) and somewhat
> weaker hardware, i
> You desperately need more ram. I have 4GB ram on my 64 bit bacula
> servers I built in 2004 and I probably have 1/2 that many files. And I
> said servers. My database is not on the same machine as the director.
It's already on order from Crucial!
-
> On a modest Dell rackount with an E4500 2.2GHz CPU, 1GB of RAM & 2
> raid1 SAS disks, retention 5 weeks, about 20 clients and about 100mil
> rows in File, the restore query for 'building directory tree' would
> still not be done after 24 hours with 5.0.x, whereas for 3.x.x the
> time to do this w
On Wed, Mar 24, 2010 at 8:32 AM, Matija Nalis wrote:
>>> It is probably not hung, but just very, very slow.
>>
>> Yes. You probably need a LOT more ram and to tune mysql's parameters.
It appears so! I've spent a large amount of time tweaking MySQL
actually, it must be RAM.
> (Before you ask, we'
On Tue, Mar 23, 2010 at 04:07:17PM +, Alan Brown wrote:
> Matija Nalis wrote:
>> It is probably not hung, but just very, very slow.
>
> Yes. You probably need a LOT more ram and to tune mysql's parameters.
Or maybe someone should tune the SQL queries (no, I'm not
volunteering, it's not my fort
Matija Nalis wrote:
> It is probably not hung, but just very, very slow.
Yes. You probably need a LOT more ram and to tune mysql's parameters.
> We've had a same
> issue, with about 500 million records in File (and about 120GB on
> disk for File.ibd) on (mostly dedicated to mysql) machine (8gig
On Mon, Mar 22, 2010 at 01:25:38PM -0500, Jonathan R. Dundas wrote:
> I have a RHEL 5 x86_64 patched-current install with bacula RPM's built
> from the sourceforge src RPMs. I'm running MySQL community edition
> 5.1.43-1 mysql.com RPMs. I have updated bacula and tried this same
> operation with b
I have a RHEL 5 x86_64 patched-current install with bacula RPM's built
from the sourceforge src RPMs. I'm running MySQL community edition
5.1.43-1 mysql.com RPMs. I have updated bacula and tried this same
operation with bacula 5.0.0, 5.0.1 and 5.0.2. When I try to restore a
backup, bconsole appe
