[Digikam-users] Mysql/MariaDb database expert needs...
Henrique Santos Fernandes
sf.rique at gmail.com
Tue Nov 17 17:52:56 GMT 2015
Great news!
Gilles, if i may ask can you run this comands on your mysql?
> show databases;
it should show:
digikamcoredb
digikamfacedb
digikamthumbsdb
Bytheway, this names are configurable?
> show grants for 'user'@'%'; now this user and the % will depend on what
user are you using!
I guess it does not matter the content on mysql folders, only what the
database shows right? i dont thing we suppose to make chnages directly on
the disk for mysql.
Anyway, i wish i could help but i am a bit without time.. i might try to
install and etc some other time on a virtual machine but no promises!
Great Job!
Em ter, 17 de nov de 2015 às 15:22, Gilles Caulier <caulier.gilles at gmail.com>
escreveu:
> Hi all,
>
> I back in this thread, with some fresh news :
>
> The database schema for Faces Recognition database integration to digiKam
> core is now complete. With Mysql, the face database is now integrated as
> well. There is a new setting in DB setup to specify a Face Schema Name on
> your server.
>
> I fixed also some typo in SQL statements for the database creation. After
> few days to try to understand how it's work, i can said that Mysql code is
> really more complex than SQlite. For ex, about the famous functions to
> create Indexes which require grant privileges, i don't yet found an
> alternative, to be able to prevent databases creation with these settings
> and to restore internal server.
>
> Any way, i review ALL database code, renamed, tried, cleaned, factored,
> simplified, documented implementations when it's possible. I found some
> glitches in code but I'm not sure if this will really fix serious problems.
>
> As now the code is better to ready and maintain, i will start to hack
> really MySql support. The bugs are already well identified in bugzilla and
> some entries are reproducible on my computer.
>
> So, if i need help, it's about to test with all possible user cases.
>
> There are 3 configurations :
>
> 1/ using a server (local or remote) with 3 separated databases ==> It's
> definitively the best configuration. All is well separated and clear. it's
> already set on my computer and this will be the first stage to hack.
>
> 2/ using a server (local or remote) with a single and common database ==>
> second stage to hack
>
> 3/ using internal server : do not work due to functions in DB. ==> last
> stage to hack, later...
>
> So if there are some volunteers to help me to test, no need to report new
> entries in bugzilla, but please review existing files and check if problems
> still reproducible with the current implementation from git/master (digiKam
> 5.0.0 ported to Qt5)
>
> Thanks in advance
>
> PS : for information, the case 1/ give me the DB content below on my
> server :
>
> [root at localhost mysql]# pwd
> /var/lib/mysql
> [root at localhost mysql]# ls -al
> total 176184
> drwxr-xr-x 8 mysql mysql 4096 Nov 17 17:18 ./
> drwxr-xr-x 42 root root 4096 Nov 16 23:48 ../
> -rw-rw---- 1 mysql mysql 16384 Nov 17 00:05 aria_log.00000001
> -rw-rw---- 1 mysql mysql 52 Nov 17 00:05 aria_log_control
> drwx------ 2 mysql mysql 4096 Nov 17 17:51 digikamcoredb/
> drwx------ 2 mysql mysql 4096 Nov 16 23:52 digikamfacedb/
> drwx------ 2 mysql mysql 4096 Nov 16 23:50 digikamthumbsdb/
> -rw-rw---- 1 mysql mysql 79691776 Nov 17 17:54 ibdata1
> -rw-rw---- 1 mysql mysql 50331648 Nov 17 17:54 ib_logfile0
> -rw-rw---- 1 mysql mysql 50331648 Nov 16 23:48 ib_logfile1
> -rw-rw---- 1 mysql mysql 0 Nov 16 23:48 multi-master.info
> drwx------ 2 mysql mysql 4096 Nov 16 23:48 mysql/
> srwxrwxrwx 1 mysql mysql 0 Nov 17 17:18 mysql.sock=
> drwx------ 2 mysql mysql 4096 Nov 16 23:48 performance_schema/
> -rw-rw---- 1 mysql mysql 2760 Nov 17 17:56 sql_errors.log
> drwx------ 2 mysql mysql 4096 Nov 16 23:48 test/
> [root at localhost mysql]# ls -al digikamcoredb/
> total 4244
> drwx------ 2 mysql mysql 4096 Nov 17 17:51 ./
> drwxr-xr-x 8 mysql mysql 4096 Nov 17 17:18 ../
> -rw-rw---- 1 mysql mysql 1582 Nov 16 23:50 AlbumRoots.frm
> -rw-rw---- 1 mysql mysql 114688 Nov 16 23:51 AlbumRoots.ibd
> -rw-rw---- 1 mysql mysql 1612 Nov 16 23:50 Albums.frm
> -rw-rw---- 1 mysql mysql 114688 Nov 16 23:51 Albums.ibd
> -rw-rw---- 1 mysql mysql 65 Nov 16 23:49 db.opt
> -rw-rw---- 1 mysql mysql 38 Nov 16 23:50 delete_image.TRN
> -rw-rw---- 1 mysql mysql 36 Nov 16 23:50 delete_tag.TRN
> -rw-rw---- 1 mysql mysql 1553 Nov 16 23:50 DownloadHistory.frm
> -rw-rw---- 1 mysql mysql 114688 Nov 16 23:50 DownloadHistory.ibd
> -rw-rw---- 1 mysql mysql 2470 Nov 16 23:50 ImageComments.frm
> -rw-rw---- 1 mysql mysql 180224 Nov 16 23:51 ImageComments.ibd
> -rw-rw---- 1 mysql mysql 2042 Nov 16 23:50 ImageCopyright.frm
> -rw-rw---- 1 mysql mysql 360448 Nov 16 23:51 ImageCopyright.ibd
> -rw-rw---- 1 mysql mysql 1045 Nov 16 23:50 ImageHaarMatrix.frm
> -rw-rw---- 1 mysql mysql 98304 Nov 16 23:50 ImageHaarMatrix.ibd
>
>
> -rw-rw---- 1 mysql mysql 1604 Nov 16 23:50 ImageHistory.frm
>
>
> -rw-rw---- 1 mysql mysql 573440 Nov 16 23:51 ImageHistory.ibd
>
> -rw-rw---- 1 mysql mysql
> 1713 Nov 16 23:50 ImageInformation.frm
>
> -rw-rw---- 1 mysql mysql 311296 Nov 16 23:51
> ImageInformation.ibd
>
> -rw-rw---- 1 mysql mysql 1514 Nov 16 23:50 ImageMetadata.frm
>
>
> -rw-rw---- 1 mysql mysql 311296 Nov 16 23:51 ImageMetadata.ibd
>
> -rw-rw---- 1 mysql mysql
> 1292 Nov 16 23:50 ImagePositions.frm
>
> -rw-rw---- 1 mysql mysql 196608 Nov 16 23:51
> ImagePositions.ibd
>
> -rw-rw---- 1 mysql mysql 999 Nov 16 23:50 ImageProperties.frm
>
> -rw-rw---- 1 mysql mysql
> 114688 Nov 16 23:51 ImageProperties.ibd
>
> -rw-rw---- 1 mysql mysql 1959 Nov 16 23:50
> ImageRelations.frm
>
>
> -rw-rw---- 1 mysql mysql 147456 Nov 16 23:51 ImageRelations.ibd
>
> -rw-rw---- 1 mysql mysql
> 3226 Nov 16 23:50 Images.frm
>
>
> -rw-rw---- 1 mysql mysql 655360 Nov 16 23:51 Images.ibd
>
>
> -rw-rw---- 1 mysql mysql 1408 Nov 16 23:50 Images.TRG
>
> -rw-rw---- 1 mysql
> mysql 2003 Nov 16 23:50 ImageTagProperties.frm
>
> -rw-rw---- 1 mysql mysql 147456 Nov 17 17:54
> ImageTagProperties.ibd
>
> -rw-rw---- 1 mysql mysql 1932 Nov 16 23:50 ImageTags.frm
>
> -rw-rw---- 1 mysql mysql
> 262144 Nov 17 17:53 ImageTags.ibd
>
>
> -rw-rw---- 1 mysql mysql 1017 Nov 16 23:50 Searches.frm
>
>
> -rw-rw---- 1 mysql mysql 98304 Nov 16 23:50 Searches.ibd
>
>
> -rw-rw---- 1 mysql mysql 970 Nov 16 23:50 Settings.frm
>
> -rw-rw---- 1 mysql
> mysql 114688 Nov 17 17:52 Settings.ibd
>
> -rw-rw---- 1 mysql mysql 996 Nov 16
> 23:50 TagProperties.frm
>
>
> -rw-rw---- 1 mysql mysql 114688 Nov 17 17:53 TagProperties.ibd
>
> -rw-rw---- 1 mysql mysql
> 1094 Nov 16 23:50 Tags.frm
> -rw-rw---- 1 mysql mysql 98304 Nov 17 17:53 Tags.ibd
> -rw-rw---- 1 mysql mysql 567 Nov 16 23:50 TagsTree.frm
> -rw-rw---- 1 mysql mysql 489 Nov 16 23:50 Tags.TRG
> -rw-rw---- 1 mysql mysql 1241 Nov 16 23:50 VideoMetadata.frm
> -rw-rw---- 1 mysql mysql 98304 Nov 16 23:50 VideoMetadata.ibd
> [root at localhost mysql]# ls -al digikamthumbsdb/
> total 19120
> drwx------ 2 mysql mysql 4096 Nov 16 23:50 ./
> drwxr-xr-x 8 mysql mysql 4096 Nov 17 17:18 ../
> -rw-rw---- 1 mysql mysql 1456 Nov 16 23:50 CustomIdentifiers.frm
> -rw-rw---- 1 mysql mysql 131072 Nov 17 17:53 CustomIdentifiers.ibd
> -rw-rw---- 1 mysql mysql 65 Nov 16 23:49 db.opt
> -rw-rw---- 1 mysql mysql 1450 Nov 16 23:50 FilePaths.frm
> -rw-rw---- 1 mysql mysql 212992 Nov 17 17:53 FilePaths.ibd
> -rw-rw---- 1 mysql mysql 970 Nov 16 23:50 Settings.frm
> -rw-rw---- 1 mysql mysql 114688 Nov 17 17:52 Settings.ibd
> -rw-rw---- 1 mysql mysql 1061 Nov 16 23:50 Thumbnails.frm
> -rw-rw---- 1 mysql mysql 18874368 Nov 17 17:53 Thumbnails.ibd
> -rw-rw---- 1 mysql mysql 1603 Nov 16 23:50 UniqueHashes.frm
> -rw-rw---- 1 mysql mysql 212992 Nov 17 17:53 UniqueHashes.ibd
> [root at localhost mysql]# ls -al digikamfacedb/
> total 552
> drwx------ 2 mysql mysql 4096 Nov 16 23:52 ./
> drwxr-xr-x 8 mysql mysql 4096 Nov 17 17:18 ../
> -rw-rw---- 1 mysql mysql 65 Nov 16 23:49 db.opt
> -rw-rw---- 1 mysql mysql 42 Nov 16 23:52 delete_identities.TRN
> -rw-rw---- 1 mysql mysql 948 Nov 16 23:52 Identities.frm
> -rw-rw---- 1 mysql mysql 98304 Nov 16 23:52 Identities.ibd
> -rw-rw---- 1 mysql mysql 375 Nov 16 23:52 Identities.TRG
> -rw-rw---- 1 mysql mysql 1018 Nov 16 23:52 IdentityAttributes.frm
> -rw-rw---- 1 mysql mysql 114688 Nov 16 23:52 IdentityAttributes.ibd
> -rw-rw---- 1 mysql mysql 1131 Nov 16 23:52 OpenCVLBPHistograms.frm
> -rw-rw---- 1 mysql mysql 98304 Nov 16 23:52 OpenCVLBPHistograms.ibd
> -rw-rw---- 1 mysql mysql 1066 Nov 16 23:52 OpenCVLBPHRecognizer.frm
> -rw-rw---- 1 mysql mysql 98304 Nov 16 23:52 OpenCVLBPHRecognizer.ibd
> -rw-rw---- 1 mysql mysql 970 Nov 16 23:52 Settings.frm
> -rw-rw---- 1 mysql mysql 114688 Nov 17 17:52 Settings.ibd
>
> Gilles Caulier
>
> _______________________________________________
> 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/20151117/94272521/attachment.html>
More information about the Digikam-users
mailing list