Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter April 2007

MySQL Newsletter - Subscribe Today

Articles in this newsletter:

Highlights: MySQL Conference & Expo - Register Before It Sells Out

New Product Releases

Hints & Tips

Events

Training, Consulting, & Certification

Partner Corner

Highlights

Register Now Before Tutorials Sell Out

The MySQL Users Conference 2007 is only 2 weeks away! Join the largest gathering of over 2000 MySQL developers, DBAs and users April 23-26 in Santa Clara, California. The theme this year is "Scale to New Heights with MySQL" At the upcoming conference you will:

  • Learn how to optimize the performance of MySQL
  • Explore the new features in MySQL 5.1
  • Get expert insight into MySQL Replication
  • Scale-out PHP, LAMP, and Java applications
  • Uncover new High Availability architectures
  • Find out how Google, Yahoo, YouTube, Reuters and Digg Scale
  • Participate in technical BoFs
  • Learn MySQL Best Practices
  • Meet the Developers who built MySQL
  • And much more ...

Register Now Before the Tutorials Sell Out »

15 In-depth Half-Day Tutorials

Take advantage of this rare opportunity to get hands-on knowledge from MySQL Experts on numerous topics. Tutorials are half day presentations that give you the opportunity to learn a topic in-depth, in a collaborative environment. Register early, so you won't be disappointed when tutorials sell out.

  • Real-World MySQL Performance Tuning
    • Ask Bjørn Hansen, Develooper.com
    • Jay Pipes, Community Relations Manager, MySQL AB
  • Scaling & High Availability Architectures
    • Jeremy Cole, Proven Scaling
  • MySQL Replication: The Complete Tutorial
    • Lars Thalmann, Replication and Clustering Technology, MySQL
  • MySQL 5.1 In-depth
    • Brian Aker, Director of Architecture, MySQL AB
  • MySQL Cluster: The Complete Tutorial
    • Stewart Smith, MySQL Cluster Developer, MySQL AB
  • MySQL Network Monitoring and Advisory Services: From Soup to Nuts
    • Andy Bang, Director of MySQL Network, MySQL

View all the Tutorials »

110+ Technical Sessions

We will have over 110+ hands-on Tutorials and Sessions covering Security, Replication, Performance Tuning, High Availability, and Scalability, OLAP and OLTP. The Sessions will be run by MySQL developers and MySQL experts who know the product inside and out and have extensive real world experience implementing MySQL applications. Here are some more session highlights:

  • MySQL Performance Cookbook
    • Peter Zaitsev, Co-Founder, Percona Ltd
  • PHP and MySQL Web App Security
    • Laura Thomson, Director of Web Development, OmniTI Computer Consulting, Inc.
  • Falcon Concurrency Control
    • Jim Starkey, Senior Software Architect, MySQL AB
  • Partitioning in MySQL 5.1 and Onwards
    • Mikael Ronström, Senior Software Architect, MySQL AB
  • Lucene and MySQL
    • Farhan Mashraqi, DBA, Fotolog
  • The 7 Stages of Scaling Web Applications: Strategies for Architects
    • John Engates, CTO, Rackspace Managed Hosting
  • High Performance Data Warehousing with MySQL: Tricks and Tips from the Field
    • Brian Miezejewski, Principal Consultant, MySQL inc.
  • Inside Falcon: MySQL's Newest Storage Engine
    • Jim Starkey, Senior Software Architect, MySQL AB

View the complete list of sessions »

Customer Success Stories

  • Managing MySQL the Slack Way: How Google Deploys New MySQL Servers (Google)
    • Michael Still, Corporate Reliability Engineer, Google Inc
    • Grant Allen, Google, Inc.
  • Federation at flickr: Doing Billions of Queries Per Day (flickr)
    • Dathan Pattishall, Senior Support Engineer, flickr.com
  • For Ticketmaster, MySQL Replication is the Ticket! (TicketMaster)
    • Ed Presz, Director of Database Engineering, Ticketmaster, Inc.
  • MySQL at Digg.com (Digg)
    • Eli White, PHP Hacker, digg.com
  • Mission Critical Flight Planning (US Navy)
    • Timothy P. Woolverton, U.S. Navy
  • Logging TeraBytes of Hits (United Online)
    • Earl Cahill, Engineering Manager, United Online
  • InnoDB Performance (NTT, Japan)
    • Yasufumi Kinoshita, Database Technology Engineer, NTT
  • Scaling MySQL for Mission Critical Applications (SugarCRM)
    • Jacob Taylor, Co-founder and CTO, SugarCRM

MySQL Expert Speakers

MySQL Conference Speakers include both the engineers who build MySQL and leading experts who are implementing MySQL in real-world environments.

  • Rasmus Lerdorf - PHP Guru, Yahoo!
  • Brian Aker - Director of Architecture, MySQL
  • Ask Bjørn Hansen - Develooper.com
  • Kevin Rose - Founder & Chief Architect - digg
  • Andi Gutmans - CTO, Zend Technologies, Inc
  • Jeremy Cole - MySQL Geek, Proven Scaling
  • Barry Klawans - CTO, JasperSoft
  • Mike Hillyer - OmniIT
  • John Newton - CTO, Alfresco.org
  • Julian Hyde - Chief Architect OLAP, Pentaho
  • Dathan Pattishall - Software Engineer, flickr.com
  • Mark D. Matthews - Developer Connector/J, MySQL
  • Michael Still - Google
  • Lars Thalman - Replication Technical Lead, MySQL

View the Complete List of Speakers »

Conference Keynotes

  • Rasmus Lerdorf, Original Author of PHP
  • Paul Tuckfield, YouTube
  • Guy Kawasaki, Garage Technology Ventures
  • Eben Moglen, Software Freedom Law Center
  • Bdale Garbee, Hewlett Packard
  • Marten Mickos, MySQL
  • "Clash of the Database Egos", Hosted by Kaj Arnö
  • And More!

View the Complete List of Speakers »

Get Certified at the Conference

Certification Exams are being offered at special discounted price of $25 ($175 value). Space is limited, so pre-register to guarantee your seat at the conference.

Sign up Now »

Learn About New Products & Technologies

Every year, the MySQL Conference also features an Expo Hall where you will have the chance to meet with some of the leading innovators driving change in the open source market. The Expo Hall will give you plenty of opportunities to spend time with MySQL partners to learn more about the latest products that help you get the most out of your MySQL environment. 2007 Exhibitors and Sponsors include:

  • Google
  • Hewlett Packard
  • RedHat
  • Zmanda
  • Alfresco
  • Solid
  • Webyog
  • Four J's
  • Dolphin Interconnect
  • Nitro Security
  • JasperSoft
  • Pentaho
  • Actuate
  • BakBone
  • Unisys
  • Sun
  • And many more!

View the Current List of Sponsors and Exhibitors »

New Product Releases

Monthly Update of MySQL Enterprise Server 5.0.38

MySQL 5.0.38 Enterprise Server, a new version of the popular Open Source Database Management System, has been released and is now available for download for MySQL Enterprise customers.

The following is a partial list of changes:

  • Added the --secure-file-priv option for mysql-test-run.pl, which limits the effect of the load_file command for mysqltestand for the LOAD DATA and SELECT ... INTO OUTFILE statements to work with files in a given directory.
  • AFTER UPDATE triggers were not activated by the update part of INSERT ... ON DUPLICATE KEY UPDATE statements
  • If a thread previously serviced a connection that was killed, excessive memory and CPU use by the thread occurred if it later serviced a connection that had to wait for a table lock

View the complete list of changes »

Download Now (log-in required) »

New Release of MySQL Community Server 5.0.37

This is a new release with new features and some additional bug fixes. The following is a partial list of changes:

  • Added the SHOW PROFILES and SHOW PROFILE statements to display statement profile data, and the accompanying INFORMATION_SCHEMA.PROFILING table. Profiling is controlled via the profiling and profiling_history_size session variables. (From Jeremy Cole)
  • Added the Uptime_since_flush_status status variable, which indicates the number of seconds since the most recent FLUSH STATUS statement. (From Jeremy Cole)
  • If the duplicate key value was present in the table, INSERT ... ON DUPLICATE KEY UPDATE reported a row count indicating that a record was updated, even when no record actually changed due to the old and new values being the same. Now it reports a row count of zero.

View the complete list of changes »

Download Now »

MySQL Native Driver for PHP: mysqlnd-5.0.1 (Beta)

The MySQL native driver for PHP is an additional, alternative way to connect from PHP 5 and PHP 6 to the MySQL Server 4.1 or newer. It is a replacement for libmysql, the MySQL Client Library. From now on you can use ext/mysqli either together with libmysql as you did in the past or with mysqlnd. The following additions have been implemented since the release of 5.0.0-alpha:

  • Support for Prepared Statements
  • Support for Unicode
  • Support for PHP 5
  • Performance statistics:
    • mysqli_get_client_stats()
    • mysqli_get_connection_stats()

Please contribute to the development on the mailing list and share your ideas: php@lists.mysql.com

Download Now »

Hints & Tips

Quality Contribution Program

The goal of the Quality Contributor Program goals is to improve the quality of MySQL products, with the active co-operation of its community. The contributions we're looking for are bug reports, test cases, code patches.

Learn More »

Article: Using the New MySQL Query Profiler

Robin Schumacher

When it comes to overall performance, it's important to remember that the #1 contributor is always a good database design. The second highest contributor to performance is well-tuned SQL code.

Let's take a look at this new diagnostic utility developed by Jeremy Cole of Proven Scaling and see how it can help you create high-performing SQL code as well as assist in troubleshooting existing queries that aren't providing the response times you'd like. The new profiler became available in the 5.0.37 version of the MySQL Community Server.

Read the article »

PlanetMySQL Blog: "Streaming" MySQL Slave Deployment

Daniel Schneller

In August 2006 I made a post about the MySQL blackhole engine and its possible use for replication scenarios. Back then the primary focus was to reduce the amount of data being transferred between master and possible many slaves during normal business. This speeds up processing on the slaves, because they have considerably less data to first store to their relay logs and then immediately discard again.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: A Couple of Useful mysqldump Options

Corrado Pandiani

In my replication environment I had a hardware failure on master host. A 4.5 GB table containing blob images was corrupted, so I issued a REPAIR TABLE and the effect was to repair the table but also to reduce the number of rows. So, the problem now is how to recover only those rows from a slave and re-populate the master table avoiding to dump the entire table.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: Checking MySQL databases/tables for unused indexes: mysqlidxchk

Daniel Nichter

mysqlidxchk checks MySQL databases/tables for unused indexes. Version 1.0 with documentation and guide is available for download: mysqlidxchk v1.0 (Linux or Windows).

Read the PlanetMySQL Blog post »

Events

Live Web Seminar: What's New in the Spring 2007 Release of the MySQL Monitoring & Advisory Services

April 11, 2007, 10:00am PDT

Join us for this presentation where you will see how the MySQL Enterprise Monitoring and Advisory Services help keep your key MySQL systems up and running at the highest levels of security, performance and availability. You will see the newest version of MySQL Monitoring and Advisory Service in action via a live demonstration. It's like having a "Virtual DBA Assistant" at your side!

Register for the Webinar »

Live Web Seminar: What's New in MySQL Cluster 5.1 Including MySQL Cluster Carrier Grade Edition (German)

April 18, 2007, 15:00 MESZ

In this presentation we will explore in technical detail the new features which have been introduced in MySQL Cluster 5.1 including:

  • Disk-based Data
  • Row-based Replication
  • Online ADD INDEX
  • Hardware Selection and Tuning
  • True VARCHAR support for memory data

Register for the Webinar (in German) »

Training, Consulting, and Certification

Consulting: MySQL Performance Tuning & Optimization (3+ Days)

  • Do your applications slow down during busy times?
  • Are you having difficulties pinpointing performance bottlenecks?
  • Will finding and fixing performance issues take weeks and expertise that you just don't have?

Then MySQL Performance Tuning & Optimization is for you. You will get expert insight and learn best practices to help you improve performance and scalability.

Schedule Your Engagement Now » (http://www.mysql.com/consulting/packaged/performance.html)

Training: MySQL 5.0 for Database Administrators (5 Days)

Montreal, Madrid, San Francisco, New York, Paris and more.

  • Is your MySQL database secure?
  • Do your users have the correct privileges and access rights?
  • Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
  • Do you want to save time using features like Stored Procedures, Triggers and Views?
  • Do you want to utilize the new enterprise features of MySQL 5.0?

Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_dba.html)

Partners

New MySQL Storage Engine: solidDB for MySQL

solidDB for MySQL is a complete relational database management system that combines the MySQL Enterprise Server, solidDB Storage Engine and MyISAM storage engine. The solidDB Storage Engine provides a fast, scalable, transactional engine to store and manage data, while MySQL Server offers the "upper layers" of the database stack.

Download the Technical White Paper »

Zmanda Webinar: Backup and Recovery of MySQL Clusters

Zmanda Recovery Manager (ZRM) for MySQL provides a simple and easy way to backup and recover MySQL clusters. Zmanda Engineers will provide an overview of ZRM for MySQL and demonstrate its ability to backup and restore MySQL cluster.

Register for the Webinar »

The MySQL Team