Advice on optimising my VPS - MySQL mainly!

#1
Hello,

I remember reading several threads in the past where others have advised on how to otimise various configuration files to enable MySQL and PHP to run more effectively, but these were usually servers with 512mb of memory+

I think the files to adjust were the .cnf file and the other had something to do with Httpd?, but am not 100% sure.

Could somebody please advise on the best configuration for a VPS XLTX package with 320mb of memory?.

Thanks in advance.
 
#6
Some things to try to get you started:
- Log in to phpMyAdmin and look at your "MySQL runtime information" which might help you learn a little about your mysql settings
- log into your server via SSH and run the "top" command and look for mysql processes and see how much memory and CPU they're using
 
Top