Results 1 to 8 of 8
  1. #1

    Unhappy Apache or MySQL slow?

    Hello.

    I installed a VPS without control panel.

    yum install httpd php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mhash gettext
    yum install mysql mysql-server
    It work is good, but when I first load, it is very slow. I must wait up 10 seconds to start load a site.
    I change from apache to lighttpd but first load is slow
    Please help a solution.

  2. #2
    Join Date
    Jan 2010
    Location
    India
    Posts
    214
    Does the VPS has enough free memory allocated ?

  3. #3
    Join Date
    Dec 2009
    Location
    New Hampshire
    Posts
    14
    PHP+MySQL+Apache can be a really heavy burden on a server. I was just hosting some static content with Apache2 and RAM usage (without optimization) shot up well past 50Mb.

    I would look at apache VPS optimizations at http://www.agnivo.com/tech/vps-mysql...-guide-27.html or switch to something like lighttpd.

  4. #4
    Quote Originally Posted by oceanplexian View Post
    PHP+MySQL+Apache can be a really heavy burden on a server. I was just hosting some static content with Apache2 and RAM usage (without optimization) shot up well past 50Mb.

    I would look at apache VPS optimizations at http://www.agnivo.com/tech/vps-mysql...-guide-27.html or switch to something like lighttpd.
    He did change to lighttpd according to the first post, but it loads slowly the first time around. If its loading slow, I suggest you take a peek at the CPU usage, maybe thats why its taking quite a bit to process and then it processes much faster the second time around cause its making use cache. But yes, I definetly agree you should do some Apache + MySQL Optimization base on your usage and specs.
    Ian Lai - www.fyianlai.com
    Web Design & Development
    System Operator & Administrator

  5. #5
    I installed VPS with min 512Mb Ram and shared CPU is 1 core. And VPS isn't high load. All is normal!

  6. #6
    What is the server load and number of http connections.

  7. #7
    Join Date
    Jan 2010
    Location
    India
    Posts
    214
    Hi,

    Can you please post the result of the following command here?

    "cat /proc/user_beancounters"

  8. #8
    Join Date
    Oct 2009
    Posts
    276
    Hello,

    Try disabling server firewall and test it. If it is the issue, we can dig into the rules further.

Similar Threads

  1. Apache 2 + php + mysql very slow performance
    By Abadon in forum Hosting Security and Technology
    Replies: 10
    Last Post: 11-26-2009, 07:18 AM
  2. VPS incredibly slow, huge numbers of slow MySQL queries for Plesk/Watchdog
    By lumpysimon in forum Hosting Security and Technology
    Replies: 3
    Last Post: 11-11-2008, 12:31 PM
  3. How to match Apache URLs with MySQL slow queries
    By guarriman in forum Dedicated Server
    Replies: 4
    Last Post: 11-19-2007, 11:26 PM
  4. Very slow apache/mysql performance
    By albano in forum Dedicated Server
    Replies: 5
    Last Post: 11-11-2005, 09:32 PM
  5. apache slow, help
    By jason216 in forum Dedicated Server
    Replies: 1
    Last Post: 09-15-2004, 06:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •