> -----Original Message----- > From: Alan Brown [mailto:a...@mssl.ucl.ac.uk] > Sent: Tuesday, December 15, 2015 8:08 AM > To: Lewis, Dave; bacula-users@lists.sourceforge.net > Subject: Re: [Bacula-users] Bacula backup speed ... > What size is your database? ("select count(*) from File;") What write > speeds are you actually achieving to the database drive? > (MB/s and iops - "iostat -kxt 2" will tell you this)
Enter SQL query: SELECT COUNT(*) FROM File; +----------+ | COUNT(*) | +----------+ | 659,172 | +----------+ I'll run iostat next time I test Bacula. (It's not installed on this server -- thanks for the suggestion and the command.) > How much ram does the server have? > How much swap? > how much Swap activity is there? > How much swap is in use? It's got 16 GB RAM and 16 GB swap space. I didn't check if it was using a lot of swap space during the test backup. However the database size is around 200 MB, so I wouldn't think that swapping would be a problem. I'll check next time I test Bacula to be sure I'm not missing something. > Have you tuned your MySQL? > is MySQL writing lots of temp files? > Are you using MyISAM or InnoDB? We're using InnoDB. I haven't tuned MySQL. I don't know how to check if MySQL is writing lots of temp files. > If the MySQL is larger than 8-10 million entries, why aren't you using > Postgresql? > > What is the network environment? (speeds? switches? hubs? subnets? > Routers?) > > 700kB/sec is an abysmal rate for backup to disk unless you're running > on 10Mb/s thinnet. > Why is it so awful? > > Solve that first, THEN look at the attribute despooling issue. I'm currently testing just local backups to disk, in order to eliminate issues of the network and the tape drive. The Bacula / MySQL server has gigabit Ethernet and is connected to a 10 Gbps switch, as are most of the other servers that we will be backing up. Thanks, Dave IMPORTANT NOTICE: This e-mail is meant only for the use of the intended recipient. It may contain confidential information which is legally privileged or otherwise protected by law. If you received this e-mail in error or from someone who is not authorized to send it to you, you are strictly prohibited from reviewing, using, disseminating, distributing or copying the e-mail. PLEASE NOTIFY US IMMEDIATELY OF THE ERROR BY RETURN E-MAIL AND DELETE THIS MESSAGE FROM YOUR SYSTEM. Thank you for your cooperation. ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
