Hello Mario,
it's great news :-)
Janos
On 2018-10-10 20:42, Mario Pastoor wrote:
thank you for your're quick reply. I've checked the index last weekend
and watched the behavior of the machine for the last days and I'm lad
to
say that CPU load is back to a normal level. (see the attached images)
:-)
Problem was that our previous version was 1.2.0-pre1 and not the final.
To be precise it was this id :
https://bitbucket.org/jsuto/piler/src/20ed9b9e6d87?at=fixed_id
And the index in that version for the attachments table looked like :
create index `attachment_idx` on `attachment`(`piler_id`);
create index `attachment_idx2` on `attachment`(`sig`);
create index `attachment_idx3` on `attachment`(`ptr`);
Here is what I've done to fix it (if anyone else needs this) :
DROP INDEX `attachment_idx` on `attachment`;
DROP INDEX `attachment_idx2` on `attachment`;
DROP INDEX `attachment_idx3` on `attachment`;
create index `attachment_idx` on `attachment`(`piler_id`);
create index `attachment_idx2` on `attachment`(`sig`, `size`, `ptr`);
create index `attachment_idx3` on `attachment`(`ptr`);
OPTIMIZE TABLE attachment;
I'm not sure if the "OPTIMIZE TABLE attachment;" is really needed but
as
it won't do any harm I ran it in addition.
So, this one is solved.
I've some minor other problems regarding to the webui but that's not
that important right now. As soon as I have some time I'll report here
to the list.
