[Digikam-users] Mysql/MariaDb database expert needs...
michael at jamhome.us
Wed Dec 2 14:52:06 GMT 2015
Ignore my previous message. Time for me to have a cup of coffee before writing.
On Thu, Nov 12, 2015 at 03:26:45PM +0100, Gilles Caulier wrote:
> 2015-11-12 15:15 GMT+01:00 Myriam Schweingruber <myriam at kde.org>:
> > Hi all,
> > seems I posted from the wrong address the first time...
> > On Thu, Nov 12, 2015 at 10:55 AM, Gilles Caulier
> > <caulier.gilles at gmail.com> wrote:
> > > At least, somebody can said me if an internal Mysql solution is suitable
> > or
> > > not without to hack the DB installation outside digiKam.
> > >
> > > I read all bugzilla entries, and to setup Mysql, users need to grant
> > > privileges by hand before to configure digiKam with it.
> > >
> > > This is not possible to do the same with an internal server, since few
> > years
> > > ago, Mysql switch DB engine to ImmoDB which require granted privilege to
> > > create DB indexes. And this is typically the problem that i can see when
> > i
> > > want to create the MySql DB through the internal server.
> > >
> > > If i look how Amarok do with Mysql, internal server solution do not
> > exist.
> > > Only a remote server is avaialble in setup.
> > That is not correct, Amarok uses MySQL embedded by default, setting up
> > an external MySQL server is just an additional option for people who
> > need to share a database across computers.
> Ah, it's not SQlite... Interesting...
> So my question is : how to create DB indexes and triggers with an internal
> solution. When i look in bugzilla, some users have investigated and see
> that mysql indexes creation need granted privileges since immodb DB engine
> is used. And this is true : i reproduced the dysfunction and fixed it.
> Or perhaps Amarok do not use Indexes and triggers. In this case, DB
> performances will just down...
> Or perhaps Amarok do not use immodb engine...
> Gilles Caulier
> Digikam-users mailing list
> Digikam-users at kde.org
Michael Rasmussen, Portland Oregon
Be Appropriate && Follow Your Curiosity
Bicycles are traffic
~ Critical Mass
More information about the Digikam-users