The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Server Optimization for big website

Discussion in 'Workarounds and Optimization' started by nidhal, Nov 16, 2012.

  1. nidhal

    nidhal Member

    Joined:
    Nov 12, 2012
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    I'm running a forum hosting website and I use a large database for this (+4gb)
    The default php&apache settings doesn't seems to be right for my website as sometimes the execution of php files take time and slow down the server for some reason, also when I run some mysql query, it takes minutes to execute. (not always, but happens many times)

    Would you please suggest a good php & apache build for me?

    Best Regards.
     
  2. concerto49

    concerto49 Member

    Joined:
    Nov 1, 2012
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    I don't think the build is the issue. You'll need to tune it. Look at your usage, see what is slow and work on tuning - monitor/profile.
     
  3. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Without more details about what software you are using, how busy the site is, and what kind of hardware you have (CPU, RAM, hard drive(s)), this is a very vague question. You will get more detailed replies if you can provide more specific information about exactly what you have.

    As a user suggested, MySQL performance may have more effect on this than your Apache and PHP build. One thing you can do is run /usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl. It is not part of cPanel; we provide it as a courtesy. It will analyze your MySQL configuration and suggest changes you can make to your /etc/mysql.conf file. Make those changes, restart MySQL, and wait a day or two. Then, run mysqltuner.pl again. You will need to keep doing this, probably several times, until gradually the MySQL configuration is shaped into a better fit for your situation.

    Server optimization is not a one-step set-and-forget task. It requires carefully analyzing exactly what is happening, making changes, observing the effects of those changes, and making more changes. Very busy servers usually require a full-time server administrator for this task. We do not recommend any specific administrators, but you can see a list of partners that provide server administration services in our application catalog:

    cPanel App Catalog
     
Loading...

Share This Page