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

[Gilles Caulier]

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/bcfb6886/attachment.html>