Advice on optimising my VPS - MySQL mainly!

[diggity]

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.

 

[khiltd]

You can't optimize anything until you know where the bottlenecks are.

 

[laguna]

How to find them

And what is the best way to find out why mysql, etc is slow?

 

[khiltd]

And what is the best way to find out why mysql, etc is slow?

An extensive amount of logging, benchmarking, testing and manual reading.

 

[diggity]

And what is the best way to find out why mysql, etc is slow?

Out of interest, are you finding / having any issues too?

 

[mixart]

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