Advice on optimising my VPS - MySQL mainly!

Discussion in 'Linux VPS/Dedicated - cPanel' started by diggity, Mar 14, 2008.

  1. diggity

    diggity New Member

    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.
     
  2. khiltd

    khiltd New Member

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

    laguna New Member

    How to find them

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

    khiltd New Member

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

    diggity New Member

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

    mixart New Member

    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
     

Share This Page