LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
LinkBack Search this Thread
Old 06-05-2003, 02:18 AM   #1
pyfsapple
LQ Newbie
 
Registered: Jan 2003
Location: H.K.
Posts: 20

Rep: Reputation: 0
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 help please...
 
Old 06-05-2003, 02:24 AM   #2
Robert0380
Guru
 
Registered: Apr 2002
Location: Atlanta
Distribution: Gentoo
Posts: 1,280

Rep: Reputation: 47
are you saying that you are doing load balancing, but the loads on both machiens are still high? sounds like you either need more machines or more powerful machines. Also check to make sure you arent being attacked or something. You do have a firewall setup right?
 
Old 06-05-2003, 03:17 AM   #3
pyfsapple
LQ Newbie
 
Registered: Jan 2003
Location: H.K.
Posts: 20

Original Poster
Rep: Reputation: 0
No, I am not under any attack but just a huge number of apache (httpd) connections that are visiting the forum.

How can I solve it by so call "more machines"? I know that I can further divide the web server into two or even more, but the database cannot, right?

I have cocerned using RAID but someone tell me that it is not the solution.

Can directly connect the two servers by network cards but not through rounter solve the problem?

Thanks for your reply
 
Old 06-05-2003, 03:26 AM   #4
jharris
Senior Member
 
Registered: May 2001
Location: Bristol, UK
Distribution: Slackware, Fedora, RHES
Posts: 2,243

Rep: Reputation: 46
When you say the load is high - which aspect of the systems. Is your CPU maxed out? Or is it memory/network/disk IO that's the bottle neck? You might just want to think about performance tuning the existing systems.

cheers

Jamie...
 
Old 06-05-2003, 04:19 AM   #5
pyfsapple
LQ Newbie
 
Registered: Jan 2003
Location: H.K.
Posts: 20

Original Poster
Rep: Reputation: 0
More details...

In MySQL server

load average: 4.59, 5.66, 4.44
...
%CPU %MEM CPU COMMAND
99.9 2.6 1 mysqld

In Apache web server, there is huge connections to apache (httpd) as there are many people visiting the forum.

load averages: 2.92, 3.59, 3.40

Thanks
 
Old 06-05-2003, 04:27 AM   #6
jharris
Senior Member
 
Registered: May 2001
Location: Bristol, UK
Distribution: Slackware, Fedora, RHES
Posts: 2,243

Rep: Reputation: 46
Yeah thats pretty high CPU load. Are these your databases? If so are you making good use of indexes / a good structure to reduce query time to a minimum?

cheers

Jamie...
 
Old 06-05-2003, 05:21 AM   #7
pyfsapple
LQ Newbie
 
Registered: Jan 2003
Location: H.K.
Posts: 20

Original Poster
Rep: Reputation: 0
Yes, I am using MySQL wiht mysqld (MySQL daemon).

The forum is not written by myself but is a download one like phpBB.

Any ideas...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
time consuming loading of Openoffice and endless loading of printing capabilities artjaslo Linux - General 6 08-03-2005 01:30 PM
Loading modules error after loading compiled kernel td0l2 Linux - Newbie 12 07-28-2004 11:10 AM
Finding Module Dependencies...(Still loading...still loading..still loading..HANG!!!) Aeudian Linux - General 3 08-11-2003 03:31 PM
Finding Module Dependencies.....(still loading....Still loading....still loading) Aeudian Linux - Newbie 1 07-28-2003 02:27 PM
TTL way to high! Athlon_Jedi Linux - Networking 21 05-24-2003 08:50 AM


All times are GMT -5. The time now is 05:19 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration