Re: [Bacula-users] MySQLdump import seems very slow for Filename and Path tables
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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Send mail only to one address for one job.
Hi! I would like to know if there is any possibility to send a mail about the status of two jobs to a mail address different of the system mail (please, excuse me my bad english :-/). Thank you very much. Manu -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] what would cause a server to not auto-label a new file?
This problem continues. I have 1 bacula server that pauses during full backup jobs: Running Jobs: Console connected at 19-Mar-13 07:47 JobId Level Name Status == 1567 Fullrnd1.2013-03-17_22.00.01_29 is running 1568 Fullrnd2.2013-03-17_22.00.01_30 is waiting for an appendable Volume 1569 Fullrnd4.2013-03-17_22.00.01_31 is running 1570 Fullrnd5.2013-03-17_22.00.01_32 is running 1571 Fullrnd6.2013-03-17_22.00.01_33 is waiting on max Storage jobs 1572 Fullrnd7.2013-03-17_22.00.01_34 is waiting on max Storage jobs 1573 Fulld045.2013-03-17_22.00.01_35 is waiting on max Storage jobs 1574 Fulld046.2013-03-17_22.00.01_36 is waiting on max Storage jobs Historically it has already created a new volume when one is not appendable, but this server has recently started just hanging up and waiting on user intervention. What would cause this to change, and how can I get this server back on track with auto-creation as needed? Any ideas? Thanks, jonathan From: Jonathan Horne [mailto:jho...@skopos.us] Sent: Wednesday, February 27, 2013 8:07 AM To: bacula-users@lists.sourceforge.net Subject: [Bacula-users] what would cause a server to not auto-label a new file? I have 2 bacula servers, both 5.0.0.x from centos repo. One server, has never one time failed to label/create a new file to continue backing up. This other server, a couple days ago on a full backup, labeled a few files, then stopped. And now it wont label them unless I give the commands by hand to create a new file. Is there some scenario that causes this behavior? Thanks, jonathan This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind SKOPOS to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind SKOPOS to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] MySQLdump import seems very slow for Filename and Path tables
You may also want to try Xtrabackup from Percona. -Melvin On Tue, Mar 19, 2013 at 4:24 AM, Uwe Schuerkamp uwe.schuerk...@nionex.netwrote: 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
