Emptying g2_CacheMap and g2_SessionMap

dnicu26

Joined: 2007-12-18
Posts: 10

Posted: Tue, 2011-07-12 22:46

The cachemap has reached 250MB and 52k pages in phpMyAdmin in size over the past 3 years. The gallery2 directory is 1.4GB in size but I'm not sure how many photos. I don't know if this is continually increasing or what the problem is but there are tens of g_key for every g_Itemid. Isn't there meant to be 1:1? Why has this happened?

So I will be transferring the database to a different host and I need to cut this to <50MB. If I Delete Database Cache from Gallery -> Maintenance, what will the result of this be on the server usage? Will it increase dramatically for the first few days until everything gets cached again or will it take a lot longer? I think even so it uses a lot of CPU% since this and a wordpress site are the only thing on the server so it's definitely not optimized but I have no idea what else I can do other than this cache thing. I have full acceleration for guests and registered users with 1 day expiration already.

Help would be appreciated, thanks in advance!

Gallery version = 2.2.3 core 1.2.0.5
PHP version = 5.2.9 cgi
Webserver = Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Database = mysqlt 5.0.92-community, lock.system=flock
Toolkits = ArchiveUpload, Exif, Getid3, ImageMagick, LinkItemToolkit, SquareThumb, Thumbnail, Gd
Acceleration = full/86400, full/86400
Operating system = Linux hmz.hannahmontanazone.com 2.6.9-89.0.23.EL #1 Wed Mar 17 06:22:05 EDT 2010 i686
Default theme = wordpressembedded
gettext = enabled
Locale = en_GB
Browser = Mozilla/5.0 (Windows NT 6.0) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.112 Safari/534.30
Rows in GalleryAccessMap table = 718
Rows in GalleryAccessSubscriberMap table = 4076
Rows in GalleryUser table = 316
Rows in GalleryItem table = 4074
Rows in GalleryAlbumItem table = 235
Rows in GalleryCacheMap table = 1544224

suprsidr

Joined: 2005-04-17
Posts: 7892

Posted: Wed, 2011-07-13 00:39

go ahead and truncate those np

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

dnicu26

Joined: 2007-12-18
Posts: 10

Posted: Wed, 2011-07-13 00:47

Thanks for your reply! Do I do that by Maintenance --> Delete Database Cache then Optimize Database?

suprsidr

Joined: 2005-04-17
Posts: 7892

Posted: Wed, 2011-07-13 01:12

you can empty them in phpmyadmin
also ImageblockCacheMap

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

dnicu26

Joined: 2007-12-18
Posts: 10

Posted: Wed, 2011-07-13 13:00

Thank you! - ok, I've truncated those tables.

Another question - in my account /gallery2/g2data7h5f8439534/cache/entity there are still a lot of files in folders numbered 0 to 9. What is the point in these files? Won't extra ones be created after the cacheing has finished?

Dayo

Joined: 2005-11-04
Posts: 1555

Posted: Wed, 2011-07-13 13:48

You can safely delete everything in g2data/cache. However, it is best not to delete g2data/cache/derivative and items under this for performance reasons.

See: http://codex.gallery2.org/Gallery2:FAQ#How_can_I_clear_cached_data.3F

--
dakanji.com

suprsidr

Joined: 2005-04-17
Posts: 7892

Posted: Wed, 2011-07-13 22:01

you can delete anything in g2data/cache/ except derivative, unless you want to rebuild all your derivatives(thumbs and resizes)

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

dnicu26 Joined: 2007-12-18 Posts: 10	Posted: Tue, 2011-07-12 22:46
	The cachemap has reached 250MB and 52k pages in phpMyAdmin in size over the past 3 years. The gallery2 directory is 1.4GB in size but I'm not sure how many photos. I don't know if this is continually increasing or what the problem is but there are tens of g_key for every g_Itemid. Isn't there meant to be 1:1? Why has this happened? So I will be transferring the database to a different host and I need to cut this to <50MB. If I Delete Database Cache from Gallery -> Maintenance, what will the result of this be on the server usage? Will it increase dramatically for the first few days until everything gets cached again or will it take a lot longer? I think even so it uses a lot of CPU% since this and a wordpress site are the only thing on the server so it's definitely not optimized but I have no idea what else I can do other than this cache thing. I have full acceleration for guests and registered users with 1 day expiration already. Help would be appreciated, thanks in advance! Gallery version = 2.2.3 core 1.2.0.5 PHP version = 5.2.9 cgi Webserver = Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Database = mysqlt 5.0.92-community, lock.system=flock Toolkits = ArchiveUpload, Exif, Getid3, ImageMagick, LinkItemToolkit, SquareThumb, Thumbnail, Gd Acceleration = full/86400, full/86400 Operating system = Linux hmz.hannahmontanazone.com 2.6.9-89.0.23.EL #1 Wed Mar 17 06:22:05 EDT 2010 i686 Default theme = wordpressembedded gettext = enabled Locale = en_GB Browser = Mozilla/5.0 (Windows NT 6.0) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.112 Safari/534.30 Rows in GalleryAccessMap table = 718 Rows in GalleryAccessSubscriberMap table = 4076 Rows in GalleryUser table = 316 Rows in GalleryItem table = 4074 Rows in GalleryAlbumItem table = 235 Rows in GalleryCacheMap table = 1544224
	XUser login Username: * Password: * Create new account Request new password
suprsidr Joined: 2005-04-17 Posts: 7892	Posted: Wed, 2011-07-13 00:39
	go ahead and truncate those np -s FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

dnicu26 Joined: 2007-12-18 Posts: 10	Posted: Wed, 2011-07-13 00:47
	Thanks for your reply! Do I do that by Maintenance --> Delete Database Cache then Optimize Database?

suprsidr Joined: 2005-04-17 Posts: 7892	Posted: Wed, 2011-07-13 01:12
	you can empty them in phpmyadmin also ImageblockCacheMap -s FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

dnicu26 Joined: 2007-12-18 Posts: 10	Posted: Wed, 2011-07-13 13:00
	Thank you! - ok, I've truncated those tables. Another question - in my account /gallery2/g2data7h5f8439534/cache/entity there are still a lot of files in folders numbered 0 to 9. What is the point in these files? Won't extra ones be created after the cacheing has finished?

Dayo Joined: 2005-11-04 Posts: 1555	Posted: Wed, 2011-07-13 13:48
	You can safely delete everything in g2data/cache. However, it is best not to delete g2data/cache/derivative and items under this for performance reasons. See: http://codex.gallery2.org/Gallery2:FAQ#How_can_I_clear_cached_data.3F -- dakanji.com

suprsidr Joined: 2005-04-17 Posts: 7892	Posted: Wed, 2011-07-13 22:01
	you can delete anything in g2data/cache/ except derivative, unless you want to rebuild all your derivatives(thumbs and resizes) -s FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

Emptying g2_CacheMap and g2_SessionMap

XUser login