Database News: MySQL Newsletter - Special Edition: MySQL Performance Tuning

MySQL Newsletter
Special Edition: MySQL Performance Tuning
mysql-newsletter@sun.com

This is a special edition of the MySQL Newsletter. In addition to the regular MySQL Monthly Newsletter, a MySQL Newsletter Special Edition will be issued each quarter that highlights technical information on topics most relevant to MySQL DBAs and developers. This edition is focused on "MySQL Performance Tuning" with resources to help you optimize and fine-tune your MySQL environment.

Highlights

- Webcast: Oracle Executive Outlines MySQL Strategy
- Event: MySQL Sunday at Oracle OpenWorld 2010 (September 19, San Francisco)
- Event: MySQL at OSCON (July 19-23, Portland)
- Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals (July 15)

White Papers

- MySQL Enterprise Monitor: Business Overview
- Boosting MySQL Performance and Scalability with the InnoDB Plugin
- Guide to Optimizing Performance of the MySQL Cluster Database

On Demand Webinars

- Improve Application Performance with the MySQL Enterprise Monitor and the MySQL Query Analyzer
- Xceedium GateKeeper: Maximizing Performance and Resilience with MySQL
- MySQL Cluster Performance Tuning Best Practices
- MySQL Performance Tuning Step-by-step
- MySQL Performance Tuning Best Practices
- Boosting Performance and Scalability with MySQL and the new InnoDB Plugin
- Performance Part 2: How to Boost Performance with MySQL 5.1 and the new InnoDB Plugin
- For ISVs and OEMs: Achieving Peak Application Performance with MySQL
- For ISVs: Architecting Embedded Databases for High Performance Applications
- Tuning and Optimizing MySQL for Maximum Performance
- Top Tips for Optimizing Performance, Saving Time and Lowering Risk with MySQL Enterprise
- Blazing Java Application Performance: Connector/J Performance Gems

Presentations

- Linux Performance Tuning and Stabilization Tips for MySQL
- Mastering InnoDB Diagnostics
- Beginner's Guide to Website Performance with MySQL and memcached
- How MySQL.com Improved Their Database Performance with MySQL Query Analyzer

Case Studies

- Big Fish Games Triples Database Performance with MySQL Query Analyzer
- thePlatform Migrates Media Publishing System to MySQL and Achieves 23x Performance Gain with the MySQL Query Analyzer
- Clickability Dramatically Improves Performance and Scalability with MySQL Query Analyzer
- Promovacances.com boosts its performance with MySQL Enterprise & the Query Analyzer
- RightNow Technologies Delivers Software-as-a-Service Using MySQL
- CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
- Telenor Powers its Next Generation Mobile Broadband Services with MySQL Cluster

MySQL Training and Certification

- Training: MySQL Performance Tuning
- Training: MySQL Performance Tuning Bootcamp Accelerated
- Certification: MySQL Certification Overview

-------------------------------------------------------------------

Highlights

Webcast: Oracle Executive Outlines MySQL Strategy

In this webcast, Edward Screven, Oracle's Chief Corporate Architect, discusses the current and future state of MySQL.

Watch the Video:
http://link.brightcove.com/services/player/bcpid62612523001?bctid=96381990001

Event: MySQL Sunday at Oracle OpenWorld 2010 (September 19, San Francisco)

Join us for MySQL Sunday, a half-day technical conference packed with the latest on MySQL, where you can choose sessions covering MySQL performance tuning, InnoDB, MySQL Cluster, MySQL Enterprise Monitor, and more. You'll also hear what's new and what's next directly from Edward Screven, Oracle Chief Corporate Architect, and other visionary technologists at the "MySQL Fireside Chat" general session. Save the date and join us!

View the list of sessions:
http://www.eventreg.com/cc250/main.jsp?CQ=1

Event: MySQL at OSCON (July 19-23, Portland)

OSCON, O'Reilly Open Source Convention, brings together people from across the open source universe to learn, inspire each other, and collaborate. Meet with MySQL experts at the Oracle booth and hear the updates on MySQL enhancements and innovations, as well as other key open source initiatives from Oracle.

Learn More:
http://www.oracle.com/webapps/events/EventsDetail.jsp?p_eventId=116026&src=7011089&src=7011089&Act=4

Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals
Thursday, July 15, 2010 - 9am PT

In Part I of a three-part performance series, MySQL performance expert Brian Miezejewski will take you through the fundamentals of architecting your product's MySQL embedded or bundled database for higher performance and customer satisfaction. Brian has many years of consulting experience helping some of the world's largest software and appliance vendors achieve MySQL performance gains of 50% to 500% in their products.

-------------------------------------------------------------------

White Papers

MySQL Enterprise Monitor: Business Overview

The MySQL Enterprise Monitor is designed to scale DBA resources by providing a unified, informed view into the health, security, performance and availability of an entire MySQL server environment. This paper explores the MySQL Enterprise Monitor in detail and explains how it can be leveraged as a "Virtual MySQL DBA" assistant to help over-extended DBAs proactively manage more MySQL servers with less time and effort.

Read the English White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php

Read the German White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.de

Read the Italian White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.it

Read the Japanese White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.ja

Try MySQL Enterprise for 30 days:
http://www.mysql.com/trials/

Boosting MySQL Performance and Scalability with the InnoDB Plugin

MySQL 5.1 now ships with the new InnoDB Plugin - a combination that provides users with immediate access to performance and scalability gains while sustaining the current production-ready and stable feature set of the MySQL 5.1 server.

In this paper, we provide a technical overview of the MySQL pluggable storage engine architecture used by the new InnoDB Plugin, including the features, performance and scalability gains users can expect to see when enabling the InnoDB Plugin in MySQL 5.1.38 or later.

Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_51_InnoDBplugin.php

Guide to Optimizing Performance of the MySQL Cluster Database

This guide explores how to tune and optimize the MySQL Cluster database to handle diverse workload requirements. In addition to discussing data access patterns and exploring schema and query optimization, the Guide concludes with recent performance benchmarks conducted with the MySQL Cluster database and a summary of additional resources that will enable you to optimize MySQL Cluster performance with your applications.

Read the English White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_perfomance.php

Read the German White Paper:
http://www.mysql.de/why-mysql/white-papers/mysql_wp_cluster_performance.php.de

Read the Italian White Paper:
http://www.mysql.it/why-mysql/white-papers/mysql_wp_cluster_performance.php

-------------------------------------------------------------------

On Demand Webinars

Improve Application Performance with the MySQL Enterprise Monitor and the MySQL Query Analyzer

Are you looking for performance tuning opportunities in MySQL? In this technical webinar, Phil Hildebrand, Database Manager at thePlatform, will talk about how they used MySQL Enterprise Monitor, MySQL Enterprise Advisors and MySQL Query Analyzer to deploy new applications and implement changes to production systems more efficiently. Phil will present these tools from a practical, user-oriented perspective, and also showcase how to achieve significant performance enhancements while reducing troubleshooting time of difficult SQL code issues.

Xceedium GateKeeper: Maximizing Performance and Resilience with MySQL

Xceedium is the leading provider of entitlement management solutions that control high-risk users. The Xceedium GateKeeper is a hardened security appliance that relies on the performance and resiliency of MySQL to store enforcement policy and continuously log, record and report on all the activities of high-risk users in demanding enterprise and government environments.

MySQL Cluster Performance Tuning Best Practices

Are you experiencing performance bottlenecks in your high availability applications? Are you designing a new mission-critical application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries?

Then this free web presentation is for you! You will get expert insight and learn best practices to help you identify those areas of database and application design that will give you the greatest benefits for performance when using MySQL Cluster.

MySQL Performance Tuning Step-by-step

Learn the basic steps the MySQL Consulting pros follow to tune a MySQL database server. Each step will be covered at a high level with one or two of the most critical parameters covered in detail for each step.

Learn not only what to tune, but also how to determine what you need to tune. Do you want to know what to watch and how to tune for connections? What caches/buffers are allocated per session, when are they allocated and how to monitor them? What can I do in 10 minutes to speed up my MyISAM or InnoDB performance? Get the answers to these and other tuning questions in this online talk.

MySQL Performance Tuning Best Practices

You will get expert insight and learn best practices from the experts at MySQL to help you improve performance! We will discuss the main performance optimization possibilities, including schema optimization, server options tuning, storage engine selection, and more.

Boosting Performance and Scalability with MySQL and the new InnoDB Plugin

Looking for ways to boost the performance and scalability of your MySQL applications now? Ready to maximize your investment in modern hardware with a version of MySQL that fully utilizes the processing power of multi-core architectures?

If so, join us for the first of a two part webinar series where we will discuss how you can achieve immediate performance and scalability gains by enabling the new InnoDB Plugin in MySQL 5.1.

Performance Part 2: How to Boost Performance with MySQL 5.1 and the new InnoDB Plugin

Looking for immediate performance and scalability gains for your MySQL application? Join us for Part 2 of our "Boosting Performance" webinar series where MySQL Professional Services experts will walk you through best practices for achieving performance and scalability improvements using MySQL 5.1 and the new InnoDB Plugin.

We will cover which plugin features to enable, and review specific use cases, tuning, and benchmarking best practices to help you maximize results.

For ISVs and OEMs: Achieving Peak Application Performance with MySQL

MySQL technical expert and Senior Sales Engineer, Pavan Venkatesh, will discuss the major MySQL design decisions that can affect the performance of your application and with it, your customers' experience and satisfaction. Pavan will show you how to achieve top performance with MySQL through his real-world experience.

For ISVs: Architecting Embedded Databases for High Performance Applications

In this Web seminar you'll learn the tips and tricks for architecting your application's embedded or bundled database for higher performance and customer satisfaction.

Using MySQL Embedded Server as our example, the MySQL Consulting pros will take you through the steps they use to optimize MySQL Embedded Server to achieve highest database and application performance. They will help you find the right answers to important architecture choices that can impact your application's performance.

Tuning and Optimizing MySQL for Maximum Performance

In this webinar we will look at performance tuning. You will get expert insight and learn best practices to help you identify those areas of database and application design that will give you the greatest benefits for performance. We will discuss guidelines and best practices covering the following areas:

- Benchmarking and Profiling Concepts and Guidelines
- Schema Optimization
- Index Selection and Tuning
- SQL Coding Techniques

Top Tips for Optimizing Performance, Saving Time and Lowering Risk with MySQL Enterprise

Join us for this webinar to learn how you can optimize your MySQL application performance, scale your productivity and stay ahead of your competition with a MySQL subscription. This session will also include a live demo of the MySQL Enterprise Monitor and Query Analyzer.

Blazing Java Application Performance: MySQL Connector/J Performance Gems

In this session, the author of MySQL Connector/J, Mark Matthews, will show you how to wring that last little bit of performance out of your Java applications deployed on MySQL by not using the out-of-the-box configuration. Connector/J has nearly 200 configuration options, many of which affect performance. While these options are documented, many aren't shown alongside the use cases they apply to. Mark will show you how to move from generic to customized, illustrating how to set Connector/J options that will deliver the best performance for your specific application.

-------------------------------------------------------------------

Presentations

Linux Performance Tuning and Stabilization Tips for MySQL
Yoshinori Matsunobu

Many people know Linux terminologies such as ext3, tmpfs, cfq io scheduler, OOM killer, etc. But many times it is not appropriately configured. In this session, the speaker will show Linux performance tuning and stabilization practices for MySQL.

View the presentation slides:
http://www.slideshare.net/matsunobu/linux-performance-tuning-stabilization-tips-mysqlconf2010

Watch the presentation video:
http://www.youtube.com/watch?v=owHamE-_0uY

Mastering InnoDB Diagnostics
Harrison Fisk

Information for solving problems with InnoDB comes from many sources, including SHOW INNODB STATUS, table monitors, SHOW STATUS, SHOW MUTEX STATUS, and information_schema tables as well as operating systems information such as iostat, vmstat, Performance Monitor and gdb/PMP.

Knowing which information is useful when diagnosing real production problems is a tough skill to learn. This talk will teach people some of the best techniques for handling the most common InnoDB issues such as locking, deadlocks, data dictionary, and performance issues.

The presentation is a .odp file so you will need OpenOffice or StarOffice to open it.

View the presentation slides:
http://assets.en.oreilly.com/1/event/36/Mastering%20InnoDB%20Diagnostics%20%20Presentation.odp

Beginner's Guide to Website Performance with MySQL and memcached
Adam Donnison

When MySQL.com found it had started to hit limits of performance the web team looked for tools to help handle the load. On the top of the list was memcached, chosen primarily for its simplicity and utility. Because it is agnostic to the data being stored memcached can be used for just about any application that can store and retrieve data by key. The distributed nature also allowed building a resilient solution, without the need for extra hardware.

In this session Adam Donnison will take you through the decision making process leading to the deployment of memcached on the MySQL.com web stack.

The presentation is a .odp file so you will need OpenOffice or StarOffice to open it.

View the presentation slides:
http://assets.en.oreilly.com/1/event/21/Beginner's%20Guide%20to%20Website%20Performance%20with%20MySQL%20and%20memcached%20Presentation.odp

How MySQL.com Improved Their Database Performance with MySQL Query Analyzer
Adam Donnison

MySQL.com is the public face of MySQL, with more than 70,000 downloads per day and millions of visitors each month. Key to this vital portal for developers, users and potential customers, is the MySQL database.

In this session Adam Donnison will explain how badly performing queries could slip through the cracks, and how using MySQL Query Analyzer found these queries within minutes of being deployed. In a graphic demonstration of the power of Query Analyzer, Adam was able to improve performance by several orders of magnitude, in just minutes.

The presentation is a .odp file so you will need OpenOffice or StarOffice to open it.

View the presentation slides:
http://assets.en.oreilly.com/1/event/21/How%20MySQL_com%20Improved%20Their%20Database%20Performance%20with%20Query%20Presentation.odp

-------------------------------------------------------------------

Case Studies

Big Fish Games Triples Database Performance with MySQL Query Analyzer

"With the MySQL Query Analyzer, we were able to identify and analyze problematic SQL code, and triple our database performance. More importantly, we were able to accomplish this in three days, rather than taking weeks."
Keith Souhrada, Software Development Engineer, Big Fish Games

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_bigfishgames.php

thePlatform Migrates Media Publishing System to MySQL and Achieves 23x Performance Gain with the MySQL Query Analyzer

"The MySQL Query Analyzer gives us a better level of visibility into our database performance that we have never had before. Not only does it save us both time and resources, it allows us to be far better prepared when applications go live, by helping us understand exactly the demands that will be placed on the system."
Phil Hildebrand, Database Manager, thePlatform

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_theplatform.php

Clickability Dramatically Improves Performance and Scalability with MySQL Query Analyzer

"The MySQL Query Analyzer allows us to quickly identify and optimize our most expensive queries, so that we can constantly improve our content management platform and scale more efficiently. It also helps improve our hardware utilization and makes us more productive, which has a direct, significant impact on our bottom line."
Jeff Freund, CEO and Co-founder, Clickability

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_clickability_quan.php

Promovacances.com boosts its performance with MySQL Enterprise & the Query Analyzer

"The MySQL Query Analyzer has enabled us to save a huge amount of time. We can very quickly identify and analyze the SQL code causing problems on the most used queries and fix the issues. I highly recommend the MySQL Query Analyzer to all DBAs and developers who want the best performance for their applications."
Guillaume Postaire, Infrastructure Manager, Karavel

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_karavel_travelling.php

RightNow Technologies Delivers Software-as-a-Service Using MySQL

"RightNow has tripled its traffic and now manages over 30TB of data - all stored in MySQL. And, with MySQL, we are able to handle 17 billion queries and 500 million page turns per month. We also use thousands of database schemas, all from different customers running dynamically generated SQL based on customer design."
Laef Olson, CIO, RightNow Technologies

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_rightnow.php

CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server

"Transaction speed was the most important factor for us in choosing MySQL. Our agents analyze 3000 transactions per second on average and at least three times of that during business hours. We needed MySQL's extremely low overhead to achieve that performance. Many of the other databases don't even have this embedded option."
Jonas Gyllensvaan, CEO, CTO and Founder, CONCEIVIUM

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_conceivium.php

Telenor Powers its Next Generation Mobile Broadband Services with MySQL Cluster

"Telenor has been using MySQL for fixed IP management since 2003 and are extremely satisfied with its speed, availability and flexibility. Now we also support mobile and LTE IP management with our solution. Telenor has found MySQL Cluster to be the best performing database in the world for our applications."
Peter Eriksson, Manager, Network Provisioning, Telenor

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_telenor.php

-------------------------------------------------------------------

MySQL Training and Certification

Training: MySQL Performance Tuning

The MySQL Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. This course will prepare you with the skills needed to utilize tools for monitoring, evaluating and tuning. You will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.

Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getcoursedesc?dc=D61820GC10&lang=US

Training: MySQL Performance Tuning Bootcamp Accelerated

The MySQL Database Administrators and Performance Tuning Boot Camp training course provides students with an 11 hour-per-day immersion into the world of MySQL database administration. The program is an accelerated course that provides those individuals who want to learn how to administer MySQL servers along with the know-how to ensure that their servers perform optimally through performance monitoring and tuning.

Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getcoursedesc?dc=D62178GC10

View the complete list of MySQL training courses:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getsearchpage?page_id=13&p_search_category_id=1488

Certification: MySQL Certification Overview

MySQL certification lays the foundation for becoming a trusted and valuable resource for your company and customers. MySQL certifications are available for Developers, DBAs and for those specializing in MySQL Cluster technologies.

Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=367

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL community?

Follow MySQL on Twitter:
http://twitter.com/mysql

Follow MySQL Community on Twitter:
http://twitter.com/mysql_community

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
http://www.mysql.com/contact/

You can unsubscribe from this newsletter online:
http://www.mysql.com/unsub?email=johandontmessup@gmail.com

--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Database News

Tuesday, June 22, 2010

MySQL Newsletter - Special Edition: MySQL Performance Tuning

No comments:

Post a Comment

Followers

Blog Archive

About Me