> Following problem that i am running in since a couple of months -
> the File-Table grew very big - approx 14 GB. The File-Index is about 10GB big.
> In the File-Table are now about 110 million rows.
> (4 weeks retention period of the IMAP-Server do the main part; about 15 
> millions
> emails on the server. 1 Full backup every week makes 60 millions. +
> All the other servers and stuff).
>

My database is 27 GB and even that does not slow anything down.

>
> The data volume that is backuped by full's is about 8 TB big and fits
> on 5 tapes.
> And the problem is now that my full's are starting at friday 21:00 and
> go till Tuesday 18:00 or so.
> Absolutely unacceptable long...
> The main time is consumed by mysql; after the Files are spooled to
> tape, it takes as good as all the time to do
>
> "INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat,
> MD5)SELECT batch.FileIndex, batch.Job ..." etc.
>
> The Index in JobID and PathID in File-Table do exists.
>
>
> The hardware used is:
>
> Pentium D CPU 2.80GHz Dual
> 1GB RAM
> about 5 TB hdd-space (external SATA2-array, Manuf. is "EasyRAID")
>
>
Way too low end hardware for what you are doing. 4 to 8 GB RAM is a
minimum for your needs.

> OS is: Debian Lenny
>
I hope you are using bacula 2.2.4 or greater

>
> The server have a max. load of 3 to 4 while doing backups.
>
> Here the "active" part of my my.cnf
> -------------
> [mysqld]
> #
> # * Basic Settings
> #
> user            = mysql
> pid-file        = /var/run/mysqld/mysqld.pid
> socket          = /var/run/mysqld/mysqld.sock
> port            = 3306
> basedir         = /usr
> datadir         = /var/lib/mysql
> tmpdir          = /tmp
> language        = /usr/share/mysql/english
> skip-external-locking
> key_buffer              = 16M
> max_allowed_packet      = 16M
> thread_stack            = 128K
> thread_cache_size       = 8
> myisam-recover          = BACKUP
> query_cache_limit       = 1M
> query_cache_size        = 16M
> -------------
>
>
> What can i do to improve the performace?
>

Besides upgrading the memory, use attribute spooling. Put the database
on raid 10. If it is on the same array as you are backing up get it
off immediately. Also you can just leave the director on this machine
and put the database on a separate server as long as you have a
gigabit connection between the machines. My bacula database has never
been on the same machine as the director.

John

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users