Well, I know that Gallery 2 has some issues with being slower than G1. But my current site is bordering on unusable for my guests, and almost impossible to manage. My gallery has about 60k images (all 320x240 or 240x320) My other sites/domains get slow some times but nothing like http://www.wm5.mobi/gallery/ I know it is mySQL related. talking with Dreamhost support I received the following message
"The problem is, I do see quite a lot of those queries running though.
Looking at your mysql usage the last few days, you had close to 500,000
queries 2 days ago… yesterday you had over 600,000 mysql queries running
Looking at your mysql usage, I do not believe a mysql PS is needed. I
would think a regular PS (webserver) will probably help you more.
Looking at the webserver usage for one of your users (me):
me 61435 6.06% 208420.85re 0.12%
81.83cp 3.16% 0avio 14143013ksec
me 51265 5.24% 228001.17re 0.13%
107.86cp 4.39% 0avio 29573883ksec
You are averaging about 4% of the entire server resources.
Quite a few of your processes are also getting killed as well by our
procwatch system. Your user (me) seems to be going over the PHP
memory limit quite a bit. If you had a PS server, we don’t have
Many of my albums contain thousands of images. I know the wait for PS servers have a waiting list but I’m wondering if I should just switch hosts to a dedicated or VPS server. I need this site to be usable and manageable… Any advice would be appreciated.