Hi Brash,
nice to see you, some time ago (when my site was in a shared server) we talk per pm about something like this, surely you not remember that.
In fact my XOOPS site are optimized follow your guides.
The things i not touched was php and MySQL except for the things i tell in this topic.
I will check your guides again and follow your suggestions,
and try to make my best shot (im totally new in this servers things, all my life my sites was in shared servers, is something really hard for me but i will try :) )
Thanks alot for take time to reply to this topic,i really apreciatte that,
I have this problem since months ago and never find a solution
Quote:
brash wrote:
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.
That´s done
Quote:
brash wrote:
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.
My site work around the discussion board, because its a Free technical support site.
The use of the forum is very intensive.
--
Then i must find a way to deactivate the MySQL query caching.
(i say find a way, because i have to make a google search for learn about that, yes i know what your think in this moment, im a newbie yes :) )
Should i use 128mn for key_buffer maybe? i just made a search in google and i found with low key_buffer values the load is low, because it wait a little or something like that.
I read the 50% of the system is recomended, in this vps should be 128mb.
Quote:
brash wrote:
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.
I think is done:
Loaded Modules: mod_security, mod_auth_passthrough, mod_log_bytes, mod_bwlimited,
mod_php4, mod_frontpage, mod_ssl, mod_setenvif, mod_so, mod_expires, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_status, mod_negotiation, mod_mime, mod_log_config, mod_env, http_core
[/quote]
Quote:
brash wrote:
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.
The zend come installed with the vps, is the same?
Zend Optimizer
Optimization Pass 1 enabled
Optimization Pass 2 enabled
Optimization Pass 3 enabled
Optimization Pass 4 enabled
Optimization Pass 9 disabled
Zend Loader enabled
License Path no value
Best regards
Javier