<div dir="auto">Thanks Gilles, that makes sense.</div><div dir="auto">I don’t think that I need the logs, so I will amend the MariaDB configuration.</div><div dir="auto">Best regards </div><div dir="auto">Steve</div><div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Fri, 11 Jul 2025 at 18:42, <<a href="mailto:digikam-users-request@kde.org">digikam-users-request@kde.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Digikam-users mailing list submissions to<br>
<a href="mailto:digikam-users@kde.org" target="_blank">digikam-users@kde.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://mail.kde.org/mailman/listinfo/digikam-users" rel="noreferrer" target="_blank">https://mail.kde.org/mailman/listinfo/digikam-users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:digikam-users-request@kde.org" target="_blank">digikam-users-request@kde.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:digikam-users-owner@kde.org" target="_blank">digikam-users-owner@kde.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Digikam-users digest..."<br>
Today's Topics:<br>
<br>
1. Re: digikam mysql-bin files (Gilles Caulier)<br>
2. Re: Still cant figure out face recognition under 8.7<br>
(Chad Bersche)<br>
<br><br><br>---------- Forwarded message ----------<br>From: Gilles Caulier <<a href="mailto:caulier.gilles@gmail.com" target="_blank">caulier.gilles@gmail.com</a>><br>To: digiKam - Home Manage your photographs as a professional with the power of open source <<a href="mailto:digikam-users@kde.org" target="_blank">digikam-users@kde.org</a>><br>Cc: <br>Bcc: <br>Date: Fri, 11 Jul 2025 18:37:53 +0200<br>Subject: Re: digikam mysql-bin files<br>Hi Steve,<br>
<br>
The files you're referring to are binary log files used by MariaDB (or<br>
MySQL) for replication and certain data recovery operations. They are<br>
not specific to digiKam but are instead a feature of the database<br>
system that digiKam uses.<br>
<br>
Here's a brief explanation of these files:<br>
<br>
Binary Logs (binlogs): These logs record all data changes in the<br>
database, which can be used for replication and point-in-time<br>
recovery. Each log file is assigned a sequential number, and the files<br>
can accumulate over time.<br>
<br>
Given that these files are taking up a significant amount of space,<br>
you might want to manage them. Here are some steps you can take:<br>
<br>
Check if Binary Logging is Necessary: If you are not using replication<br>
or point-in-time recovery, you might not need binary logging at all.<br>
You can disable binary logging in your MariaDB configuration file<br>
(my.cnf or my.ini).<br>
<br>
Purge Old Binary Logs: If you need binary logging, you can still purge<br>
old logs that are no longer necessary. MariaDB provides commands to do<br>
this safely:<br>
<br>
PURGE BINARY LOGS BEFORE '2024-01-01 00:00:00';<br>
<br>
This command will delete all binary log files created before the<br>
specified date and time.<br>
<br>
Set an Expiration Period: You can configure MariaDB to automatically<br>
purge binary logs after a certain period. This can be done by setting<br>
the expire_logs_days variable in your MariaDB configuration file.<br>
<br>
Backup and Remove: Before deleting any files manually, ensure you have<br>
a complete backup of your database. If you decide to manually remove<br>
the files, you should also update the binary log index file to reflect<br>
the changes.<br>
<br>
Consult Documentation: Always refer to the official MariaDB<br>
documentation or consult with a database administrator to ensure you<br>
are following best practices for your specific setup.<br>
<br>
If you are unsure about any of these steps, it might be best to<br>
consult with someone who has experience with MariaDB administration to<br>
avoid any potential data loss or corruption...<br>
<br>
My best<br>
<br>
Gilles Caulier<br>
<br>
<br>
Le ven. 11 juil. 2025 à 17:48, Steve Franks <<a href="mailto:stevef48@gmail.com" target="_blank">stevef48@gmail.com</a>> a écrit :<br>
><br>
> My PC has 357 pairs of files named mysql-bin.999999 and mysql-bin.99999.bin in the digikam\.mysql.digikam\db_data folder.These are taking up 51.5GB on my SSD so I would like to remove any that are not necessary.<br>
> Is this a digikam issue, or MariaDB? Are they all necessary? Are any of them necessary?<br>
> Thanks in advance,<br>
> Steve<br>
<br>
<br><br><br>---------- Forwarded message ----------<br>From: Chad Bersche <<a href="mailto:chad@bersche.com" target="_blank">chad@bersche.com</a>><br>To: <a href="mailto:digikam-users@kde.org" target="_blank">digikam-users@kde.org</a><br>Cc: <br>Bcc: <br>Date: Fri, 11 Jul 2025 12:42:00 -0500<br>Subject: Re: Still cant figure out face recognition under 8.7<br>
<div>
<p>Well, at least it's not just me. Let's hope there's a way to
reproduce the issue, and hopefully a remedy can be forthcoming, as
the face recognition, along with the map data, is one of the key
items I wanted out of DigiKam. I'm just starting with it, having
just gotten it working with an external MySQL/MariaDB with 8.7, so
I'm ready to go forward and make great use of it.</p>
<p> --Chad</p>
<p><br>
</p>
<div>On 7/11/2025 11:31 AM, Charlie
Gorichanaz wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>Wow, I actually am seeing the same behavior currently. For
the record, Arch linux cache files tell me I upgraded to 8.6.0
June 5, and then to 8.7.0 June 30. I don't think I did any
face tagging work since June 30 until I tried yesterday.</div>
<div><br>
</div>
<div>I previously had around 300 items in my "Unconfirmed"
folder according to the number after that word in parentheses,
but none were showing up when I clicked on it. I ran a
"Recognize faces only" on a large chunk of my albums with the
quality slider bumped down from 7 to 6, hoping to catch a lot
more faces. The end result changed that tag to say
"Unconfirmed (0)". Then I ran a full "Scan all images" process
on a section of my library I had not processed yet. It then
told me it found 282 faces, and my unknown tag increased to
now say "Unknown (3262)", but I still have "Unconfirmed (0)".</div>
<div><br>
</div>
<div>So maybe something about this broke in 8.7.0?!</div>
<div><br>
</div>
<div>
<div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>—</div>
<div>Charlie Gorichanaz</div>
</div>
</div>
</div>
<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Fri, Jul 11, 2025 at
5:46 AM Chad Bersche <<a href="mailto:chad@bersche.com" target="_blank">chad@bersche.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Hi Charlie, et. al</p>
<p>I have an Unconfirmed tag, but it has zero images in it,
even after multiple "recognize faces" runs. </p>
<p>Once I did the initial scan all images, the Unknown tag
had ~6000 images in it. I classified probably ~800 of
those naming individuals correctly. I then re-ran the
process as you indicated using "Recognize faces only" on
all of my albums. I watched it as it zoomed thru images,
showing faces in the process of those in the image that
it'd previously detected. At the conclusion of the face
detection, which took several minutes, it came back
stating it scanned over 5,533 images and found ZERO
faces. Nothing moved from Unknown to Unconfirmed. This
is the same outcome every single time I've tried this.<br>
</p>
<p>So, what now? I've been tempted to try to re-create the
training data, but haven't done so yet. <br>
</p>
<p> -- Chad</p>
<p><br>
</p>
<div>On 7/10/2025 10:07 PM, Charlie Gorichanaz wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>Chad,</div>
<div><br>
</div>
<div>Do you have a tag called "Unconfirmed" alongside
your "Unknown" tag? I believe that's where the
detected-and-potentially-matched faces should end up,
waiting for you to confirm or reject them.</div>
<div><br>
</div>
<div>The doc describes this under the Face recognition
section, "To start this process, go to the workflow
tab, select <strong>Recognize faces only</strong>,
and then click <strong>Scan Collection For Faces</strong>.
The process will tag similar <strong>detected</strong>
faces with the appropriate People tag from your tag
tree, and the corresponding thumbnail will disappear
from the <strong>Unknown</strong> tag selection. The
thumbnail will appear in the <strong>Unconfirmed</strong>
tag section and will be added to the suggested face
tag section."</div>
<br>
<div>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div>—</div>
<div>Charlie Gorichanaz</div>
</div>
</div>
</div>
<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Jul 10, 2025
at 7:14 PM Chad A. Bersche <<a href="mailto:chad@bersche.com" target="_blank">chad@bersche.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">I've
been baffled by this as well. I'm running on Windows
11, DigiKam <br>
8.7, and downloaded all the modules. I let it grind
thru a bunch of my <br>
libraries overnight. It resulted in about 6000 images
in the Unknown <br>
category. I spent a a couple hours assigning names to
people in that <br>
list (sometimes up to 200-300 images). I still have
5500 in the Unknown <br>
bucket after classifying several hundred.<br>
<br>
After doing that, I went to run the "Recognize faces
only" with <br>
Accuracy=7, Search in set to "All Albums" and Tags
unchecked. Then when <br>
I do the "Scan collection for faces" nothing changes,
and all the same <br>
Unknown images stay in the same Unknown bucket.<br>
<br>
What am I doing wrong? I had hoped that tagging a
good number of faces <br>
before doing the recognition would improve its
accuracy, but it seems to <br>
just want me to do all the assignment work, which I
kinda don't want to do.<br>
<br>
I'm using an external SQL database, with the database
running on Linux, <br>
because I do use the same image libraries across
Windows clients.<br>
<br>
Thanks for any help/suggestions!<br>
<br>
-- Chad<br>
<br>
On 7/8/2025 10:43 PM, Gilles Caulier wrote:<br>
> Hi,<br>
><br>
> You need to first detect faces on albums before
you recognize them.<br>
> After detecting, manually tag a few faces with
names, at least a few<br>
> ones are enough to teach the AI for an automated
recognition.<br>
><br>
> Finally, run a recognition process and look as AI
recognizes similar<br>
> faces already registered in the model but not yet
tagged in the<br>
> database.<br>
><br>
> The workflow is explained in the online doc :<br>
> <a href="https://link.bersche.com/click/20qyoQWWIOi2.29UmT_C0unWi.UJlc-QSwsLm/hoVYqVvO/3s/link.bersche.com/click/JrntK3g7lIuw.vrQMszT3ZBH1.tlPdogxGHMJ/IxL1-iQT/3s/docs.digikam.org/en/left_sidebar/people_view.html" rel="noreferrer" target="_blank">https://docs.digikam.org/en/left_sidebar/people_view.html</a><br>
><br>
> Best<br>
><br>
> Gilles Caulier<br>
><br>
> Le mer. 9 juil. 2025 à 02:08, robert lindsay<br>
> <<a href="mailto:robert.lindsay@gmail.com" target="_blank">robert.lindsay@gmail.com</a>>
a écrit :<br>
>> This is under intel mac os and I installed
the modules it asked for in installation. Under face
recognition their are boxes for rebuilding and
training data, but i can't find on to start face
recognition on albums<br>
</blockquote>
</div>
</blockquote>
<div><img alt="" src="https://link.bersche.com/open/JrntK3g7lIuw.vrQMszT3ZBH1.tlPdogxGHMJ/1.gif"></div>
</div>
</blockquote>
</div>
</blockquote>
<div><img alt="" src="https://link.bersche.com/open/20qyoQWWIOi2.29UmT_C0unWi.UJlc-QSwsLm/1.gif"></div></div>
_______________________________________________<br>
Digikam-users mailing list<br>
<a href="mailto:Digikam-users@kde.org" target="_blank">Digikam-users@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/digikam-users" rel="noreferrer" target="_blank">https://mail.kde.org/mailman/listinfo/digikam-users</a><br>
</blockquote></div></div>