[Digikam-users] Mysql/MariaDb database expert needs...

[Gilles Caulier]

This what's i suspected. Thanks for these clarifications.

Gilles Caulier

2015-11-12 16:52 GMT+01:00 Richard Mortimer <richm+digikam at oldelvet.org.uk>:

>
>
> On 12/11/2015 13:51, Gilles Caulier wrote:
> >
> > The here another pending and very important question :
> >
> > With digiKam 5.0.0, we will have 3 database to manage :
> >
> > 1/ Core DB
> > 2/ Thumbnails DB
> > 3/ Face DB (since libkface is merged in digiKam core)
> >
> > For each digiKam database we can use a specific name. By default i used
> > the name name (digikamdb) here to test, and it work for Core and
> > Thumbnails DB. Face DB don't work and investiguations are under
> progress...
> >
> > So, the question is : why we have the capability to separate Core,
> > Thumbnails, and Face DB with different name (as for ex digikamcoredb,
> > digkamthumbsdb, and digikamfacedb) ?
> >
> > In my /var/lib/mysql, i can see separated subfolders to host DB ? What's
> > the advantage ? backup facilities ? Performances ? What's must be the
> > default settings : common name or separated name ?
>
> The one advantage of having separate databases is for backup purposes.
> The thumbnail database in particular can be massive and having it
> separate makes it easier especially since it is basically throwaway data
> anyway.
>
> The performance of MySQL doesn't really come into it. You can in theory
> partition different databases into different locations/disks etc. and
> that might be of interest to some but it would be a pretty special use
> case.
>
> I think that the correct default would be to use a common name for all
> three but allow separate names if required.
>
> Regards
>
> Richard
>
> >
> > All this point are not clear for me (and also for end users as i can see
> > in bugzilla).
> >
> >
> >
> >     I prefere mysql cause it would be possible/easier to use digikam on
> >     multiple computers with the same database!
> >
> >
> > Sure, this is another important feature, which introduce other
> > dysfunctions as i can see in bugzilla.
> >
> > We must investigate step by step, first with simple user cases...
> >
> > Gilles Caulier
> >
> >
> > _______________________________________________
> > Digikam-users mailing list
> > Digikam-users at kde.org
> > https://mail.kde.org/mailman/listinfo/digikam-users
> >
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20151112/2170443f/attachment.html>