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

[Richard Mortimer]

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
>