Optimizing MySQL Database Application Performance with Solaris Dynamic Tracing 
by Luojia Chen
January 2009
Today business is increasingly done on the Web, and thousands of new people, applications, and services are coming online daily. In fact, Wiki pages, mashups, social networking sites, and online stores are at the forefront of Web 2.0 technologies. As more companies, services, and sites go online and gain in popularity, enterprises must deal with the massive increases in data, as well as collected community knowledge and shared information.
When information is readily available and secure, it can help make the organization smarter, and more effective at solving business challenges. As a result, efficient and flexible environments that can scale and adapt, deploy new services quickly, and keep valuable information safe are paramount. To support this effort, Web 2.0 companies need easy access to an open, integrated platform that can help developers build and deploy high-performance, reliable Web services and applications fast. By using a complete SAMP (Solaris™ Operating System (OS), Apache, MySQL™ database, Perl) application stack along with high-performance servers and storage systems, organizations are better positioned to create environments that are capable of supporting rapidly evolving, high traffic Web sites.
Part of a series, this Sun BluePrints™ article describes how taking advantage of Solaris Dynamic Tracing (DTrace) probes can help simplify MySQL database application tuning. Through examples, this document shows some of the specific aspects of MySQL database server operation that can be observed through DTrace probes.
Contents
- Introduction
- Approaching MySQL Database Application Tuning
- The Advantages of Solaris Dynamic Tracing
- Simplifying and Speeding Performance Tuning Efforts
- Analyzing Query Loads
- Probing the Cost of File Sort Operations
- Profiling the Use of Stored Procedures
- Observing Slave Queries
- Optimizing Use of the MySQL Database Query Cache
- Putting it all Together
- For More Information
- About the Author
- Related Resources
- Ordering Sun Documents
- Accessing Sun Documentation Online
Luojia Chen is a software engineer in Sun's ISV Engineering organization. Working on the open source team, Luojia specializes in MySQL software adoption of key Sun technologies. Currently, she is focused on MySQL database benchmarks, performance monitoring, optimization, and scalability in order to understand how to make MySQL software run at peak performance on Sun platforms.
| Rate this blueprint (Log In to vote.) | |
|---|---|
| Choices | Your Vote |
Great |
|
Good |
|
Fair |
|
Poor |
|
Comments (3)
Jan 28, 2009
sriram.natarajan says:
Hi Very useful indeed. I believe most IT folks will appreciate if&...Hi
Very useful indeed. I believe most IT folks will appreciate if we can have some sample DTrace scripts available for various use cases - say within mysql wiki or something like this. this would allow other folks to build on top of our sample scripts and benefit the whole community
thanks
sriram
Feb 24, 2009
rweeks says:
We could/should set this up on BigAdmin - there is already a DTrace category in ...We could/should set this up on BigAdmin - there is already a DTrace category in the scripts section: http://www.sun.com/bigadmin/scripts/indexDtrace.html - if you find any or have any - submit them if possible.
Thanks!
Jan 29, 2009
jyri says:
The paper should also cover the MySQL 5.1 w/dtrace probes which will be availabl...The paper should also cover the MySQL 5.1 w/dtrace probes which will be available in OpenSolaris since this is the version most conveniently available to users of OpenSolaris.