Bacula-users

Re: [Bacula-users] MySQLdump import seems very slow for "Filename" and "Path" tables

2013-03-19 05:28:56
Subject: Re: [Bacula-users] MySQLdump import seems very slow for "Filename" and "Path" tables
From: Uwe Schuerkamp <uwe.schuerkamp AT nionex DOT net>
To: Phil Stracchino <alaric AT metrocast DOT net>
Date: Tue, 19 Mar 2013 10:24:55 +0100
On Sat, Mar 16, 2013 at 11:39:40AM -0400, Phil Stracchino wrote:
> On 03/16/13 05:54, Uwe Schuerkamp wrote:
> > Hi folks, 
> > 
> > I've been warned re-importing an innodb mysql database was slow, but I
> > hadn't expected it to be *this* slow. 
> 
> The basic problem here is that mysqldump has not aged or scaled well,
> and badly needs to be put out to pasture in favor of something better.
> I won't go into all of its failings here; suffice it to say that there
> are many of them.
> 

Thanks for all your suggestions, folks. I'll look into mydumper or
rather I've already looked into it and naturally fallen into the 

CMakeFiles/mydumper.dir/binlog.c.o: In function `get_binlog_file':
/server/tmp/mydumper-0.5.2/binlog.c:160: undefined reference to
`my_net_read'

trap that's also been reported on the net. I'll try to find a way of
fixing this and report back, hopefully being able to provide an up to
date working binary for centos 6 64 bit systems ;) 

All the best, Uwe 

-- 
NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA



------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users