Announcement

#1 2016-11-12 15:26:13

homdax
Member
Sweden
2015-02-02
74

huge database - could something be wrong

Hi again,

I am moving some site around and one is a Piwigo based gallery with some images, specs below:

Piwigo version
Piwigo 2.8.2
Operating system: Linux
PHP: 5.6.19 (Show info) [2016-11-12 14:19:34]
MySQL: 5.5.52-cll [2016-11-12 15:19:34]
Graphics Library: GD bundled (2.1.0 compatible)
Database
2271 photos (first photo added on Monday 2 February 2015)
60 albums included 0 physical and 60 virtual (2271 associations)
0 tags (0 associations)
4 users

The DB is 373 MB, is this even close to normal? I have optimized it.
Where could I look for any suspicious entries?

Offline

 

#2 2016-11-12 15:31:31

homdax
Member
Sweden
2015-02-02
74

Re: huge database - could something be wrong

Holy...

The history... of course.. I should have seen that coming. It is 270 MB

But the total amount of DB size reported by phpmyadmin is 275MB, how does that become 373 when downloaded as a SQL file?

Offline

 

#3 2016-11-12 16:55:24

flop25
Piwigo Team
2006-07-06
6871

Re: huge database - could something be wrong

Hello
Yep the history table ...
Data are not stored as SDL commands, they are stored in an optimized way and sql are commands so it has more data with text like "Create that table with such config etc"


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

 

#4 2016-11-12 17:08:11

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

Re: huge database - could something be wrong

In Piwigo 2.9, a new "automatic purge" mecanism will keep the history table "small".


Latest blog post (November 9th 2018) Why Flickr could not remain free for ever

Offline

 

#5 2016-11-13 08:36:00

homdax
Member
Sweden
2015-02-02
74

Re: huge database - could something be wrong

A simple truncate will empty the table in a correct way?

Think I will replace it with GoogleAnalytics or some like that...

Last edited by homdax (2016-11-13 08:36:49)

Offline

 

#6 2016-11-13 14:33:58

flop25
Piwigo Team
2006-07-06
6871

Re: huge database - could something be wrong

my personal recommendation would be to use Piwik


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

 

#7 2016-11-13 15:52:17

homdax
Member
Sweden
2015-02-02
74

Re: huge database - could something be wrong

Seems French to so why not... :)

Can i just get a small verification that truncating the history table is the way to go to empty it? I have disabled Histroy, but I need to get rid of the old data or will have issues importing it to the new server, using BigDump or some like that.

Offline

 

#8 2016-11-13 15:55:20

flop25
Piwigo Team
2006-07-06
6871

Re: huge database - could something be wrong

yes that's it Truncate empty the table without deleting the table itself


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

 

#9 2018-03-10 06:56:03

Ralf
Member
Dorsten-Lembeck
2012-05-08
154

Re: huge database - could something be wrong

Hi Flop,
"In Piwigo 2.9, a new "automatic purge" mecanism will keep the history table "small".

Are there any settings for the automatic purge?

Cheers
Ralf


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