MySQL & Apache Optimization help needed

[WPCrazy]

I just purchased a VPS with DA. My VPS provider installed DA here. And now I need to optimize MySQL and Apache.
I bought a XEN box with 512MB guaranteed memory and 512 swap.

I run "cp -f /usr/share/mysql/my-medium.cnf /etc/my.cnf" and just add two lines. "skip-innodb" and "skip-bdb".

I'll run 2 WordPress based 2048bit ssl secured website there. So what more should I do?

And using this command "nano /etc/httpd/conf/httpd.conf" I couldn't find keepalive value, max connection etc. Please help me.

**I am pretty newbie, please don't mind if there is any wrong.

 

[zEitEr]

See:

cd /etc/httpd/conf/extra

httpd-alias.conf
httpd-autoindex.conf
httpd-dav.conf
httpd-default.conf
httpd-deflate.conf
httpd-includes.conf
httpd-info.conf
httpd-languages.conf
httpd-manual.conf
httpd-mpm.conf
httpd-mpm.conf_2.0
httpd-multilang-errordoc.conf
httpd-phpaddmodules.conf
httpd-php-handlers.conf
httpd-phpmodules.conf
httpd-ssl.conf
httpd-suphp.conf
httpd-userdir.conf
httpd-vhosts.conf

 

[WPCrazy]

Thanks

Thanks, I got keepalive values in httpd-default.conf.

 

[syslint]

You may need to optimize the MPM settings in apache. Please check what MPM you have. You can compile apache and php with suitable options using the custombuild script too.

 

[WPCrazy]

Sorry

You may need to optimize the MPM settings in apache. Please check what MPM you have. You can compile apache and php with suitable options using the custombuild script too.

sorry, I already installed DA. So how can I use custombuild script?

I'm not sure if I'm wrong or right!

 

[WPCrazy]

MPM Values

StartServers       3
MinSpareServers    3
MaxSpareServers   10
ServerLimit      50
MaxClients       50
MaxRequestsPerChild  2000