On Di, 25 Okt 2005, Arno Lehmann <[EMAIL PROTECTED]> wrote: > Hmm. You didn't tell us what server you have behind your cataog > database, and if that machine is usually loaded or not.
Sorry, I was a little in a hurry when I wrote the mail! It's a dual 1.3GHz Pentium 3 with 1.5G of RAM and 2x120GB Disks. It run's some other little things, too. The load during the day is about 1, in the night it's less. I don't think that harware is the problem, because one week ago, bacula used to run on a 2x2GHz Athlon with 2GB RAM (dedicated to bacula) and the problem was the same. > > Anyway, for reference: I've got an Athlon 500 MHz with 512 MB RAM > working as my all-purpose server. That machines load is usually less > than one, this weeks average was 0.6, for example. > The Bacula catalog File table is a little smaller than yours: 1.3 GB > data, >13500000 rows, and about 800 MB indexes. > Pruning / recycling is also automatic here, but usually takes less than > 15 minutes. I haven't any reports with pruning in them to give more > exact times at the moment. Anyway, the DIR never was busier longer than > I expected. That's great. That's what I expect! [.....] > Well, a "show index from File" gives me 7 result rows, representing 5 > indexes. Mine show this: mysql> show index from File; | File | 0 | PRIMARY | 1 | FileId | A | 22336637 | NULL | NULL | | BTREE | | | File | 1 | FilenameId | 1 | FilenameId | A | 7445545 | NULL | NULL | | BTREE | | | File | 1 | FilenameId | 2 | PathId | A | 22336637 | NULL | NULL | | BTREE | | It's only three indexes!! Probably that's the reason! There's indexes missing! I'll look in the bacula source an create all the missing indexes! I expect this to fix the problem! Thanks for your help! Regards Volker -- Volker Sauer * Alexanderstrasse 39/217 * 64283 Darmstadt Telefon: 06151-154260 * Mobil: 0179-6901475 * ICQ#98164307 mailto:[EMAIL PROTECTED] * http://www.volker-sauer.de PGPKey-Fingerprint: DB2611C7B12E0B2739992E4F7E354E4D5DD5D0E0
signature.asc
Description: Digital signature