Batch downsizing a gallery2 site

Citral

Joined: 2009-08-23
Posts: 1
Posted: Sun, 2009-08-23 16:21

Hi,

I'm having a 17 GB gallery that is running out of disk space on the webhost.

I am considering batch downsizing all images.

One way I consider to do this is by downloading all gallery jpg files to my local machine. There I run a batch imagemagick on all the files to downsize them. Then I reupload them in the same way I downloaded them, replacing the originals.

But I'm not sure if this can have negative implications. E.g. the file hashes will change, so maybe gallery2 would alarm about that? I suppose all thumbnails need regeneration?

Do you think this approach is feasible?

Thanks!


Gallery version = 2.2.3 core 1.2.0.5
PHP version = 5.1.6 apache2handler
Webserver = Apache/2.2.2 (Fedora)
Database = mysqlt 4.1.12-standard, lock.system=database
Toolkits = ArchiveUpload, Exif, ImageMagick
Acceleration = partial/21600, partial/21600
Operating system = Linux
Default theme = x_treme
gettext = enabled
Locale = nl_NL
Browser = Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9) Gecko/2008061015 Firefox/3.0
Rows in GalleryAccessMap table = 16
Rows in GalleryAccessSubscriberMap table = 5185
Rows in GalleryUser table = 22
Rows in GalleryItem table = 5182
Rows in GalleryAlbumItem table = 149
Rows in GalleryCacheMap table = 93
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16503
Posted: Tue, 2009-08-25 19:39

Check this out:
http://codex.gallery2.org/Gallery2:Modules:sizelimit

If you have plenty of resources on the system, you should be able to resize through Gallery. Otherwise if resizing/replacing the originals on the backend, you'll still need to rebuild the thumbs and resizes. Well probably not. I don't know I haven't done that before. In testing/playing, I've only replaced a full size, original, with a different image of the same size (IIRC)

I'd also upgrade your Gallery. 2.3 is the most recent (and probably last) version of G2, it's fixed security issues since 2.2.3 was released.

One other observation, you might (will) get better performance if you switch your locking from database to file on a Linux based system.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here