The focus for this session is the different ways in which you can extract and use the information about queries to help identify and improve the quality of your queries and the structure of your database.
By using real applications and environments the session will detail how I have used different systems to examine the execution of my queries and how I’ve used combinations to help produce a more detailed report on your applications and queries.
Systems covered will included:
For combinations, the session will examine how different tools can be used to provide different aspects of the problems with your query. For example, EXPLAIN on its own only demonstrates the potential problems with your query. But by combining EXPLAIN with DTrace you can gain a detailed understanding of which parts of the query process are taking the most time. By using this more specific information you can drill down and modify your queries, indexes and tables to achieve the best performance.
The focus will always be on improving the structure of the tables, queries and overall application logic, using the query analysis tools as a guide.
Martin MC Brown is a Technical Writer for the MySQL team within Sun Microsystems, but spends a lot of his time working with and advising different teams within MySQL on the architecture, implementation and end-user experience of MySQL. He draws on a wide experience of database and application development and large scale deployment of technology in grids and distributed computing environments involving hundreds or thousands of computers working in harmony. Today he spends most of his time developing large scale solutions, techniques for better performance monitoring or writing about it to educate other people.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.