<html dir="ltr"><head></head><body style="text-align:left; direction:ltr;" bgcolor="#ffffff" text="#2e3436" link="#2a76c6" vlink="#2e3436"><div>Sorry I forgot to mention that I'm using MySQL/MariaDB standalone as my DigiKam database</div><div><br></div><div>To see what processes are running on your MySQL/MariaDB server, issue the following command from the mysql shell when connected as a user with access to the DigiKam database:</div><div><br></div><div>show full processlist;</div><div><br></div><div>You should see a list of current database processes including any running queries.</div><div><br></div><div>Rob</div><div><br></div><div><br></div><div>On Fri, 2018-10-19 at 16:42 +0200, Stefan Mueller wrote:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><div dir="auto">Could you share how to figure out that. <div dir="auto">That would help others doing the same debugging <br><br><div data-smartmail="gmail_signature" dir="auto">Sent from a fair mobile </div></div></div><br><div class="gmail_quote"><div dir="ltr">Le ven. 19 oct. 2018 à 16:39, Rob Dueckman <<a href="mailto:duke@dukey.org">duke@dukey.org</a>> a écrit :<br></div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><div style="text-align:left;direction:ltr" bgcolor="#ffffff" text="#2e3436" link="#2a76c6" vlink="#2e3436"><div>I have found that the majority of the startup time is spent reading the similarity database.</div><div><br></div><div>Startup takes about 8 minutes on a image collection of about 400K images. Most of the time is spent on the query "SELECT value FROM ImageSimilarity WHERE ( imageid1=? OR imageid2=? ) AND algorithm=? ..." (I don't have any of the query after the ?. Sorry)</div><div><br></div><div>Nothing is logged to the console while reading the database.If I replace the similarity database with a blank one, startup is reduced to about 34 seconds.</div><div><br></div><div>If I re-build the database, start up times are again slow.</div><div><br></div><div>This is running DK6 Beta2 Oct 15 release.</div><div><br></div><div><br></div><div>Rob</div><div><br></div><div><br></div><div><br></div><div>On Fri, 2018-10-19 at 08:22 +0000, Dumelle, Timo (E+K) wrote:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><pre>I am dropping in here.</pre><br><pre>I have 305k photos in many folders on a network share.</pre><pre>Many of the folders on that share don't contain pictures, but since the paths are kinda "mixed up" with other files I can't just scan the photos.</pre><br><pre>Dk needs about 5 - 10 minutes to start up while hanging on "reading database"</pre><pre>And nearly every operation that goes beyond just viewing pics in albums cause it to either not responding for a long time or crashing</pre><pre>Currently it is finding duplicates which seems to proceed pretty fast.</pre><br><pre>Picasa for example has absolute no problems with this pictures. </pre><pre>But I need server functions for about 20 clients to connect to the DB</pre><br><pre>Can I help with any of these tests?</pre><br><pre>-----Ursprüngliche Nachricht-----</pre><pre>Von: Digikam-users <</pre><a href="mailto:digikam-users-bounces@kde.org" target="_blank" rel="noreferrer"><pre>digikam-users-bounces@kde.org</pre></a><pre>> Im Auftrag von Rafael Linux</pre><pre>Gesendet: Freitag, 24. August 2018 00:54</pre><pre>An: </pre><a href="mailto:digikam-users@kde.org" target="_blank" rel="noreferrer"><pre>digikam-users@kde.org</pre></a><br><pre>Betreff: Re: [digiKam-users] Anyone with a +300K photos internal mysql database?</pre><br><pre>Maik, as I wrote to Gilles, I can't see how many folders cause the user is on holidays this week, and I have no access to it, but I estimate that could be</pre><pre>+13k albums, mostly with JPG photos.</pre><br><pre>I want to thank you your test, cause I was sure that the reason of the issues weren't in the hardware or the database (mysql process never fired up any CPU core).</pre><br><pre>If I can help anyway, let me know, but take into account that I can't do any test in any moment, cause the real system is not mine, so I have not access to it at my own </pre><br><br><br><pre>--</pre><pre>Sent from: </pre><a href="http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html" target="_blank" rel="noreferrer"><pre>http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html</pre></a><br></blockquote></div>
</blockquote></div>
</blockquote></body></html>