[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Bacula-devel] small mysql patch
Adding indexes will probably speed up dbcheck, but it will slow down the
attribute insertion process and grow up the database.
The dbcheck operation have to be run once per month, maybe twice per year.
So, we can say that speed of attribute insertion is much more important than
If you want to use new indexes with dbcheck, you can modify dbcheck.c in this
- ask to the user if he wants to add them (think about disk space)
- add them + run analyse
- run the cleanup operation
- remove them
I'm not sure that all your indexes are useful, for example (FileId, JobId) is
probably used to see if you have orphan jobids in File table. The Job table
is very small compare to others, so the database engine won't use it.
Here, it's not the type of your index that will be important, it's much more
the size of the File table (hundred of million in my case) that will change
the cost of your index.
FYI, postgresql can use composite indexes, so it will require less indexes
Le Sunday 31 August 2008 19:59:03 Yuri Timofeev, vous avez écrit :
> I believe that the results of this discussion concerns
> "[Bacula-users] Bacula 2.2.8, dbcheck never completes"
> requires a small patch, see attached file.
> Since all fields (which fall in the indices) type INTEGER the size of
> the indices will be low and increase speed dbcheck will be very
> As you think?
> ps. I think the same indices are needed for DB Postgresql.
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
Bacula-devel mailing list
This mailing list archive is a service of Copilotco.