each page takes a minute to load

bwschultz

Joined: 2007-04-19
Posts: 17

Posted: Tue, 2009-05-05 16:59

Hello,

I'm trying to get to the bottom of why my gallery is running incredibly slow since about one week ago. I assume something is gunked up in the php on the web server but I don't know how to verify. I've looked through the performance tips but didn't find anything that worked. It's a big gallery and with a lot of modules active and has worked well in the past. The only error I've seen so far was when I tried to "optimize database" in the site admin section and that failed after thinking for about 3 or 4 minutes.

Thank you to anyone who can get me pointed in the right direction.

brent

Last Run Details:

Gallery URL = http://brentschultz.com/gallery2/main.php
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.6 cgi-fcgi
Webserver = Apache/1.3.37 (Unix) mod_throttle/3.1.2 FrontPage/5.0.2.2635 mod_ssl/2.8.28 OpenSSL/0.9.8b
Database = mysqlt 4.1.20-max-log, lock.system=flock
Toolkits = Exif, Getid3, Thumbnail, ArchiveUpload, Gd, LinkItemToolkit, Ffmpeg, ImageMagick
Acceleration = partial/900, none/900
Operating system = Linux web258.opentransfer.com 2.6.18-92.1.10.el5PAE #1 SMP Tue Aug 5 08:14:05 EDT 2008 i686
Default theme = x_treme
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10
Rows in GalleryAccessMap table = 132
Rows in GalleryAccessSubscriberMap table = 11634
Rows in GalleryUser table = 10
Rows in GalleryItem table = 11630
Rows in GalleryAlbumItem table = 302
Rows in GalleryCacheMap table = 19618

oriolhernan

Joined: 2008-01-08
Posts: 41

Posted: Tue, 2009-05-05 17:45

I have tested now and yes, loads really slow.

I don't know why the performance is so low because the gallery isn't really big (look at http://www.sharewallpapers.org), but you can try some things.

Switch your template to the matrix and try the performance.
Deactivate the album select module and try again.
Don't use the google module because it slows down the server and also kills you in SEO terms.
Deactivate the random module

If the performance is the same with these trips, reinstall gallery2

bwschultz

Joined: 2007-04-19
Posts: 17

Posted: Tue, 2009-05-05 18:19

No change is speediness making those changes. Hmm... Should I just proceed to gallery2/install and step through that again? Will that do a "reinstall" and preserve the mysql database?

bwschultz

Joined: 2007-04-19
Posts: 17

Posted: Wed, 2009-05-06 14:03

Problem seemed to be on the webserver side. My provider said they didn't do anything but it's fixed now.

nivekiam

Joined: 2002-12-10
Posts: 16503

Posted: Wed, 2009-05-06 18:18

Yes, most speed issues with Gallery are at the web server side. Slow database, slow server, over sold (overloaded) server, slow or overloaded network, etc. There are a few things you can do that will slow Gallery down, too many or excessive permission settings, EXIF and some other plugins.

These pages may help:
http://codex.gallery2.org/Gallery2:Performance_Tips
http://codex.gallery2.org/Gallery2:ACL_Performance
http://gallery.menalto.com/node/82413#comment-288705

And knowing about securing Gallery is always good:
http://codex.gallery2.org/Gallery2:Security
http://gallery.menalto.com/node/82990#comment-290770
http://codex.gallery2.org/Gallery2:How_do_I_secure_Gallery2

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

bwschultz Joined: 2007-04-19 Posts: 17	Posted: Tue, 2009-05-05 16:59
	Hello, I'm trying to get to the bottom of why my gallery is running incredibly slow since about one week ago. I assume something is gunked up in the php on the web server but I don't know how to verify. I've looked through the performance tips but didn't find anything that worked. It's a big gallery and with a lot of modules active and has worked well in the past. The only error I've seen so far was when I tried to "optimize database" in the site admin section and that failed after thinking for about 3 or 4 minutes. Thank you to anyone who can get me pointed in the right direction. brent Last Run Details: Gallery URL = http://brentschultz.com/gallery2/main.php Gallery version = 2.3 core 1.3.0 API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5 PHP version = 5.2.6 cgi-fcgi Webserver = Apache/1.3.37 (Unix) mod_throttle/3.1.2 FrontPage/5.0.2.2635 mod_ssl/2.8.28 OpenSSL/0.9.8b Database = mysqlt 4.1.20-max-log, lock.system=flock Toolkits = Exif, Getid3, Thumbnail, ArchiveUpload, Gd, LinkItemToolkit, Ffmpeg, ImageMagick Acceleration = partial/900, none/900 Operating system = Linux web258.opentransfer.com 2.6.18-92.1.10.el5PAE #1 SMP Tue Aug 5 08:14:05 EDT 2008 i686 Default theme = x_treme gettext = enabled Locale = en_US Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 Rows in GalleryAccessMap table = 132 Rows in GalleryAccessSubscriberMap table = 11634 Rows in GalleryUser table = 10 Rows in GalleryItem table = 11630 Rows in GalleryAlbumItem table = 302 Rows in GalleryCacheMap table = 19618
	XUser login Username: * Password: * Create new account Request new password
oriolhernan Joined: 2008-01-08 Posts: 41	Posted: Tue, 2009-05-05 17:45
	I have tested now and yes, loads really slow. I don't know why the performance is so low because the gallery isn't really big (look at http://www.sharewallpapers.org), but you can try some things. Switch your template to the matrix and try the performance. Deactivate the album select module and try again. Don't use the google module because it slows down the server and also kills you in SEO terms. Deactivate the random module If the performance is the same with these trips, reinstall gallery2

bwschultz Joined: 2007-04-19 Posts: 17	Posted: Tue, 2009-05-05 18:19
	No change is speediness making those changes. Hmm... Should I just proceed to gallery2/install and step through that again? Will that do a "reinstall" and preserve the mysql database?

bwschultz Joined: 2007-04-19 Posts: 17	Posted: Wed, 2009-05-06 14:03
	Problem seemed to be on the webserver side. My provider said they didn't do anything but it's fixed now.

nivekiam Joined: 2002-12-10 Posts: 16503	Posted: Wed, 2009-05-06 18:18
	Yes, most speed issues with Gallery are at the web server side. Slow database, slow server, over sold (overloaded) server, slow or overloaded network, etc. There are a few things you can do that will slow Gallery down, too many or excessive permission settings, EXIF and some other plugins. These pages may help: http://codex.gallery2.org/Gallery2:Performance_Tips http://codex.gallery2.org/Gallery2:ACL_Performance http://gallery.menalto.com/node/82413#comment-288705 And knowing about securing Gallery is always good: http://codex.gallery2.org/Gallery2:Security http://gallery.menalto.com/node/82990#comment-290770 http://codex.gallery2.org/Gallery2:How_do_I_secure_Gallery2 ____________________________________________ Like Gallery? Like the support? Donate now!!! See G2 live here

each page takes a minute to load

XUser login