MySQL Newsletter November 2008
Articles in this newsletter:
- Sun Systems for MySQL - Get the Ease of MySQL Deployments All Under One Roof
- Gartner Webcast: Database Infrastructure for the Modern Online World
- MySQL Query Analyzer Interview with Mark Matthews
- MySQL User Conference Worldwide Tour 2008 - Taipei, Shanghai, Beijing
- MySQL Conference 2009 - Save the Date, April 20-23, 2009
- MySQL Embedded Server in Appliances
- Live Webinar: What's New in the MySQL Enterprise Fall 2008 Release
- Case Study: Shinsei Bank Relies on MySQL and SugarCRM to Radically Accelerate Enterprise Application Deployment
- MySQL University: MySQL Sessions Open to Everyone
- New Release of MySQL Community Server 5.1.29 (RC)
- New Release of MySQL 6.0.7 (Alpha)
- New Release of MySQL Workbench OSS / SE 5.0.27 (GA)
- New Release of MySQL Workbench 5.1.4 for Linux (Alpha)
- New Release of MySQL Connector/J 5.1.7
- New Release of MySQL GUI Tools 5.0-r14 (Windows)
- Article: Using Partitioning to Manage Satellite Networks
- Article: Bound and Unbound DataGridView Control for MySQL 5.0/VB.NET 2008 Windows Applications
- MySQL Magazine: Issue 6 Fall 2008
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: Hibernate Query Cache: A Dirty Little Secret
- PlanetMySQL Blog: Queries that you do not want to replicate
- PlanetMySQL Blog: Scaling WikiPedia with LAMP: 7 billion page views per month
- PlanetMySQL Blog: Because we can: MySQL Talks with Johan Wilman, Father of MySQL on Symbian/S60
- PlanetMySQL Blog: ZFS & MySQL/InnoDB Compression Update
- PlanetMySQL Blog: Optimizing Queries on MySQL Cluster
- PlanetMySQL Blog: Two storage engines; different plans
- PlanetMySQL Blog: A quest for full InnoDB status
- PlanetMySQL Blog: MySQL Feature Preview: mysqlbackup program
- PlanetMySQL Blog: Using the MysQL Doc source tree
- 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)
- Zmanda: New version 3.0 of Zmanda Recovery Manager for MySQL
- MySQL Conference & Expo Sponsorship: Early-bird discounts end on November 30
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.
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.
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.
Register for the Trial » (http://www.mysql.com/trials/)
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.
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.
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)
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/shinsei-bank-relies-on-mysql/)
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.
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.
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)
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.
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.
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.
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)
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.
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.
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
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.
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.
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.
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.
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.
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.
On the cluster mailing list (firstname.lastname@example.org, 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!
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.
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.
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.
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?
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.
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
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)
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.
Register Now for an Upcoming Date » (http://www.mysql.com/training/courses/performance_tuning.html)
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.
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 email@example.com to become a MySQL Conference & Expo Sponsor.
Learn more » (http://solutions.mysql.com/events/uc2009-sponsorship.html)