Large Versioning and DB Space problem

grabit
Topic Author
Offline
Platinum Member

3 years 4 months ago - 3 years 4 months ago #79622 by grabit

Large Versioning and DB Space problem was created by grabit

Hi,

I have a problem with my DB: versioning was set to 10 versions and now the flexicontent_items_versions table is huge (more that 300mb).

Even if I remove the versioning, the table is still there and doesn't shrink.

How can I reduce the size of that table as my hosting company ask me to come to a lower size?

An Apple a days keeps the doctor away

Last edit: 3 years 4 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

3 years 4 months ago - 3 years 4 months ago #79623 by ggppdk

Replied by ggppdk on topic Large Versioning and DB Space problem

Hello

the simplest solution would be to empty ALL version data,
Truncating 2 tables (if truncate both then there will not be any problems):

Code:

TRUNCATE flexicontent_items_versions;
TRUNCATE flexicontent_versions;

To keep newest versions and delete old , you would probably need a procedural query that i do not know out of my head

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Last edit: 3 years 4 months ago by ggppdk.

Please Log in or Create an account to join the conversation.