Piwigo.org

msakik · 2013-10-04 14:14:32

Hi, I was looking for a way to know the disk usage of photos and maybe the disk usage of cache files.

plg · 2013-10-04 15:14:23

Hi msakik,

The disk usage of photos would be easy to implement:

Code:

SELECT sum(filesize) from piwigo_images;

But the disk usage of cache files is not easy. If you're running on unix-like Piwigo could :

Code:

exec('du -sh _data')

but that would't work on Windows.

msakik · 2013-10-04 19:36:44

Something may not be right.
I have run the sql from phpmyadmin and it returns

sum(filesize) = 12164796, that means 12 MB

When I run "du -csmh upload" it returns 4.5G

Am I doing something wrong?

Gallery folder is empty.

msakik · 2013-10-08 02:27:17

Ok, filesize is in KB so it is 12 GB. But still not compatible with du. Investigating more ....

msakik · 2013-10-08 03:01:59

digging more I found 3 photos where filesize is wrong at database, all of them uploaded on the same day. The record shows 2232876 Kb but in fact it is 2806 Kb. I have tried to reproduce with no success.

plg · 2013-10-08 14:47:54

Video files? (I've seen filesize error with [extension by xbgmsharp] piwigo-videojs)

msakik · 2013-10-08 15:05:09

No, standard photos. I have attempted with standard and flash upload and using upload plugin I have already installed but no success to reproduce this. I wondering if this information (based on database query) of photo disk usage could not be shown on admin summary page.

Piwigo.org

Announcement

#1 2013-10-04 14:14:32

[resolved] Is there a way to know how much disk space the photos are consuming?

#2 2013-10-04 15:14:23

Re: [resolved] Is there a way to know how much disk space the photos are consuming?

Code:

Code:

#3 2013-10-04 19:36:44

Re: [resolved] Is there a way to know how much disk space the photos are consuming?

#4 2013-10-08 02:27:17

Re: [resolved] Is there a way to know how much disk space the photos are consuming?

#5 2013-10-08 03:01:59

Re: [resolved] Is there a way to know how much disk space the photos are consuming?

#6 2013-10-08 14:47:54

Re: [resolved] Is there a way to know how much disk space the photos are consuming?

#7 2013-10-08 15:05:09

Re: [resolved] Is there a way to know how much disk space the photos are consuming?

Board footer