MySQL Newsletter November 2008

Articles in this newsletter:

Events

Live Webinar: Troubleshooting Performance Issues and Managing Backup/Recovery with MySQL Enterprise and Zmanda Recovery Manager (November 19)
Live Webinar: Simple, Fast, and Flexible Warehousing with MySQL and Infobright (EMEA) (November 25)

Training, Consulting, & Certification

Highlights

Sun Systems for MySQL - Get the Ease of MySQL Deployments All Under One Roof

MySQL has become the world's most popular open source database because it's built for the Web economy. Now with Sun Systems for MySQL, you can scale with up to 3x greater performance and save up to half the cost, backed by Sun's systems and software expertise.

Learn more »

Gartner Webcast: Database Infrastructure for the Modern Online World

In this presentation, trusted advisors from Gartner and Sun Microsystems discuss the business options and best practices for open source databases. We will also find out how Zappos.com, a highly successful ecommerce site, saves over $1 million a year annually and stays on top of their explosive growth by subscribing to Sun's MySQL Enterprise Database subscription.

Watch the Webcast »

MySQL Query Analyzer Interview with Mark Matthews

MySQL Performance Tuning is always a popular topic for DBAs and Developers. Traditionally, database tuning has required manual effort and custom scripts. MySQL Query Analyzer aims to minimize the manual effort, with easy-to-use tools to help find-n-fix problem queries. In this interview, we talk with Mark Matthews, to get an architects view of the product.

Also, the MySQL Query Analyzer is now part of the MySQL Enterprise 30-day Trial.

Read the Interview Script »

MySQL User Conference Worldwide Tour 2008 - Taipei, Shanghai, Beijing

MySQL User Conference comes to Asia! In these one-day conferences, you will gain knowledge you need to rapidly build solid applications with MySQL that scale with the enterprise. Join us and other MySQL DBAs and developers to innovate with MySQL.

MySQL Conference 2009 - Save the Date, April 20-23, 2009

The 2009 MySQL Conference & Expo, April 20-23, 2009 in Santa Clara, CA, brings over 2,000 open source and database enthusiasts together to harness the power of MySQL and celebrate the huge MySQL ecosystem. Save the date and join us for the largest gathering of MySQL developers, users, and DBAs worldwide. Early registration opens soon.

Learn more »

MySQL Embedded Server in Appliances

Appliances provide all of the software and hardware necessary to deliver a function-specific "shrink-wrapped" solution. They eliminate much of the cost, complexity and "guesstimates" inherent in self-assembled solutions. Using the MySQL Embedded Server enables appliance vendors to deliver a differentiated solution, bring products to market faster, reduce COGS and improve profitability, and win competitive comparisons.

Learn more » (http://www.mysql.com/why-mysql/isv-oem-corner/appliance/)

Are you an ISV? Learn how other ISVs grow businesses using MySQL » (http://www.mysql.com/why-mysql/isv-oem-corner/)

More resources for ISVs » (http://www.mysql.com/why-mysql/isv-oem-corner/resources.html)

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

Thursday, November 20, 2008 - 10:00am PST

The MySQL Enterprise 2008 Fall Release is designed to alleviate pain points around diagnosing and fixing performance problems related to poorly performing SQL code. Join us to see how the MySQL Query Analyzer helps keep your key MySQL systems up and running at the highest levels of scalability and performance.

Case Study: Shinsei Bank Relies on MySQL and SugarCRM to Radically Accelerate Enterprise Application Deployment

Shinsei is a leading financial institution in Japan. Shinsei has standardized on MySQL and SugarCRM for their customer relationship management (CRM) system and developed a unique "path-based" approach to developing and deploying applications which gives them the flexibility to modify their system as business requirements change. As a result, Shinsei successfully developed an entirely new enterprise system in one fourth the time and at a savings of 90% of the cost of using legacy mainframes and proprietary packaged software.

Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_shinseibank.php)

MySQL University: MySQL Sessions Open to Everyone

MySQL University is a no cost training program for Sun Database Group Engineers, MySQL Community Contributors and anyone who's interested in MySQL development and internals. Sessions are run via voice stream and IRC feedback channel and usually last for an hour. Upcoming topics include Using memcached in MySQL deployments, What's New in MySQL Optimizer, Random Query Generator, Developing MySQL on Solaris, and much more.

For more information and session schedule, visit »

New Product Releases

New Release of MySQL Community Server 5.1.29 (RC)

We are proud to present to you the MySQL Server 5.1.29-rc release, a new "release candidate" version of the popular open source database.

View the complete list of changes »

Download Now »

New Release of MySQL 6.0.7 (Alpha)

MySQL 6.0.7-alpha, a new version of the MySQL database system has been released. Changes include:

Important Change: mysqlbinlog now supports --verbose and --base64-output=DECODE-ROWS options to display row events as commented SQL statements. (Bug#31455)
Security Enhancement: The server consumed excess memory while parsing statements with hundreds or thousands of nested boolean conditions (such as OR (OR ... (OR ... ))). (Bug#38296)
Incompatible Change: Some performance problems of SHOW ENGINE INNODB STATUS were reduced by removing used cells and Total number of lock structs in row lock hash table from the output. These values are now present only if UNIV_DEBUG is defined at MySQL build time. (Bug#36941,Bug#36942)
Important Change: The INFORMATION_SCHEMA.FALCON_TABLES table has been removed. (Bug#29211, Bug#34705, Bug#34706)

View the complete list of changes »

Download Now »

New Release of MySQL Workbench OSS / SE 5.0.27 (GA)

We managed to fix 15 bugs since our last release on 10/14/2008. It features a huge improvement on memory usage and an updated layer-pane, listing all objects on a diagram-canvas - now including connections too (this allows easy selection of hidden objects). Please keep posting any issues that you encounter while working with our product.

View the complete list of changes »

Download Now »

New Release of MySQL Workbench 5.1.4 for Linux (Alpha)

Thanks for all the feedback and contributions we received since we released the first alpha builds. We have added functionality, fixed bugs and started to build packages for Fedora Core 9 along with our native packages for Ubuntu 8.04. Grab a package of your choice and give it a try. Please don't use this version on your production-level-files, it's still in alpha stage.

Learn more »

New Release of MySQL Connector/J 5.1.7

MySQL Connector/J 5.1.7, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Changes targeted at scalability and performance include:

Added support for CallableStatement.execute() to call stored procedures that are defined as NO SQL or SQL READ DATA when failed over to a read-only slave with replication driver.(BUG#40031)
Used socket timeouts for JDBC-4.0's Connection.isValid(int timeout) instead of timer tasks, for scalability. As a side effect internally, any communications with the database can use a timeout different than the configured timeout, but this isn't currently used.
Added connection property "useLocalTransactionState" which configures if the driver use the in-transaction state provided by the MySQL protocol to determine if a commit() or rollback() should actually be sent to the database.

View the complete list of changes »

Download Now »

New Release of MySQL GUI Tools 5.0-r14 (Windows)

Just one week after the long awaited release 13 we are pleased to announce the next one. Effective immediately you can download version 5.0-r14 of the MySQL GUI Tools from our mirror servers. While the previous release focused merely on MySQL Administrator and MySQL Query Browser, this new one also addresses MySQL Migration Toolkit issues. With this release almost every high priority bug of the GUI Tools has been fixed and we will go now through a longer course of working on the not so serious but nonetheless annoying problems. Fixes include:

Can't start transaction using toolbar button. (Bug #40164)
Output of CONCAT not displaying properly in Query Browser when BINARY fields. (Bug #40018)
Migration toolkit suppresses the warnings when number type is rounded. (Bug #27541)
Bulk Transfer via lua script and grtsh.exe results in 'DROP DATABASE IF EXISTS'. (Bug #36182)

Download Now »

Learn more »

Hints & Tips

Article: Using Partitioning to Manage Satellite Networks

Guy Adam

Parallel Ltd. was founded in 1998 and is based in Milton Keynes, United Kingdom. Our main product is SatManage, a web-based application for managing satellite networks.

At Parallel we've used Partitioning since the very first release of 5.1 (sometime December 05). We're now on MySQL 5.1.20 and 5.1.22 and we started development using partitioning with MySQL 5.1.3.

Read the Article »

Article: Bound and Unbound DataGridView Control for MySQL 5.0/VB.NET 2008 Windows Applications

Ernest Bonat

Understanding and programming MySQL data load into the DataGridView control is a must for Windows Application Developers today. Many times, in real production environment the end-users need to see a result set of data to make daily business decisions. The main question is about how many records they need to see when the control gets loaded.

Read the Article »

MySQL Magazine: Issue 6 Fall 2008

MySQL Magazine is the magazine for the community of MySQL database administrators and developers who use MySQL on a daily basis to provide some of the best infrastructure available.

What will you find here? News, articles on both administration and development, and feedback from the users. Simply anything related to MySQL!

Inside the Fall 2008 Issue:

Decision Table-Driven Development By Jonathan Levin
Coding Corner: Transaction Time Validity in MySQL By Peter Brawley
Overview of Zmanda Recovery Manager by Gerry Narvaja

Read the MySQL Magazine »

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: Hibernate Query Cache: A Dirty Little Secret

Darren Oldag

You Mean, Memory Is Not Infinite?

We're working hard getting MySQL Enterprise Monitor 2.0, featuring Query Analyzer, ready for release. As part of that, we started really ramping up the number of MySQL servers reporting in query data to see how we could scale. Not surprising (to me, anyway), the first efforts did not go so well. My old friend OutOfMemoryError reared its ugly head once again.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Queries that you do not want to replicate

Ivan Zoratti

If you use MySQL Replication, 99% of the times your main concern is to keep the master and the slave fully consistent and in sync. Some applications require exactly the opposite.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Scaling WikiPedia with LAMP: 7 billion page views per month

Alka Gupta

I recently attended an interesting talk by Brion Vibber, CTO of WikiMedia Foundation, a non-profit organisation that runs the infrastructure for Wikipedia. He described how his team of 7 engineers manages the Wikipedia site that gets on an average of 7 billion page views per month.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Because we can: MySQL Talks with Johan Wilman, Father of MySQL on Symbian/S60

The MySQL Telecom Team

By the end of 2007, to the surprise of many of us, a guy at Nokia Research Center announced that they had ported and were about to publish the full LAMP stack running on the Symbian/S60 platform of Nokia mobile phones. They dubbed this the Personal AMP stack: PAMP, and you can run most of the popular PHP apps like Wordpress, Drupal, phpMyAdmin... out of the box on a Nokia phone now.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: ZFS & MySQL/InnoDB Compression Update

Don MacAskill

As I expected it would, the fact that I used ZFS compression on our MySQL volume in my little OpenSolaris experiment struck a chord in the comments.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Optimizing Queries on MySQL Cluster

Johan Andersson

On the cluster mailing list (cluster@lists.mysql.com, thread "slow selects") there was recently a very good example of how to optimize queries on Cluster. Thanks to Nick Keefen for raising this problem and Jeff Sturm for the answer how to solve it!

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Two storage engines; different plans

Shlomi Noach

A popping question is: "Can an execution plan change for different storage engines?"

The answer is "Yes". I will present two such cases, where the MySQL optimizer will choose different execution plans, based on our choice of storage engine.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: A quest for full InnoDB status

Maciej Dobrzanski

When running InnoDB you are able to dig into the engine internals, look at various gauges and counters, see past deadlocks and the list of all open transactions. This is in your reach with one simple command -- SHOW ENGINE InnoDB STATUS. On most occasions it works beautifully. The problems appear when you have a large spike in number of connections to MySQL, which often happens when several transactions kill the database performance resulting in very long execution times for even simplest queries, or a huge deadlock.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Feature Preview: mysqlbackup program

Lars Thalmann

The mysqlbackup client program is now available for download as a feature preview. This program gives information about the produced backup image files and is a complement to the new MySQL 6.0 Backup feature. The program is not yet part of the main MySQL server releases.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Using the MySQL Doc source tree

Martin 'MC' Brown

I've mentioned a number of times that the documentation repositories that we use to build the docs are freely available, and so they are, but how do you go about using them?

Read the PlanetMySQL BlogPost »

Events

Live Webinar: Troubleshooting Performance Issues and Managing Backup/Recovery with MySQL Enterprise and Zmanda Recovery Manager

Wednesday, November 19, 2008 - 10:00 am PST

Are you experiencing pain points around diagnosing and fixing performance problems related to poorly performing SQL code? Do you have a data backup and recovery plan that ensures data availability and integrity in case of accidental data loss or destruction?

Join Rob Young, Senior MySQL Enterprise Product Manager and TK Krishnamurthy, Vice President, Services, Support and Operations from Zmanda as they discuss the benefits of using MySQL Enterprise - including the new Query Analyzer - and backup/recovery with Zmanda Recovery Manager for MySQL to keep your MySQL systems high performing and safeguarded.

Live Webinar: Simple, Fast, and Flexible Warehousing with MySQL and Infobright (EMEA)

Tuesday, November 25, 2008 - 14:00 GMT

In today's fast moving business environment, it is clear that Business Intelligence (BI) is a mandatory part of any company's decision making environment. The question then becomes how to build this environment in a cost-effective way that keeps up with ever-changing business requirements, new and large numbers of users, all forms of analytics, and increasing volumes of data.

Sign-up for this web presentation to learn:

How BI helps businesses make better decisions and improve efficiency
Why choosing a flexible data warehouse architecture is vital to ensuring BI success
How MySQL and Infobright are working together to create a simple, fast, and flexible data warehouse, with a low total cost of ownership

Training, Consulting, and Certification

Consulting: MySQL Cluster JumpStart (4+ Days)

A dedicated MySQL certified consultant will work closely with your team to:

Analyze your current database infrastructure
Analyze your HA database requirements
Identify potential issues and limitations
Benchmark and load test against sample queries
Recommend an architecture specific to your application to help optimize availability, fault tolerance, and performance

Learn More » (http://www.mysql.com/consulting/packaged/cluster.html)

Training: MySQL Performance Tuning (4 Days)

Raleigh, Paris, Lyon, Boston

This 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.

Partners

Zmanda: New version 3.0 of Zmanda Recovery Manager for MySQL expands platform coverage, adds backup of application files

The new version of Zmanda Recovery Manager (ZRM) supports Zmanda Management Console (ZMC) running on 32- and 64-bit Ubuntu and Debian. Also, the ZRM server can now run on Windows, protecting MySQL in all-Windows environments, in addition to Linux and Solaris. Furthermore, the new version of ZRM provides the capability of doing backup of files at the same time as backup of MySQL database. That simplifies recovery of a database and the application that uses MySQL.

Learn More »

MySQL Conference & Expo Sponsorship: Early-bird discounts end on November 30

MySQL is already busy planning the 2009 MySQL User Conference to be held in Santa Clara, California at the Santa Clara Convention Center, April 20-23, 2009. More than 1900 open source enthusiasts attended the conference in 2008, and this marquis event promises to be an even bigger and better in 2009.

MECA partners are eligible for an early-bird discount if you submit a signed contract by November 30th. We fully expect to sell out this year so please contact us early at partner@mysql.com to become a MySQL Conference & Expo Sponsor.

Learn more » (http://solutions.mysql.com/events/uc2009-sponsorship.html)

View the conference prospectus »