Can gallery scale? What are the limitation
|
kailio
Joined: 2005-03-10
Posts: 13 |
Posted: Fri, 2008-05-09 23:55
|
|
I have gallery 2.2x running on a dedicated box with 1.5 gb of ram. I have around 32,000 images and around 250 albums. Over the past few months the gallery performance has been degrading and at time slows my server to a halt. I have run all the maintenance tools, optimize the db, but to no help. Can someone who have about the same configuration speak to what performance they are getting. I get pretty decent traffic to the site. |
|
Posts: 32509
32k items and 250 albums isn't that much. it's more than the average, but certainly at the lower end of large installations.
you didn't mention the traffic of your site (page views / day, number of concurrent requests), the number of registered users, the number of user-albums (using the user-album module).
there are several installations with over 100k items, some with over 1 million items. you need a fast server, but it sure works. there are also some installations with high traffic.
gallery 2 does scale to a large number of items, users and requests, but you need to properly configure the whole server stack and fast hardware is also required.
please start with reading: documentation -> admin & maintenance -> performance tips.
then you might want to search the forums for similar discussions which have contributed to the topic.
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 13
our traffic fluctuates but currently it average around 50K-60k pageviews daily. we only have a handful of users that can add albums...around 30-40. i have them in a group that have rights to add albums. are you saying i now need a faster dedicated server just for this many photos and albums. i am running gallery on a sempron 3400 with 1.5 gb of memory.
Posts: 32509
1.5GB is just not a lot of memory for a webserver.
you should definitely have an php opcode cache.
as for more tips, please read the performance tips on our documentation website.
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 13
so what are you running? can you provide specs? traffic, albums, server specs, etc.
Posts: 32509
this website here? that's a different story. it's a drupal + gallery + wiki + code review + mail + database server. 4 GB RAM, php opcode cache, some xeon dual-core or so.
but this site here also has a lot of concurrent visitors. the forums are by far the most used part of the site.
a good basis is 4GB of RAM + some high frequency multi-threaded or multi-process CPU + php opcode cache.
tweak mysql settings (query cache, etc).
if you need to scale further, put the DB server on a separate box.
then balance your webservers, then you could even do some database replication, etc.
for a site of your size, a machine with 1.5-2 GB RAM, opcode cache, with some 2-3GHz x86 processor (or equivalent) and with a local disk (or fast network disk) should lead to quick response times.
if that's not the case, you'll have to find out where the time is lost.
i can't go into more detail. please search the forums and read existing documentation.
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage