Server resources - hosting problems - MySQL

[DrByte]

I will reiterate what's been given for feedback:
1. The /cache/ssu/ folder is used by an addon, as described. Perhaps it is malfunctioning either by not doing any garbage collection or not re-using components it has cached. Either way, the first thing I'd suggest is disabling that addon. Of course that will cause the store's URLs to change, which may have SEO impact, so should be a temporary measure to simply aid in diagnosing ie: narrowing the pain symptoms to just that addon's effects.
Periodically purging that ssu cache might be smart, but you might want to read up on what the implications of that may be. I'm not familiar with that addon's detailed inner workings.

2. Query Cache will reduce the number of "repeat" queries, simply by adding an internal cache of results of repeat query calls. If the MySQL server isn't already caching intelligently then this application-layer caching will help improve speed somewhat.

3. I will add that these FAQ articles, and the links therein, are valuable reads:
http://www.zen-cart.com/content.php?...eed-up-my-site
http://www.zen-cart.com/content.php?...er-tuning-tips

[kevmartin]

Thanks for your suggestions everyone. My client is going to contact the developer of the SSU plugin with whom he has had previous contact, and see if there is an issue with it or if it can be optimised/updated. Failing this, the articles in the previous reply give some very worthwhile specific suggestions for configuration and selective feature disabling that could be useful. And the Query Cache sounds hopeful too.

We will see where it all leads us.

Thanks.