[Digikam-users] Mysql/MariaDb database expert needs...
caulier.gilles at gmail.com
Thu Nov 12 17:21:12 GMT 2015
2015-11-12 18:12 GMT+01:00 Richard Mortimer <richm+digikam at oldelvet.org.uk>:
> On 12/11/2015 16:38, Henrique Santos Fernandes wrote:
> > The one advantage of having separate databases is for backup
> > The thumbnail database in particular can be massive and having it
> > separate makes it easier especially since it is basically throwaway
> > anyway.
> > This is true. But still easy to remove or drop the tables related to it.
> > Only "problem" would be the backup size, as it would include the
> > thumbnails..
> Yes. That's my point. Dropping the tables isn't practical on a nightly
> basis. I currently have separated databases and the "main" database
> backup is 1.5 MB compressed but the thumbnails database is 650 MB
> > The performance of MySQL doesn't really come into it. You can in
> > 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
> > three but allow separate names if required.
> > I think teh default should be one database also.
> > I guess, having the possibility to separate the databases would
> > introduce much more work right? I am not sure.. not a developer.. i
> > only know some about infrastructure .
> You can already separate them and I would like to see that capability
> remain if possible.
yes, this will stay like this in code. I will improved the configuration
dialog with an advanced settings view when users want to use separated
This will be more clear for non technical users.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Digikam-users