Gallery Resource Usage

accphotography

Joined: 2008-05-14
Posts: 66
Posted: Sun, 2014-05-25 19:30

Does anyone have any idea why Gallery's resource usage would have this weird graph (24 hour graph) where it steadily climbs up up up and then crashes way down all at once? Ideally I'm supposed to keep the usage below that red line and clearly sometimes that's possible, but I can't figure out what is causing these odd spikes and dips. (Graph attached)

FWIW It does this even on days with minimal activity to the site and me doing nothing as far as adding photos or the like. Just days where it's just sitting there.

Thanks!

Gallery URL = http://www.accphotography.com/gallery/main.php
Gallery version = 2.3.1 core 1.3.0.1
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.3.28 cgi-fcgi
Webserver = Apache
Database = mysqli 5.5.36-log, lock.system=flock
Toolkits = ImageMagick
Acceleration = partial/21600, partial/21600
Operating system = Linux ecbiz151.inmotionhosting.com 2.6.32-431.5.1.el6.bl1.1.5_1.x86_64 #1 SMP Thu Mar 20 13:18:49 MDT 2014 x86_64
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows NT 6.1; WOW64; rv:30.0) Gecko/20100101 Firefox/30.0
Rows in GalleryAccessMap table = 74
Rows in GalleryAccessSubscriberMap table = 28175
Rows in GalleryUser table = 79
Rows in GalleryItem table = 28172
Rows in GalleryAlbumItem table = 692
Rows in GalleryCacheMap table = 19883

AttachmentSize
minos_graph.php_.png44.55 KB
 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Mon, 2014-05-26 17:40

How can you be certain it is G2's usage & G2 only the graph is tracking?
--
dakanji.com
 
accphotography

Joined: 2008-05-14
Posts: 66
Posted: Mon, 2014-05-26 18:21

Because it counts php/sql processes (I think) and gallery is my only database. Plus I only have about a 6 page very minimal site besides the gallery. Also I never went over resources until I installed the gallery and then suddenly went from about 30% to 800%.
 
accphotography

Joined: 2008-05-14
Posts: 66
Posted: Mon, 2014-05-26 18:56

Another day.
 
accphotography

Joined: 2008-05-14
Posts: 66
Posted: Tue, 2014-05-27 02:42

Event Log fwiw. Some of this seems very strange to me and I had never seen it prior to coming to this host (not blaming the host as I know it could be my install or whatever).

Quote:
Mon 26 May 2014 10:35:23 PM EDT Gallery Error Link 37.58.100.234 /home/accpho5/public_html/gallery/modules/favourites/module.inc
Mon 26 May 2014 10:21:39 PM EDT Gallery Error Link 37.58.100.185 /home/accpho5/public_html/gallery/modules/favourites/module.inc
Mon 26 May 2014 10:21:09 PM EDT Gallery Error Link 36.248.98.170 Parent 6460 path ss-juvy.jpg.html result: chosen nickname "jeffreydor"; success; bb-code not working;
Mon 26 May 2014 10:21:08 PM EDT Gallery Error Link 36.248.98.170 Parent 6460 path SS-Juvy.jpg.html Result: chosen nickname "Jeffreydor"; success; BB-code not working;
Mon 26 May 2014 10:04:46 PM EDT Gallery Error Link 37.58.100.144 /home/accpho5/public_html/gallery/modules/favourites/module.inc
Mon 26 May 2014 10:01:50 PM EDT Gallery Error Link 176.31.149.238 Parent 626 path CadillacWalk...
Mon 26 May 2014 09:52:02 PM EDT Gallery Error Link 115.236.59.194 Parent 6460 path SS-Juvy.jpg.html Result: chosen nickname "Jeffreydor"; success; BB-code not working;
Mon 26 May 2014 09:51:58 PM EDT Gallery Error Link 86.51.26.13 Parent 6460 path SS-Juvy.jpg.html Result: chosen nickname "Jeffreydor"; success; BB-code not working;
Mon 26 May 2014 09:36:26 PM EDT Gallery Error Link 27.159.23.8 Parent 6346 path sharp2
Mon 26 May 2014 09:32:05 PM EDT Gallery Error Link 37.58.100.92 /home/accpho5/public_html/gallery/modules/favourites/module.inc
Mon 26 May 2014 08:52:29 PM EDT Gallery Error Link 37.58.100.227 /home/accpho5/public_html/gallery/modules/favourites/module.inc
Mon 26 May 2014 08:50:18 PM EDT Gallery Error Link 59.57.216.123 Parent 6346 path brother4
Mon 26 May 2014 08:22:30 PM EDT Gallery Error Link 31.41.216.109 Parent 162 path Affirmed8.jpg.html
Mon 26 May 2014 08:22:30 PM EDT Gallery Error Link 31.41.216.109 Parent 162 path CallerID1.jpg.html
Mon 26 May 2014 08:22:30 PM EDT Gallery Error Link 31.41.216.109 Parent 162 path APIndy4.jpg.html
Mon 26 May 2014 08:22:29 PM EDT Gallery Error Link 31.41.216.109 Parent 162 path AlphabetSoup1.jpg.html
Mon 26 May 2014 08:22:28 PM EDT Gallery Error Link 31.41.216.109 Parent 162 path Charismatic11.jpg.html
Mon 26 May 2014 08:21:54 PM EDT Gallery Error Link 216.244.77.50 Parent 1948 path index.php

 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Tue, 2014-05-27 02:56
accphotography wrote:
Because it counts php/sql processes (I think) and gallery is my only database. Plus I only have about a 6 page very minimal site besides the gallery. Also I never went over resources until I installed the gallery and then suddenly went from about 30% to 800%.

Ok. I suppose the question is that of what exactly the percentages stand for.

My gut feel is that you are with a cheap host with highly leveraged servers.

I am afraid, but there is nothing we can do for you here.

Sorry.

--
dakanji.com
 
accphotography

Joined: 2008-05-14
Posts: 66
Posted: Tue, 2014-05-27 03:24

% of CPU Usage apparently. Sadly no actual processes numbers.

It's In Motion. :-) Of any host I would think that would be one you could help with.
 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Tue, 2014-05-27 05:01

Difficult. Only thing I can think of is that it could be a bot/crawler hitting the site at specific times and as your site is fairly large and on a limited shared hosting plan, this might be enough to send the percentages soaring.

You could look into a ban on all or most bots.
I will ban them all for a while first to see if it makes a difference. See http://www.robotstxt.org/faq/prevent.html.
Note though that rogue bots just ignore the robots.txt file but it will be a start.

Bear in mind that this is just a stab in the dark.

--
dakanji.com