Hi all!

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

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

OS is: Debian Lenny

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?


Thanks in advance!

Ilya

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