Announcement

#1 2018-03-16 08:15:38

Ralf
Member
Dorsten-Lembeck
2012-05-08
154

Automatism keeping history small

I,

I have read that Piwigo 2.9 should have an automatism to keep the history small.


Are there any further informations about this?
I can not find any settings in the backend.

The 'Prune History' plugin does not work out of the box anymore, because it looks for a column 'summarize' in the history table which no longer exists.

cheers
Ralf


There are only two kinds of music:
Rock and Roll

Offline

 

#2 2018-03-16 17:42:34

flop25
Piwigo Team
2006-07-06
6839

Re: Automatism keeping history small

Hello
check the Local Config and those variables [Github] Piwigo file include/config_default.inc.php@L573 ;)


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#3 2018-03-17 06:27:49

Ralf
Member
Dorsten-Lembeck
2012-05-08
154

Re: Automatism keeping history small

Hi,

thanks a lot - found it.

One last question - default for "keeping lines in history" is 1 Million lines :
$conf['history_autopurge_keep_lines'] = 1000000;

Do you have an idea how big the database will be with this value?
With 300 visits a day, the default means that the history will be kept for nearly 10 years.

A very last question:
It is only the history that will be purged not the summary - correct?

Cheers
Ralf


There are only two kinds of music:
Rock and Roll

Offline

 

#4 2018-03-17 06:39:00

executive
Member
2017-08-16
348

Re: Automatism keeping history small

Ralf wrote:

$conf['history_autopurge_keep_lines'] = 1000000;

Do you have an idea how big the database will be with this value?

I don't know exactly how long the lines are, but if we assume it's 50 characters (50 bytes) on average, then that would be 50MB.

Last edited by executive (2018-03-17 06:39:55)

Offline

 

#5 2018-03-17 10:41:40

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13174

Re: Automatism keeping history small

The idea behind auto-purge is to keep the database as small as relevant. A small database means a faster dump/reload = more often backups = peace of mind :-)

The system is smart, the summary is not purged and Piwigo does not purge history lines that were not summarized ;-)


Latest blog post (May 3rd 2018) New subscription form

Offline

 

#6 2018-03-17 10:55:23

Ralf
Member
Dorsten-Lembeck
2012-05-08
154

Re: Automatism keeping history small

Thanks for clearification :-)


There are only two kinds of music:
Rock and Roll

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2018 · Contact