Greeting to all - I hope you’re enjoying your Christmas!
I run Orthanc in it’s own container, connecting to another (MySQL) container. I’ve noticed that the MySQL container is running for a lengthy period at close to 100%. U use show processlist; to show me what it’s doing and I see the following on the Orthanc DB : DELETE FROM Resources WHERE internalId IN (SELECT internalId FROM DeletedResources)
However, when I change to the Orthanc database, there is no DeletedResources table (there is a Resources table).
Has my database become corrupt somehow - should there be a DeletedResources table?
The DeletedResources is indeed a temporary table that is created only for the duration of a transaction. That’s why you see it in the process list but not in the schema.