Linux - NewbieThis 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
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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%!!!
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
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?
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.
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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.