Clean your Gallery 2 ImageBlockCacheMap table regularly

Supposedly, Gallery 2 has a process to clean this table periodically (through Cron, which you should always configure), but apparently sometimes this doesn’t get to execute correctly.

As a result, the rest of the cleanup will happen but this stable might not get cleaned, leading you to millions of rows of purely useless years-old cache junk.

Fix it manually by issuing a “TRUNCATE [prefix]_ImageBlockCacheMap;” in your database, or install a more recent version of Gallery, or something like that, but make sure you always keep an eye on its size.

Reference: http://galleryproject.org/node/30045


Related Posts

Gallery 2.3 not translating

Just in case you would fall upon this issue as well, Gallery2 requires...

Fixes for Gallery 2 French translation in module ‘core’

After years using G2, I finally fixed the fr.po for core module and...

Quick Contact Form