Results 1 to 10 of 10

Thread: High loading servers

  1. #1

    High loading servers

    Oh... I own a very high loading forum running on Linux.

    To solve it, I have divided the forum into two servers:

    Web server: Apache with web pages
    Database server: MySQL with forum data

    Yip, the loading is distributed but unfortunately, the loadings of the seperated servers are still very high.

    Any ideas ...

  2. #2
    Mentor coltrane's Avatar
    Join Date
    May 2001
    Location
    North Carolina
    Posts
    1,390

    Re:High loading servers

    Im thinking theres something else afoot here watson...what other processes do you have going on those servers?

  3. #3

    Re:High loading servers

    No other process that may cause the problem...

    In MySQL server, I always see

    %CPU %MEM TIME CPU COMMAND
    59.9 2.6 197:33 0 mysqld

    In Apache web server, I always see huge number of apache(httpd) connections. And I am not under any attack.

    Thanks for your reply.

  4. #4
    Mentor coltrane's Avatar
    Join Date
    May 2001
    Location
    North Carolina
    Posts
    1,390

    Re:High loading servers

    wow

    My entire box is running at less than 10% CPU util......what are the specs on your box?

  5. #5

    Re:High loading servers

    The database server is located in datacenter with detail specs...

    CPU: Pentium III 700Hz
    RAM: 768MB RAM
    SWAP: 512MB SWAP x 2

    RedHat 9.0
    Kernel version: 2.4.20-8smp
    mysql-3.23.54a-11

    %CPU is 99.9% at pitch time

  6. #6
    Moderator
    Good Guru
    Compunuts's Avatar
    Join Date
    May 2001
    Location
    California
    Posts
    3,935

    Re:High loading servers

    I guess the load is normal for a low end server.

  7. #7
    Senior Member
    Join Date
    May 2001
    Posts
    345

    Re:High loading servers

    I find it interesting nobody asked how high load.. in some measureable way, not that I'm any expert on db. How are we supposed to know if your box's load is typical without knowing how much load is on it?

    Only thing there is to base info off of is the cpu useage, which is "high".. can't really say that the cpu useage is high when considering the cpu useage (as a load meter).

    What to do to speed it up, hrm. I believe mysql is faster than postgrest/etc.. not sure what RH9 defaults to. It is possible you've simply got more load than 2 boxes can handle adequately. I'm sure it's possible to distribute further. Like, storage for db on a raid server, with multiple db machines sharing the same hostname (which resolves to multiple IPs) using said raid server. Course, it might be simpler just to add more CPU to your current server, or go SMP.

  8. #8
    Mentor coltrane's Avatar
    Join Date
    May 2001
    Location
    North Carolina
    Posts
    1,390

    Re:High loading servers

    i disagree, coltrane runs on a 333mhz and my httpd, mysql daemons are always running...

    root 2497 0.0 0.0 18936 76 ? S May15 0:09 /usr/sbin/httpd
    apache 5743 0.0 0.2 20392 808 ? S Jun01 0:00 [httpd]
    apache 5744 0.0 0.2 19032 776 ? S Jun01 0:00 [httpd]
    apache 5745 0.0 0.2 19064 908 ? S Jun01 0:00 [httpd]
    apache 5746 0.0 0.2 19032 768 ? S Jun01 0:00 [httpd]
    apache 5747 0.0 0.2 20416 804 ? S Jun01 0:00 [httpd]
    apache 5748 0.0 0.2 19032 776 ? S Jun01 0:00 [httpd]
    apache 5749 0.0 0.7 20328 2360 ? S Jun01 0:00 [httpd]
    apache 5750 0.0 0.2 19032 864 ? S Jun01 0:00 [httpd]


    root 2414 0.0 0.0 4192 12 ? S May15 0:00 /bin/sh /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
    mysql 2444 0.0 0.0 13912 0 ? SW May15 0:00 [mysqld]

    The only thing thats using a percentage of real CPU is X


  9. #9
    Senior Member
    Join Date
    May 2001
    Posts
    345

    Re:High loading servers

    Now if coltrane's box was hosting /., X would be so sluggish he wouldn't have been able to make that post.

  10. #10
    Mentor coltrane's Avatar
    Join Date
    May 2001
    Location
    North Carolina
    Posts
    1,390

    Re:High loading servers

    point taken

Similar Threads

  1. loading errors
    By flowmask in forum Linux - General Topics
    Replies: 1
    Last Post: 08-17-2005, 12:27 AM
  2. Pre-loading mozilla
    By SunDevil in forum Linux - Software, Applications & Programming
    Replies: 1
    Last Post: 10-24-2002, 03:24 PM
  3. LJR Loading troubles
    By mcdougrs in forum Announcements and Suggestions
    Replies: 3
    Last Post: 09-05-2002, 11:30 PM
  4. Loading up slackware
    By NeM in forum Linux - General Topics
    Replies: 13
    Last Post: 03-22-2002, 02:32 PM
  5. Mouse not loading
    By Pleiades in forum Linux - General Topics
    Replies: 10
    Last Post: 12-10-2001, 11:28 PM

Bookmarks

Posting Permissions

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