Hello,
Sorry to jump into this so late, but if you are really looking for
DB speed, XFS is also a very good filesystem, quite possibly better
that ext3 or ext4 for databases like Postgres or MySQL.
Best regards,
Kern
On 12/02/2013 07:41 PM, Charles Douglass wrote:
> I was having an issue with the "spooling attrs to director":
>
> 18-Nov 12:45 maple-sd JobId 46: Sending spooled attrs to the Director.
> Despooling 153,470,245 bytes ...
> 18-Nov 21:41 maple-dir JobId 46: Bacula maple-dir 5.2.6 (21Feb12): Build
> OS: x86_64-pc-linux-gnu ubuntu 13.04
>
> So spooling/despooling took just about 9 hours.
>
> Even for MySQL on a not too fast machine this is ridiculus slow. We
> despool around 1.2GB attributes within around 2 minutes to our
> Postgres server. Something is still wrong with your setup. Have you
> checked with tools like iotop,top,vmstat what the server is actually
> doing during the 9 hours.
>
> Regards
>
> Andreas
>
> iostat during the attrs despooling shows:
>
> 334 be/3 root 0.00 B/s 0.00 B/s 0.00 % 99.99 % [jbd2/sda1-8]
> 24997 be/4 mysql 0.00 B/s 64.98 K/s 0.00 % 0.12 % mysqld
>
> Doing some research this appears to be a problem between MySQL and ext4
> with file system journaling (jbd2/sda1-8).
>
> Thanks, everyone, for helping me get this far.
>
> My next step will be to create an ext3 partition and move all my MySQL
> Dbs there.
>
>
> Sorry for the delay in presenting results, but when I first tried to create
> an EXT3 partition I discovered I was also having a huge number of read
> retries on that particular hard drive. To rule out the possibility that this
> was the problem I first replaced the hard drive and re-ran a backup with the
> MySQL database on an EXT4 partition on the new hard drive. I had the same
> issue.
>
> I then created an EXT3 partition and moved my MySQL database there. The new
> results are:
>
> 02-Dec 02:46 maple-sd JobId 107: Sending spooled attrs to the Director.
> Despooling 153,749,840 bytes ...
> 02-Dec 03:52 maple-dir JobId 107: Bacula maple-dir 5.2.6 (21Feb12):
>
> So switching from EXT4 to EXT3 cut the time from 9 hours to a bit over
> 1 hour. This still seems high, but is acceptable.
>
> Thanks to everyone who provided suggestions on how to debug this issue.
>
> Chas Douglass
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
