[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] small mysql patch


On Wednesday 03 September 2008 08:22:31 Yuri Timofeev wrote:
> Hi
>
> 2008/8/31 Eric Bollengier <eric@xxxxxxxxxxxxxxxx>:
> > If you want to use new indexes with dbcheck, you can modify dbcheck.c in
> > this way :
> >  - ask to the user if he wants to add them (think about disk space)
> >  - add them + run analyse
> >  - run the cleanup operation
> >  - remove them
> >
> > FYI, postgresql can use composite indexes, so it will require less
> > indexes than mysql.
>
> It seems the problem appears only when working with MYSQL.
>
> I made a small program in order to make temporary index
> CREATE INDEX idxFJ  ON File (FileId, JobId);
> and then removes him.
>
> Now I little understand a  Bacula API. And there is one problem:
> my source code depends on the DBMS (MySQL).
> And I still do not know how it can be inserted in dbcheck.c
>
>
> If I write (in dbcheck.c) as follows:
>
> # ifdef HAVE_MYSQL
> / * My code uses bacula api * /
> # endif
>
> So it would be wrong, imho, or is this possible?
> Can you suggest any solution?

Please be specific about the exact MySQL dependencies.



-------------------------------------------------------------------------
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
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.