Le 16/03/2013 10:54, Uwe Schuerkamp a écrit :
> My question: Is there some way to optimize the catalog dump to make
> the import faster, like maybe omitting indices and re-creating them
> manually once the import has completed? Seeing the Path table also has
> 19GB, its import probably won't have finished before our Sun goes
> Nova. ;)
>
Hello,

You have several ways to speed it up.
First:
  - use --disable-keys when dumping
  - use other tools to do the backup / restore : You can try:
     * mydumper : Each table will be a different dump. you will recreate 
the database using multiple threads in parallel.
     * mylvmbackup : you will restore a snapshot of the filesystem, the 
speed will be the highest you can have. (the size of the backup will be 
much bigger)

Do you clean regularly your catalog with dbcheck?

HTH.
Jerome Blion.

------------------------------------------------------------------------------
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