Newsletter Subscription | Glossary | Contact Us
Home > All Categories > MySQL > Education > Capacity Planning, Archetecture, Scaling, Response time, Throughput
Question Title Capacity Planning, Archetecture, Scaling, Response time, Throughput
Authored by: Thomas Darwin
Viewed: 128 times so far
First of all let me start off saying that I learned a lot of Capacity Planning from two people. Jozo Dujmovic, and John Allspaw-who by the way is coming out with a book.

Capacity != Performance. You may have the capacity to do a bubble sort but a bubble sort is still a bubble sort.

Really to Scale you need to know when your application will break. I have a tool set to help determine what application is producing what SQL and use that to figure out which SQL is producing the most load on the system. Some common tricks I do is put the execution path automatically as a SQL comment, then sample the FULL Processlist to build a graph on what application, function, SQL pattern is the top load.

Read more ...
Author : Dathan Pattishall
Source : http://mysqldba.blogspot.com
Click Here to View all the questions in Education category.
File Attachments File Attachments
There are no attachment file(s) related to this question.
User Comments User Comments
There are no user comments for this question. Be the first to post a comment. Click Here
Post Comment Add a Comment
Email Address:
Comment/Message
Verify Code

Post Comment How helpful was this article to you?
Related Questions Related Article
  1. MySQL Stored Procedures: CASE syntax
  2. MySQL 5.1 data dictionary diagram
  3. MySQL 5.1 partitions in practice
  4. A Primer on Falcon Tablespaces
  5. MySQL Sandbox University lesson - June 12, 14:00 GMT
  6. COUNT(*) vs COUNT(col)
  7. Using XML in MySQL 5.1 and 6.0
  8. High Performance MySQL 2nd Edition is in production
  9. The top 20 design tips for MySQL Enterprise data architects
  10. InnoDB Sessions at MySQL Conference
  11. Database Security Talk
  12. Webinar - Reduce the TCO with MySQL
  13. Reading the guide
  14. How to create a MySQL Database
  15. Designing Scalable Architectures with MySQL Proxy
  16. MySQL Conference Tracks for the DBA
  17. Top 20 DB Design Tips Every Architect Needs to Know part 5
  18. Top 20 DB Design Tips Every Architect Needs to Know
  19. MySQL Special Promotions - Training Services
  20. High Performance MySQL Second Edition Schedule
  21. Top 20 DB Design Tips Every Architect Needs to Know part 3
  22. Interview by Sun TV at MySQL Conference
  23. Top 20 DB Design Tips Every Architect Needs to Know part 4
  24. An Introduction to BLOB Streaming for MySQL part 4
  25. Top 20 DB Design Tips Every Architect Needs to Know part 2
  26. An Introduction to BLOB Streaming for MySQL part 2
  27. An Introduction to BLOB Streaming for MySQL part 3
  28. Two second editions, two first times
  29. An Introduction to BLOB Streaming for MySQL part 5
  30. MySQL Obfuscator, What features do you want to see
  31. An Introduction to BLOB Streaming for MySQL
  32. Drizzling MySQL
  33. Employee MySQL virtual columns
  34. OSCON 2008 - MySQL Proxy - from architecture to implementation
  35. Wonderful world of MySQL Storage Engines
  36. MySQL Proxy @ OSCON 08
  37. MySQL University Thu 30 Oct
  38. UC2009 - A few days, a few wishes
Article Information Additional Information
Article Number: 372
Created: 2008-08-07 6:17 PM
Rating No Rating
 
Article Options Article Options
Print Question Print this Question/Article
Email Question Email this Question/Article to Friend
Export to MS Word Export to MS Word
Bookmark Article
del.icio.us Bookmark del.icio.us Bookmark
Digg It Digg It
Furl It Furl It
Subscribe to Article Subscribe to Article
 
Language Translation Language Translation
 
Search Knowledge Base Search Knowledge Base

 
  Copyright © Mentat Technologies