Optimum Configuration of Apache, PHP, MySQL for my box

Discussion in 'Site & Server Administration' started by Monxx, Jul 25, 2008.

  1. #1
    I have a dedicated server with following config;

    PENTIUM-D DUAL-CORE 3.4GHZ
    Memory: 2GBMB DDR RAM
    Hard Drive: 36GB SCSI
    with Cpanel/WHM

    I want to host two forums (phpBB3) which individually has ard. 30 users online at a given instant of time (5 min overview) and at peak time 100 users.
    Plus i will be hosting 3 blogs with not more than 10-15 users online at a time.

    So how should i configure my httpd.conf, my.cnf, php.ini

    What else optimizations can i make avoid server overloading and load my websites faster.

    PS: ONE more thing, With Cpanel/WHM does php/mysql/apache comes bundled and compiled together ? Also I would need GD library for some websites. How can i ADD that in php ?
     
    Monxx, Jul 25, 2008 IP
  2. gate2vn

    gate2vn Peon

    Messages:
    809
    Likes Received:
    33
    Best Answers:
    1
    Trophy Points:
    0
    #2
    Optimizing depends on how you are using currently, how large the queries are, how large of cache you will need. It requires to check your system real times. Please do not take configuration of someone else to apply to your box. It might be worse.

    You can recompile PHP with GD option in WHM.

    Let me know if you want me to do it for you.
    tks,
     
    gate2vn, Jul 25, 2008 IP
  3. zacharooni

    zacharooni Well-Known Member

    Messages:
    346
    Likes Received:
    20
    Best Answers:
    4
    Trophy Points:
    120
    #3
    You will need to analyze your current traffic patterns, and determine the load at peak hours, and compare to the result during half-peak. Then, setup MySQL slow-query logs to determine which queries are taxing the server the most. From there, do a memory and cache analysis to determine how much usage the MySQLd is using. You can then edit your /etc/my.cnf to conform to the maximum settings. After MySQL is optimized for that, you can then run through the Apache Limits, then upgrade Apache through WHM or /scripts/easyapache if you're brave enough.

    If you would like a little help, let me know and I would be glad to assist you with this.
     
    zacharooni, Jul 27, 2008 IP