27
Hi Javier,
You have a VPS, so you have the advantage of being able to tweak your server as much a you want to get the best performance. I suggest you look into the following;
Theme - Use CSS for positioning and reduce/consolidate images to reduce page weight and HTTP requests require to load the page.
Xoops Caching - In particular make sure your Xoop blocks are set to use caching as they are usually very expensive in terms of MySQL queries. Also look at module level caching as well.
PHP opcode cache - If your using PHP 4.x, then I suggest you have a look at eAccelerator to dramatically increase your PHP performance. If you are using PHP 5.x I would suggest using APC as I've read eAccelerator has a few issues with this branch.
Webserver - If your using IIS then you should configure your PHP application mapping to use FastCGI or ISAPI (FastCGI is better under heavy load). Looks like your running Apache so look at loading PHP into Apache as a module rather than CGI.
MySQL Query Caching & Buffer sizes - I see you have MySQL query caching already enabled, but be sure you've done your homework there. Due to the way query caching works it can actually really hurt performance if your site has a very heavy write load (such as forums, comments sections). Also look at tuning your buffers, for instance your key_buffer is set to 256MB which is 100% of your garanteed RAM.
Generally in a VPS you REALLY need to put the squeeze on the use of memory bound buffers and caches as it is usually a VERY limited resource. Once you have it tuned though your server should be able to handle just about anything. Have a read of the article I wrote about
performance tuning XOOPS on IIS where I was able to gain around 1000% perofmance increase in some areas over the default install. It is about Windows/IIS, but very similar principals will apply to Linux/Apache. I also found a brilliant slideshow overview on php.net a while back explaining how to configure PHP with Apache to get maximum performance. Would be whell worth your while hunting that down too.