h4. [Optimizing MySQL Database Application Performance with Solaris Dynamic Tracing !Main^download.gif!|http://mapping.sun.com/profile/offer.jsp?id=128]
*by Luojia Chen{*}{excerpt}
January 2009{excerpt}
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.
h4. 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
{panel:title=About the Authors|borderStyle=solid|titleBGColor=#F8D583|bgColor=white}
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.
{panel}
{vote:Rate this blueprint}
Great
Good
Fair
Poor
{vote}
*by Luojia Chen{*}{excerpt}
January 2009{excerpt}
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.
h4. 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
{panel:title=About the Authors|borderStyle=solid|titleBGColor=#F8D583|bgColor=white}
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.
{panel}
{vote:Rate this blueprint}
Great
Good
Fair
Poor
{vote}