What kind of server configuration would you suggest? we are running a 2 server setup, one web, and one database. Each machine is multi core, and 8 gigs of ram.
Trackpads does have a lot of photos, but their activity rate is much lower. We have 33 views per photo, they have 1.7 views per.
I have identified a few queries that are doing more then they probably need to do, can you please let me know what pages I might find these queries under? I watched the show full processlist in mysql for about 10 mins and have pulled in a few queries that seem to be taking a long time to run.
This one is pulling back all basically all photos in the gallery
Code:
Content visible to verified customers only.
again, pulling back all photos in the gallery
Code:
Content visible to verified customers only.
even with the limit directive applied on the above 2 queries, the database is still forced to work through all records before it can apply the limit.
Code:
Content visible to verified customers only.
I know that more recent versions of mysql support more advanced sql like subqueries... perhaps there could be some option to define the version of mysql that is being run and utilize some of the more advanced options in some of the queries.
thanks