Problem with huge db tables - Newscoop Support Discussions on Sourcefabric Forum

Sebastian Göbel

Hi,

on the higher-traffice site netgazeti.ge I found the Requests and Sessions tables with millions of rows, which at least causes problem on dumping/restore this database. Is it necessary to keep them for all the time? Should't there be some automatic cleanup?

Best regards,
Sebastian

Andrey Podshivalov

for sure that tables can be cleaned periodically or each time before backup process

Sebastian Göbel

Hi Andrey,

good to know, but shouldn't this cleanup be implemented to run automatically?

Best regards,
Sebastian

-----Original Message-----
From: Andrey Podshivalov [mailto:campsite-support@lists.sourcefabric.org]
Sent: Thursday, June 24, 2010 4:36 PM
To: sebastian.goebel@sourcefabric.org
Subject: [campsite-support] Re: Problem with huge db tables

for sure that tables can be cleaned periodically or each time before backup process

Holman Romero

Hey Seb,

It has given some problems to other people like elperiodico, so yes...
we have to take care of that, please can you create a ticket on dev?
Thanks.

Cheers,

2010/6/28 Sebastian Göbel <campsite-support@lists.sourcefabric.org>
>
> Hi Andrey,
>
> good to know, but shouldn't this cleanup be implemented to run automatically?
>
> Best regards,
> Sebastian
>
>
> -----Original Message-----
> From: Andrey Podshivalov [mailto:campsite-support@lists.sourcefabric.org]
> Sent: Thursday, June 24, 2010 4:36 PM
> To: sebastian.goebel@sourcefabric.org
> Subject: [campsite-support] Re: Problem with huge db tables
>
>
> for sure that tables can be cleaned periodically or each time before backup process
>
>

--
Holman Romero
Senior Software Engineer, Sourcefabric
holman.romero@sourcefabric.org

Salvátorská 10
110 00 Praha 1, Czech Republic
+420 607 133 896

http://www.sourcefabric.org

Howdy, Stranger!

Categories

Poll

Top Posters