[kdepim-users] akonadi fsck fails
joost at antarean.org
Wed Aug 26 18:01:48 BST 2015
On 26 August 2015 18:45:27 CEST, Pablo Sanchez <pablo at blueoakdb.com> wrote:
>[ Comments below, in-line ]
>On 08/26/2015 12:23 PM, J. Roeleveld wrote:
>>> DELETE FROM pimitemflagrelation
>>> > LEFT JOIN pimitemtable
>>> > ON pimitemflagrelation.pimitem_id =
>>> > WHERE pimitemtable.id IS NULL;
>>> >I'm not sure whether MySQL supports a LEFT JOIN in the DELETE but
>>> >should be able to give it a whirl. :)
>> Personally, I don't care about MySQL. So someone who uses that will
>need to test it.
>> Can that be easily built using QueryBuilder?
>> I will try this week (end) and get back on this.
>Are you using Postgres? If so, once it works, please try running an
>EXPLAIN and send me the output. We can see what PG thinks.
>What would be awesome is if you ran an EXPLAIN, saved the results, then
>run an ANALYZE on the two objects: [pimitemflagrelation] and
>[pimitemtable]. Then re-do the EXPLAIN.
Yes, running a standalone server. Found that performs better compared to running it started by akonadi.
Also means I only run 1 instance. (Use that for development work as well)
I will do the explains later today or tomorrow. Don't have my laptop with me atm.
Sent from my Android device with K-9 Mail. Please excuse my brevity.
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users
More information about the kdepim-users