943,522 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 798
  • MySQL RSS
Mar 5th, 2008
0

database query limitations

Expand Post »
I want to build a web application with MySQL database.
When more users will visit my site, more database queries will be initiated and the response time will increase.
- Is there a limitation for the number of users who can query MySQL?
- What are the ways to handle heavy duty traffic to queries?
- How do think sites like Facebook handle this problem?
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
joval is offline Offline
5 posts
since Mar 2008
Mar 5th, 2008
0

Re: database query limitations

1. Number of connections are controlled by MySQL configuration parameter max_connections.
2. Use caching in your application and MySQL. Design your DB in such a way which requires minimum JOINs to fetch data. This is also known as denormalization. Write optimize queries, avoid SELECT * sort of quereis and properly index your data.
3. They adopt all the techniques which are mentioned above and as well as some others which is not mentioned here

They have multiple web servers and database servers, you can say server farms.
Reputation Points: 29
Solved Threads: 47
Posting Whiz
mwasif is offline Offline
312 posts
since Dec 2007
Mar 5th, 2008
0

Re: database query limitations

Read this article to optimize your application.
Reputation Points: 29
Solved Threads: 47
Posting Whiz
mwasif is offline Offline
312 posts
since Dec 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: query
Next Thread in MySQL Forum Timeline: store HTML is a text field in a table on a MySQL Database





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC