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
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
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"
Offline
In Piwigo 2.9, a new "automatic purge" mecanism will keep the history table "small".
Offline
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
my personal recommendation would be to use Piwik
Offline
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
yes that's it Truncate empty the table without deleting the table itself
Offline
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
Offline