Huge DB

mbuild
mbuild's picture

Joined: 2012-10-09
Posts: 4
Posted: Tue, 2012-10-09 06:40

Over the last month the database size increased from 421 MB to 3 GB. Gallery has become significantly slower.
I noticed that the table gal2_CacheMap has a size of 2.7 GB. Is it a normal situation? How can I clear this table?
Gallery: http://moscow-live.ru/g2/main.php

Gallery version (not just "2"): 2.3.2
PHP version (e.g. 5.1.6): 5.2.17 cgi-fcgi
PHPInfo Link (see FAQ): http://moscow-live.ru/phpinfo.php
Webserver (e.g. Apache 1.3.33): Apache
Database (e.g. MySql 5.0.32): mysqlt 5.1.53-log, lock.system=flock
Activated toolkits (e.g. NetPbm, GD): ImageMagick
Operating system (e.g. Linux): Linux
Browser (e.g. Firefox 2.0): Google Chrome 22.0.1229.79 m

AttachmentSize
db.gif17.66 KB
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Tue, 2012-10-09 11:19
 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Tue, 2012-10-09 15:35

For the CacheMap table, you most likely will need to use a tool like phpMyAdmin to truncate (empty) the table after clearing the cached data.

--
dakanji.com

 
mbuild
mbuild's picture

Joined: 2012-10-09
Posts: 4
Posted: Wed, 2012-10-10 04:42

Thank you, suprsidr and Dayo. Your advice helped