[digiKam-users] Just over 100k photos - mysql internal or sqlite

[Mark Otway]

I found both sqlite and mysql were equally slow and painful with a
collection of 400k images which are stored across the network. ;)

On Wed, 29 May 2019 at 13:02, Gilles Caulier <caulier.gilles at gmail.com>
wrote:

> Hi,
>
> At home, my collection is over 250.000 files with sqlite. Database and
> files are stored on SSD and it's enough fast.
>
> GillesC aulier
>
> Le mer. 29 mai 2019 à 12:24, Dougie Nisbet <dougie at katsura.uk> a écrit :
>
>> Since I'm just starting out with digikam I thought this was the time to
>> experiment with migrating to mysql. On the configuration screen digiKam can
>> find the binary for mysql_install_db but not mysqld. mysqld is installed
>> and when I use 'find' to tell it that the binary is in /usr/sbin/mysqld it
>> looks promising.
>>
>> However, trying to migrate the database gives the pop-up error window:
>>
>> An error occurred during the internal server start.
>>
>> Details: Could not start database initialiser.
>>
>> Executable: mysql_install_db
>>
>> Arguments: --datadir=/store1/images/.mysql.digikam/db_data,
>> --defaults-file=/tmp/.mount_digikaJbT7bS/usr/share/digikam/database/mysql-global.conf
>>
>> Process error: Unknown error
>>
>> and on the command line I see:
>>
>> Digikam::DatabaseServer::processErrorLog: Arguments:
>> "--datadir=/store1/images/.mysql.digikam/db_data,
>> --defaults-file=/tmp/.mount_digikaJbT7bS/usr/share/digikam/database/mysql-global.conf"
>> Digikam::DatabaseServer::processErrorLog: Stdout: "Neither host 'office'
>> nor 'localhost' could be looked up with\n'/usr/sbin/resolveip'\nPlease
>> configure the 'hostname' command to return a correct\nhostname.\nIf you
>> want to solve this at a later stage, restart this script\nwith the --force
>> option\n\nThe latest information about mysql_install_db is available
>> at\nhttps://mariadb.com/kb/en/installing-system-tables-mysql_install_db\n
>> <http://mariadb.com/kb/en/installing-system-tables-mysql_install_db%5Cn>"
>>
>> which is a bit off. resolveip is a command I didn't know existed but
>> running it returns a local IP address for my host.
>>
>> Performance using sqlite seems ok, and at just over 100k images I'm
>> probably a borderline case so I thought I would try the mysql database
>> option out of curiosity.
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20190529/0f5347e6/attachment.html>