On 10/07/2010 11:03 PM, Mingus Dew wrote:
> All,
> I am running Bacula 5.0.1 on Solaris 10 x86. I'm currently running
> MySQL 4.1.22 for the database server. I do plan on upgrading to a compatible
> version of MySQL 5, but migrating to PostgreSQL isn't an option at this
> time.
>
> I am trying to backup to tape a very large number of files for a
> client. While the data size is manageable at around 2TB, the number of files
> is incredibly large.
> The first of the jobs had 27 million files and initially failed because the
> batch table became "Full". I changed the myisam_data_pointer size to a value
> of 6 in the config.
> This job was then able to run successfully and did not take too long.
>
> I have another job which has 42 million files. I'm not sure what that
> equates to in rows that need to be inserted, but I can say that I've not
> been
> able to successfully run the job, as it seems to hang for over 30 hours in a
> "Dir inserting attributes" status. This causes other jobs to backup in the
> queue and
> once canceled I have to restart Bacula.
>
> I'm looking for way to boost performance of MySQL or Bacula (or both) to
> get this job completed.
>
> Thanks,
> Shon
>
Rude answer :
If you really want to use Mysql drop the myisam to innodb.
But you don't want to use mysql for that job, just use Postgresql fine tuned
with batch insert enabled.
:-)
--
Bruno Friedmann (irc:tigerfoot)
Ioda-Net Sàrl www.ioda-net.ch
openSUSE Member
User www.ioda.net/r/osu
Blog www.ioda.net/r/blog
fsfe fellowship www.fsfe.org
GPG KEY : D5C9B751C4653227
vcard : http://it.ioda-net.ch/ioda-net.vcf
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
