I am new to digiKam. I currently use the database Type: SQLite and everything works quite well. But because I manage about 120,000 photos, I also tried the Mysql-Internal recommended by digiKam, but this makes the program very unstable, it crashes very often. My question: Can I continue to use the SQLite without hesitation, although I want to manage more than 100,000 photos or would it make sense to get the Mysql to work? System: Manjaro Linux XFCE
I am new to digiKam. I currently use the database Type: SQLite and everything works quite well. But because I manage about 120,000 photos, I also tried the Mysql-Internal recommended by digiKam, but this makes the program very unstable, it crashes very often. My question: Can I continue to use the SQLite without hesitation, although I want to manage more than 100,000 photos or would it make sense to get the Mysql to work?
Which Mysql | Mariadb version did you use exactly ?
Unfortunately, I don't really understand your question, (? Mariabdb?) but maybe that's what you were asking for: Mysql-Internal mysql_install_db mysqladmin mysqld
*** Bug 442450 has been marked as a duplicate of this bug. ***
You can also use SQLite for 100,000+ photos. However, MySQL internally is not unstable either; many users use it. first we need the version number of mysql, as requested by Gilles. Enter the following in a terminal and post the output here "mysql -V". Maik
Hello Maik Quallmann, thanks for the hint on how I can find out the version. Here it is: mysql Ver 15.1 Distrib 10.6.4-MariaDB, for Linux (x86_64) using readline 5.1
MySQL/MariaDB version 10.6.X does not work with the Qt-MySQL driver. See the story in the duplicate bug report. There is already a fix in current Qt versions. You would have to go back to a MySQL/MariaDB version 10.5.X. Maik *** This bug has been marked as a duplicate of bug 440296 ***
Hello Maik Qualmann, thank you very much for the help. Only, please, note, I am only since 10 months with Linux and completely overwhelmed by this infos. Still I have no idea how "to to go back to a MySQL/MariaDB version 10.5.X". And how to avoid that an update undoes everything again. I will try to familiarize myself with it. And I would like to mention that I am very enthusiastic about the Linux community and OpenSource: simply great. My question: Can I stay with SQLite without hesitation, or: When is it important to switch to Mysql-Internal?
Keep using SQLite, that's no problem at all. You have to wait until your Linux distribution provides corrected Qt packages via updates. The problem with the current MySQL/MariaDB version and the Qt-driver does not only affect digiKam. Maik
Hello Maik, Your info I understood well, thank you very much.
If you are on ArchLinux (and friends like Manjaro) you can do: # downgrade mariadb mariadb-clients mariadb-libs (as root)
Fixed with #440296
Unfortunately, there is again an error with mariadb. When I update mariadb from 10.06.5-2 to 10.8.3-1, then digiKam no longer works when i had chosen mysql.
digiKam and other software currently does not work with MariaDB-10.8.x. Keep in mind that MariaDB-10.8 is a development release and is not meant to be used in production environments. Here is a bug report from Akonadi with the same problem: https://bbs.archlinux.org/viewtopic.php?id=277078 Maik
On Tue, 14 Jun 2022 21:06:10 +0000 diekuhrannte@web.de wrote: > https://bugs.kde.org/show_bug.cgi?id=442451 Michael war fleißig... gut!