|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 184.108.40.206