MySQL Newsletter September 2009

Articles in this newsletter:


New Product Releases

Hints & Tips

Spotlight: MySQL in Telco


Training, Consulting, & Certification



Developer Interview: What's New in the MySQL Enterprise Fall 2009 Release? - Interview with Mark Matthews and Andy Bang

We talked to Mark Matthews and Andy Bang, two core developers in the MySQL Enterprise Monitor team, to give us some insight into the new features in the latest MySQL Enterprise Release. You can find more about the MySQL Query Analyzer in our previous interview with Mark.

Read the Interview »

Press Release: New Version of MySQL Enterprise Allows DBAs to Graphically Drill-Down into Database Bottlenecks to Improve Application Performance

Sun Microsystems, Inc. today announced an update to its MySQL Enterprise subscription, designed to assist corporate users improve the speed and uptime of their MySQL database applications. Graphical enhancements to the MySQL Enterprise Monitor's Query Analyzer help DBAs and developers to better pinpoint database queries to avoid performance problems. With new visual correlation graphs, problem queries can now be filtered and analyzed by highlighting specific time-periods of interest with a few mouse-clicks - making it easier to quickly find spikes in key system resources, and fix problems rooted in inefficient SQL code.

Learn More » (

Try the MySQL Enterprise Fall 2009 Release 30 days for free » (

Watch the Demos » (

Read the English White Papers » (

Read the French White Papers » (

Read the Italian White Papers » (

Read the German White Papers » (

Read the Japanese White Papers »

Case Study: Migrated from Microsoft SQL Server to MySQL and Improved Scalability by 400%

Ticketmaster Entertainment, Inc. is the world leading event ticketing company. In 2001, due to the growing popularity of online sales of show and sports tickets, the demand for began to exceed its capacity and caused stability issues. To solve the problem, decided to move the Event database from Microsoft SQL Server to MySQL. MySQL enables to achieve the 4x scalability, while consistently maintaining the average replication time of less than one second.

Read this Case Study » (

White Paper: MySQL Enterprise Monitor - What's New, Fall 2009 Release

MySQL is proud to announce the Fall 2009 Release of the MySQL Enterprise Monitor. The MySQL Enterprise Monitor now allows you to visually correlate MySQL and OS graph and query activity so you can easily find your most expensive queries and analyze execution patterns and trends that may be causing spikes in key system resources. Plus, new Advisor Rules and Graphs enable DBAs to implement more MySQL best practices relating to administration, upgrade, schema, and performance.

Read the English White Paper » (

Read the French White Paper » (

Read the German White Paper » (

Read the Italian White Paper » (

Read the Japanese White Paper »

White Paper: MySQL Query Analyzer Overview

The MySQL Query Analyzer helps developers and DBAs improve application performance by monitoring query performance and accurately pinpointing SQL code that is causing a slow down. With the new clickable correlation graphs, problem queries can be filtered and analyzed by highlighting the timeframe of interest, which makes it even faster to identify SQL bottlenecks.

This paper explores common use cases and challenges faced by MySQL developers and DBAs in tuning SQL code. It also introduces the MySQL Query Analyzer and explains how it can be used to optimize queries during development and then to monitor applications in production environments.

Read the English White Paper » (

Read the French White Paper » (

Read the German White Paper » (

Read the Italian White Paper » (

Read the Japanese White Paper »

Live Webinar: What's New in MySQL Enterprise Fall 2009 Release

Tuesday, September 22, 2009 - 10:00am PDT

Join this webinar and see a live demonstration of the new MySQL Enterprise Monitor and the improved Query Analyzer, hear about the new Advisor rules and support services and get live answers to your questions from our MySQL experts.

Register for this Webinar »

Live Webinar: For ISVs - Architecting Embedded Databases for High Performance Applications

Wednesday, September 23, 2009 - 10:00am PDT

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.

Register for this Webinar »

Upcoming MySQL University Sessions

MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Sun employees. Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.

Upcoming sessions include:

  • September 24: Concurrency Control - How It Really Works (Heikki Tuuri)
  • October 1: InnoDB Internals - InnoDB File Formats and Source Code Structure (Calvin Sun)
  • October 8: Building MySQL Releases on Unix (Jörg Brühe)
  • October 15: The Spider Storage Engine (Giuseppe Maxia)

Learn More »

New Product Releases

New Release of MySQL Enterprise Monitor 2.1 (GA)

We are pleased and excited to announce that MySQL Enterprise Monitor 2.1 is now posted on the Enterprise web site as our latest GA release.

The flagship features of this release include:

  • Visual correlation of any graph activity with queries in the Query Analyzer
  • Query History Graphs (in the query pop-ups)
  • Query Error and Warning tracking
  • Important product-related announcements on the What's New? page
  • New rules and graphs

Download Now (Log-in Required) »

Not a customer yet? Try the MySQL Enterprise for 30 Days for Free » (

New Release of MySQL Server 5.1.38 (GA)

MySQL Community Server 5.1.38, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.38 is recommended for use on production systems.

View the complete list of changes »

Download Now »

New Release of MySQL Server 5.0.85 (GA)

MySQL Community Server 5.0.85, a new version of the popular Open Source Database Management System, has been released. This and future releases in the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts.

View the complete list of changes »

Download Now »

New Release of MySQL Workbench 5.1.18 (GA)

We are proud to announce the next service release of MySQL Workbench 5.1.18. We have fixed another set of bugs and made some improvements people have been asking for. We have optimized the layout of the Columns-section in our table-editor. Now it provides a smoother and more comfortable workflow.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/Net 6.1.2 (GA)

MySQL Connector/Net 6.1.2, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against servers ranging from version 4.1 to 5.4. This release also includes a slew of bug fixes made to the 5.2 and 6.0 trees. Please check the release notes and change log for a complete list of those changes.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/C 6.0.2 (GA)

MySQL Connector/C 6.0.2, a new version of the C API for accessing MySQL database servers has been released. This release is of GA quality and is suitable for use in production environments.

Download Now »

Read the Documentation »

Hints & Tips

Article: Quick and Dirty MySQL Performance Troubleshooting

Jeremy Zawodny

Sooner or later, you're going to get that phone call (or email, SMS, instant message, tweet, or whatever): The database is slow! Fix ASAP! And you'll be expected to very quickly figure out what's slowing things down - often wither very little context, background, or sense of what may have changed recently at the application layer.

Read this Article »

Article: Using MySQL to generate daily sales reports with filled gaps

Armand Niculescu

This is a classic problem but I was surprised to see that there's not a great deal of info on the web on how to do a proper daily report - one that doesn't have any gaps when data is missing. In this post I'll guide you through building such a report using MySQL and PHP for presentation.

Read this Article »

White Paper: A Guide to MySQL for Microsoft Windows Server 2008 Failover Clustering

In this paper we present a guide for setting up a development environment in order to leverage MySQL with Microsoft's Windows Server 2008 Failover Clustering feature. Although, not intended to be a guide for production deployments, it should give Windows developers, DBAs and system administrators a fundamental understanding of how to configure MySQL to use this feature.

Read this White Paper » (

White Paper: An SMB Guide to Developing an Open Source Strategy

Not only is open source ready for the world's largest enterprises, it's ideal for small- and medium-sized businesses (SMB's) as well. Many SMB's are realizing significant cost savings by using open source products to power web sites, business-critical enterprise applications and packaged software. This paper is your guide to developing an open source strategy.

Read the English White Paper » (

Read the German White Paper "Leitfaden zur Entwicklung einer Open-Source-Strategie für KMU" » (

Read the Italian White Paper "Guida allo sviluppo di una strategia open source per le PMI" » (

Case Study: School of Everything's Powerful Web Infrastructure Relies on MySQL Deployed using Amazon EC2

The School of Everything is a website that helps people who want to learn meet up with people who want teach. School of Everything chose to deploy MySQL and Drupal on Amazon's Elastic Compute Cloud (EC2) services as this offered them the greatest flexibility.

Read this Case Study » (

PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.

Visit PlanetMySQL »

Submit Your Blog Feed »

PlanetMySQL Blog: MySQL/Open Source Event Calendar

Lenz Grimmer

The MySQL Community Team maintains a calendar to keep track of Open Source events and conferences that might be relevant from a MySQL point of view. This calendar is now public - you can either look at the HTML version on the MySQL Forge or subscribe to the iCal feed.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: FrOSCon/OpenSQL Camp summary

Lenz Grimmer

It's almost two weeks now since FrOSCon and the OpenSQL Camp subconference have taken place in Sankt Augustin, Germany - about time for a summary and update from my side!

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Examples of bad queries

Sarah Sproehnle

In my years of teaching MySQL topics, I've noticed that many people write bad queries. It's not necessarily their fault. It could be that they don't understand some aspect of SQL, or that they solved the problem with the first technique that came to mind, or that their query is fine except that MySQL optimizes it poorly. I'll give a few examples.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Labs - server snapshots available for download

Giuseppe Maxia

Users familiar with the MySQL development process will remember that our developers use a tool called pushbuild, which builds the server code with the latest changes, using several operating systems, and runs the test suite.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: When does InnoDB do disk IO?

Mark Callaghan

This is a list of most of the sources of disk IO in InnoDB. Most of the statements below are true for official MySQL 5.0 and the InnoDB plugin prior to 1.0.4.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Will your production MySQL server survive a restart?

Toby Thain

Do you know if your production MySQL servers will come back up when restarted? A recent support episode illustrates a number of best practices. The task looked trivial: Update a production MySQL server with a configuration tuned and tested on a development server. Clean shutdown, change configuration, restart.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Watch out for hostname changes when using replication!

Trent Lloyd

For one reason or another, many times we find ourselves changing the hostname of a machine. It's been repurposed or moved - or perhaps the original installer didn't know what name it should have. To achieve this on most modern Linux distributions there are 2 key files you need to update.

Read the PlanetMySQL BlogPost »

Spotlight: MySQL in Telco

White Paper: Using MySQL Cluster for Web & eCommerce Applications

MySQL Cluster is a proven key component of web infrastructure that can help you cost-effectively deploy online applications to generate new revenue streams and build vibrant user communities. Read the white paper to learn how deploying MySQL Cluster with your web and eCommerce services enables you to grow revenue and enhance customer loyalty.

Read this White Paper » (

White Paper: IDC Analysis of Open Source Adoption in Telecom Service Delivery Infrastructure

Reducing cost, accelerating time to market and enhancing subscriber experience are key drivers for investment by Communications Service Providers (CSPs) today, and open source technologies are playing a transformational role in enabling CSPs to meet these strategic goals. Get the latest research from IDC and MySQL and learn where and why CSPs and technology providers are adopting open source technologies to power the next generation of network service infrastructure.

Read this White Paper » (

Case Study: Shopatron Grows eCommerce Services with MySQL Cluster

In 2006, Shopatron began investigating clustered database solutions that would provide the performance, scale and availability demanded by their growing eCommerce business. Having used the MySQL Server for several internal projects, they were aware of the performance and reliability offered by MySQL technologies. They were also aware that MySQL offered a real-time, high availability implementation of the database called MySQL Cluster.

Read this Case Study » (

Case Study: MySQL Cluster Helps Mapion to Improve its On-Line Mapping Application

Mapion Co., Ltd, is Japan's leading provider of online map services. The company offers the Mapion online map; navigation tools and directions delivered to users' mobile phones with Mapion Mobile; and provides its Mapion BB service for broadband users.

Read this Case Study »

PlanetMySQL Blog: Using NDB API Events to mask/hide column data when replicating

Andrew Morgan

If you have asynchronous replication where the slave database is using MySQL Cluster then you can use the NDB API events functionality to mask/overwrite data. You might do this for example if the replica is to be used for generating reports where some of the data is sensitive and not relevant to those reports.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Cluster + Dolphin DX = Sweet!

Johan Andersson

At a customer I have had the opportunity to work with some really state of the art equipment. The customer is in the online gaming industry and we are building a platform based on MySQL Cluster where we are consolidating a number of applications.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Updating the MySQL Cluster DBA Exam

Dave Stokes

It is time to update the MySQL Cluster exam. The current exam was written when the Cluster software was at version 5.1 and 7.0.5 is available for download. Reviewing the old exam questions shows some of them are badly dated.

Read the PlanetMySQL BlogPost »

Read the PlanetMySQL BlogPost "Cluster exam update, part II" »

Live Webinar: FreeRADIUS & MySQL Cluster - Scalable and Highly Available AAA Services

Wednesday, September 30, 2009 - 9:30am PDT

Tune into this webinar where you can hear from Alan Dekok, one of the founders of the FreeRADIUS project and CEO of Network RADIUS, discussing the concepts and implementation of RADIUS services using the FreeRADIUS server and the MySQL Cluster database to deliver highly available and scalable AAA services.

Register for this Webinar »

Live Webinar: Best Practices Webinar - Shopatron's eCommerce Services Powered by MySQL Cluster

Thursday, October 22, 2009 - 10:00am PDT

Tune into this webinar where Shopatron's CIO/COO and VP of Engineering will both share their experiences and best practices of implementing the MySQL Cluster database for eCommerce applications.

Register for this Webinar »


Live Webinar: Top MySQL Enterprise Subscription Tips and Tricks

Monday, September 21, 2009 - 10:00am PDT

Join us in this webinar to hear from a MySQL customer, Phil Hildebrand, Operations Manager for databases and deployments, thePlatform, his top MySQL Enterprise tips and tricks to help you improve performance, productivity and stay ahead of your competition!

Register for this Webinar »

Live Webinar: Advanced Techniques for High Traffic Sites - EMEA

Wednesday, September 23, 2009 - 10:00 CET

Join us for the 3rd of our 4 part webinar series exploring the different aspects of using MySQL as the database for online applications. With real life experience gained working with MySQL Customers such as Facebook, Alcatel Lucent and Google, this webinar series will give you the information you need to run scalable, highly available online applications.

In the 3rd part of this webinar series we examine some of the advanced techniques available to service complex, high traffic, online applications.

Register for this Webinar »

Live Webinar: Open-Source for High Performance Web Applications

Thursday, September 24, 2009 - 10:00am PDT

Many enterprises are looking to open-source software to significantly cut IT costs while increasing agility to respond to changing market conditions. In this web seminar, you will get tips and tricks from the MySQL and GlassFish experts for building a highly performant, agile open-source platform structure in your enterprise.

Register for this Webinar »

Live Webinar: High Availability Architectures for Online Applications

Tuesday, September 29, 2009 - 10:00am PDT

Join us for the last of our 4 part webinar series exploring the different aspects of using MySQL as the backend database for online applications. In this last installment we look at MySQL high availability technologies and architectures. We will explore the uses cases for implementing MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD), and other high-availability technologies.

Register for this Webinar »

Live Webinar: Getting Started with MySQL on Windows

Thursday, October 01, 2009 - 10:00am PDT

Join us for this informative technical webinar with Mike Frank, Sr Product Manager at Sun Microsystems. In this presentation we'll cover the benefits of deploying MySQL on Windows. You will learn the basic "How-To's" of installation, security and configuration. We will show you how to start using MySQL tools on Windows, such as MySQL Workbench and MySQL Enterprise Monitor with the new MySQL Query Analyzer.

Register for this Webinar »

Live Webinar: For ISVs and OEMs - Automatic MySQL multi-platform deployment with your Java Application Using MySQL Connector/MXJ

Wednesday, October 07, 2009 - 10:00am PDT

Connector/MXJ is a Java utility package that makes the MySQL database appear to be a Java-based component. The connector automatically determines which platform the system is running on, selects the appropriate binary, and launches the executable. With MySQL Connector/MXJ, you can reduce installation barriers for your end user customers by simply adding an additional parameter to the JDBC connection url which will cause the database to start when the first connection is made.

Register for this Webinar »

Live Webinar: How to grow your user base 275% with High Availability - EMEA

Wednesday, October 07, 2009 - 9:00 CET

University of Turku in Finland is at the forefront of research in areas such as bioscience, interaction of culture and society, mathematical research, research of learning and education, astronomy and space research. With MySQL Enterprise the universities have created a solution that enables them to expand and scale. Listen to Miika Kauppi, Project Manager at University of Turku, present how he designed the solution, purchased it and now is taking it into production.

Register for this Webinar »

Live Webinar: Inserts at Drive Speed - Designing a Custom Storage Engine

Tuesday, October 13, 2009 - 10:00am PDT

MySQL offers a variety of storage engines that can be matched to application requirements. When none of the existing engines look like a perfect match to your requirements, you can add your own. Building a customer storage engine is easier than you'd think and there can be some substantial benefits. We will talk about lessons learned implementing the storage engine to improve flexibility and performance.

Register for this Webinar »

More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.

View the full list of webinars »

Training, Consulting, and Certification

Training: MySQL High Availability (3 Days)

Washington DC, Sao Paulo, Santa Clara, Paris

This course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.

Register Now for an Upcoming Date » (

Training: Enroll a Training Course by September 30 to Receive a 10% Discount and a Sony PSP

Don't miss out on this great opportunity to get a free Sony Playstation Portable with any MySQL Classroom Training Class. Enroll in any one of the qualifying courses by September 30, 2009 and attend by November 30, 2009 and you will receive a 10% discount and a Sony PSP Gift.

Find out the Qualifying Courses and More Details » (

Consulting: MySQL DBA (4+ Days)

A dedicated MySQL certified consultant use proven methodologies and expertise in database administration, security, performance tuning, replication, backup, and fault-tolerance to provide this service. Sun's MySQL consultants will work closely with your team to:

  • Analyze your current database infrastructure and database requirements
  • Identify potential issues and limitations
  • Install, configure and administer MySQL
  • Set-up and manage replication
  • Benchmark, load test, and optimize critical SQL queries
  • Implement best practices and recommend tools for managing your database infrastructure.

Learn More » (


Live Webinar: Kimball Group Data Warehousing Educational Webinar Series Part III - Kimball Data Warehouse Lifecycle

Tuesday, October 06, 2009 - 10:00am PDT

In this third webinar presented by Kickfire and Sun, Joy Mundy of The Kimball Group overviews all the steps to build, deploy and maintain a data warehouse.

Register for this Webinar »

Live Webinar: Alfresco - Web Based Collaborative Content Management

Thursday, October 15, 2009 - 11:00 CET

Join us for this informative technical webinar with Jeff Nott and Will Abson at Alfresco Software, which will explore the benefits of an open source Collaborative Content Management stack based on Alfresco and MySQL.

Register for this Webinar »

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

Follow MySQL on Twitter »

Follow MySQL Community on Twitter »