LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-04-2011, 10:02 PM   #1
kshitiz
LQ Newbie
 
Registered: Jul 2005
Location: Kathmandu,Nepal
Distribution: ubuntu,Centos
Posts: 6

Rep: Reputation: 0
Mysql and Apache configuration for busy Server ?


Dear All,

I am pretty stuck with this thing.I need to tune the mysql and apache server for the comparatively busy webserver.My scenario is like this.

1. The Web request is around 2000 request at a time or more.
2. Each web request will generate one mysql query.
3. The query to database is all read.
4. This server load will be at peak for around 3-4 hours after that the load will subside. As the task will be published, around 300,000 will be viewing the page.

5 quad servers are deployed, load is balanced via DNS but performance is not as expected.
Centos 5.5 is used as OS.
Top command shows The mysql process is around 185%!!!

Please provide the viable solution.
 
Old 03-05-2011, 07:12 AM   #2
salasi
Senior Member
 
Registered: Jul 2007
Location: Directly above centre of the earth, UK
Distribution: SuSE, plus some hopping
Posts: 4,053

Rep: Reputation: 881Reputation: 881Reputation: 881Reputation: 881Reputation: 881Reputation: 881Reputation: 881
I am sorry, but not only do I not have an answer for you, but what you have written is not quite clear enough:

Quote:
Originally Posted by kshitiz View Post

1. The Web request is around 2000 request at a time or more.
are you saying that you have 2000 requests queued at one time, or something else?

Quote:
2. Each web request will generate one mysql query.
I think I am clear on what you mean, but:
  • is there any other software involved (eg, a CMS, php, etc, etc)?
  • are there many, many different queries, or there many of the queries repeats?

Quote:
As the task will be published, around 300,000 will be viewing the page.
I don't know what that means: what is publishing the task? A single page being viewed by 300,000 viewers? how does that relate to the 2000 number earlier?
 
Old 03-05-2011, 09:03 AM   #3
kshitiz
LQ Newbie
 
Registered: Jul 2005
Location: Kathmandu,Nepal
Distribution: ubuntu,Centos
Posts: 6

Original Poster
Rep: Reputation: 0
Dear Salasi,
Thanks for your response.

1. The 2000 connections is the number of connection/sec as shown by the server-status handler of apache.
It is not the exact, but from the past experience the number of user logging at a time is around 1000-2000/sec.

2. No CMS, No PHP its simple html. Here user will provide some text token given to them and they will get the result by querying the database. Therefor one web request will generate just one query.

3. On overall time span which is around 5-7 hours of publication, the servers will have their peak load. And the target users number is around 300,000.


Waiting for your reply.
Regards.
Kshitiz
 
Old 03-06-2011, 09:34 AM   #4
salasi
Senior Member
 
Registered: Jul 2007
Location: Directly above centre of the earth, UK
Distribution: SuSE, plus some hopping
Posts: 4,053

Rep: Reputation: 881Reputation: 881Reputation: 881Reputation: 881Reputation: 881Reputation: 881Reputation: 881
Quote:
Originally Posted by kshitiz View Post

2. No CMS, No PHP its simple html. Here user will provide some text token given to them and they will get the result by querying the database. Therefor one web request will generate just one query.
OK, I'll guess that there are a small number of unique pages that can be generated, or are likely to be requested at any one time, in which case you could consider using something like squid in httpd accelerator mode. There may also be configuration directives with your webserver that could help.

Quote:
3. On overall time span which is around 5-7 hours of publication, the servers will have their peak load. And the target users number is around 300,000.
When I thought that you might be using a CMS, I thought that I might know exactly what you meant by 'publication'. As you aren't, I can only think that you mean the first time that a piece of content is made available.
 
  


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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Web server configuration and issue (CentOS, Apache, PHP, MySQL) albie17 Linux - Newbie 2 01-08-2011 06:11 AM
Apache / mysql / Perl configuration outshined Fedora 1 05-24-2006 06:40 AM
configuration of apache with mysql raju_dhakar2002 Linux - Software 2 12-17-2005 07:45 AM
Mysql experts is this a innovative way to reduce the mysl load on busy server apache Linux - Software 1 07-19-2004 07:07 AM
Apache MySQL PHP configuration Gilion Linux - Software 1 02-02-2004 11:58 AM


All times are GMT -5. The time now is 05:41 PM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration