Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter September 2006

Newsletters older than 6 months may have links that are out of date. Please use the Search to check for updated links.

Articles in this newsletter:

Highlights

Products

Hints & Tips

Events

Training, Consulting, & Certification

Highlights

MySQL European Customer Conferences - Only a Few Weeks Left to Register
Northern Europe Customer Conference: London, October 17th, 2006
Central Europe Customer Conference: Munich, October 19th, 2006

The MySQL European Customer Conferences are a great way to:

  • Meet and network with the MySQL team including executives and engineers
  • Learn a lot in only one day about the MySQL roadmap, MySQL Cluster, Web 2.0 strategy with MySQL, performance tuning, and more
  • Discover how other MySQL customers are leveraging MySQL for their mission critical applications

Register Now » (http://www.mysql.com/news-and-events/european-conferences/)

MySQL Conference & Expo 2007 - Submit a Proposal

The Call for Participation for the 2007 MySQL Conference & Expo is now open. Take an active role in shaping the future of MySQL and related open source technologies by leading sessions and tutorials at the 2007 MySQL Conference & Expo. The MySQL Conference & Expo 2007 will bring together over 1500 open source and database enthusiasts to learn how to build, deploy, and manage high-performance, scalable MySQL database applications.

Submit a Proposal (Deadline November 7th) »

White Paper: MySQL Cluster 5.1 New Features

MySQL Cluster is now being adopted not only as a database for traditional telecom applications like, HLR (Home Locator Registry) or SLR (Subscriber Locator Registry), it is now also being widely deployed for VOIP, internet billing, session management, eCommerce sites, search engines and even traditional back office applications. In this paper we will explore the new features which have been introduced in MySQL Cluster 5.1.

Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster51.php)

Analyst Report: The Forrester Wave - Open Source Projects

Forrester evaluated 13 leading open source software projects across approximately 40 criteria and found that six of the projects stand out as examples of excellence. The strongest Leaders are MySQL, Eclipse IDE, Apache HTTP Server, Apache Tomcat, JBoss Application Server, and PHP - thanks to their strong governance, well-defined road maps and release plans, and large and active communities.

Download the report » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_forrester_wave.php)

Press Release: c't Magazine Names MySQL Benchmark Winner

MySQL AB announced today that its internal benchmark team has won an international contest sponsored by the renowned IT industry magazine c´t for the fastest e-commerce database application. The magazine's editors held the contest to evaluate database performance in real-world business use by creating a standard online inventory system.

Read the Press Release » (http://www.mysql.com/news-and-events/press-release/release_2006_35.html)

Interview: Ten Questions with Marten Mickos, CEO of MySQL

Marten Mickos joined MySQL AB as CEO in 2001. Under his leadership, the company has grown from a startup to the second largest open source company and the fastest-growing database vendor in the world. Prior to MySQL, Mickos held multi-national CEO and senior executive positions in his native Finland.

Read the Interview »

MySQL is Hiring

Apply today to join one of the largest and fastest growing open source companies! MySQL is a global organization with over 300 employees in 25 countries. We have openings for the following positions:

  • ODBC Developer
  • QA Engineer - MySQL Server
  • QA Engineer - MySQL Network
  • Software Developer - DB Maintenance
  • Senior Software Developer - Storage Engine
  • Senior Software Developer - MySQL Cluster
  • Senior Software Developer - DB Internal
  • Corporate Controller
  • Senior Consultant
  • IT Support Services
  • Senior Paralegal USA
  • Executive Assistant/Office Manager

Apply Now » (http://www.mysql.com/company/jobs/)

Products

New Release of MySQL 5.0.24 Community Edition (GA)

This is a security and bugfix release for the current production release. Enhancements to MySQL 5.0.24 include:

  • MySQL 5.0.24 introduced an ABI incompatibility which this release reverts
  • Bug Fix: For statements that have a DEFINER clause such as CREATE, TRIGGER, or CREATE VIEW long usernames or hostnames could cause a buffer overflow
  • Mysqld Fix: mysqld could crash when closing temporary tables

For the complete list of changes visit »

Download Now »

MySQL Connector/PHP

The MySQL Connector/PHP consists of the mysql/mysqli PHP extensions built against the latest version of the MySQL client libraries for Microsoft Windows for connecting MySQL to PHP, with MySQL 5.0.24a and a new PHP 5.1.6.

For the complete list of changes visit »

Download Now »

New Release MySQL Tools for Microsoft Visual Studio (Alpha)

MySQL has released the first build of MySQL Tools for Microsoft Visual Studio - a downloadable plug-in for Visual Studio 2005 that allows Windows developers to quickly build MySQL data-driven applications with Visual Studio. With this plug-in, developers will be able to create, modify and manage MySQL database objects with an easy-to-use interface from within the Visual Studio IDE. The product is delivered as a package compatible with Visual Studio 2005 and delivers the following features:

  • DDEX (Data Designer Extensibility) compatibility
  • Ability to work with MySQL objects (tables, views, stored procedures, etc. from within the Server Explorer

Download Now »

Hints & Tips

Interview: Interview with Brian Moon, Architect of the Phorum Project

If you've spent any amount of time on the forums, you probably will have recognized Brian among the forum users who most frequently answer posts -- particularly SQL and performance-related questions. Some time ago, I had a chance to ask Brian a little bit about his experience writing Phorum, about his thoughts on open source and MySQL in particular, and on his vision for Phorum in the future

Read the Interview »

Interview: Rohit Nadhani, Co-founder of Webyog

Webyog is the company behind the popular SQLyog GUI tool for managing and developing MySQL databases. They have a great history of partnership with MySQL and, recently, decided to open source part of their product line. I had a chance to interview Rohit Nadhani, co-founder of Webyog, about their decision to move to open source, the changes they've made to the code as a result of that move, and various other things.

Read the Interview »

PlanetMySQL: Partitioned archive tables
Kristian Nielsen

Storing large amounts of logs in a relational database can bring special challenges. Logs can take up huge amounts of space on disk, and while disk space is cheap, disk I/O can be expensive, performance-wise. But many logs compress really well, and for this the MySQL archive storage engine (insert-only, no indexes, gzip'ed storage) can be used.

Read the PlanetMySQL Blog »

PlanetMySQL: Database access Optimization in Web Applications
Peter Zaitsev

This is pretty simple approach that can be used optimize web application performance if problems happen with few pages.

Read the PlanetMySQL Blog »

PlanetMySQL Blog: Pros and Cons of Descriptive Foreign Keys
Sheeri Kritzer

So what are the pros and cons of using descriptive foreign keys, as opposed to surrogate keys?

Read the PlanetMySQL Blog »

PlanetMySQL Blog: Refactoring MySQL Cursors
Roland Bouman

The first part of this article explains why cursors are usually unnecessary. A few common problems with cursors are briefly discussed. Also, typical stored procedure pattern is described that uses a cursor, and a demonstration is given that shows how it can be refactored to an equivalent procedure that uses a single SQL statement instead. In the second part of this article, the negative performance implications of using cursors are illustrated with a few benchmarks, and the cases where a cursor might be useful after all are briefly discussed.

Read the PlanetMySQL Blog »

PlanetMySQL: Slow Query Log analyzes tools
Peter Zaitsev

MySQL has simple but quite handy feature - slow query log, which allows you to log all queries which took over define number of seconds to execute. There is also an option to enable logging queries which do not use indexes even if they take less time (--log-queries-not-using-indexes).

Read the PlanetMySQL Blog »

PlanetMySQL: MySQL Error Checking in PHP
Bob Field

So often it seems that I am seeing someone struggling to find out what is wrong with their PHP script. They see the error message on line 18 and have no clue what this means. The line number has no bearing on where the real problem is, and there may be a whole cascade of these messages.

Read the PlanetMySQL Blog »

Events

Live Web Seminar: High Availability Clustering

Wednesday, September 27th, 2006, 10:00 am PDT; 1:00 pm EDT; 17:00 GMT

Learn how to deliver mission-critical database applications with 99.999% availability. MySQL Cluster combines the world's most popular open source database with a fault tolerant database clustering architecture. This Webinar will give you detailed insight into the MySQL Cluster architecture and how to ensure your application is continuously available.

Register for the Webinar »

Live Web Seminar (German & French): Web 2.0 und MySQL

Wednesday, September 27th, 10:00am CET (Germany)
Wednesday, October 4th, 10:00am CET (France)

Web 2.0 is the second generation of services available on the Web that lets people collaborate and share information online. One of the defining characteristics of Web 2.0 is the fact that it's the data that is driving this evolution. In this web seminar we explore how companies can increase performance, scalability and availability for Web 2.0 architectures using MySQL and MySQL Cluster.

Register for the Webinar (in German) »

Register for the Webinar (in French) »

Live Web Seminar: An Introduction to MySQL Performance Tuning

Thursday, October 19th, 10:00am PDT, 1:00pm EDT

Are you experiencing current performance bottlenecks? Designing a new 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.

Register for the Webinar »

Live Web Seminar: OLAP for MySQL using Pentaho Mondrian

Thursday, October 24th - 10:00am PST, 1:00pm EDT

OLAP allows users to quickly navigate and explore their information, analyzing data across multiple business "dimensions" like product lines, time periods, organizations and geographies.

Pentaho and MySQL provide a great combination to deliver world-class OLAP applications on an open source foundation using Pentaho's Mondrian OLAP project and MySQL 5.

Register for the Webinar »

Webinars On Demand: MySQL Replication, MySQL 5.0 Stored Procedures

MySQL On-Demand Web seminars are recorded replays of our most popular live web seminars and can be viewed any time of day. Web seminars cover a wide range of topics, including:

  • MySQL Replication
  • MySQL 5.0 Stored Procedures
  • Best Practices Securing MySQL 5.0
  • What's New in MySQL 5.1

View MySQL Webinars Now »

Training, Consulting, and Certification

Training: Developing Dynamic Web Applications with MySQL and PHP (5 Days)
San Francisco, London, Washington D.C.

  • Do you want to learn how to use both MySQL and PHP effectively?
  • Have you heard about LAMP and wonder what the fuss is all about?
  • Do you want to create large web applications using MySQL and PHP?

Then Effective Web Development with MySQL and PHP is the class for you! An Authorized MySQL instructor will teach you how to develop applications in PHP and how to use MySQL efficiently for those applications!

Register Now for an Upcoming Date » (http://www.mysql.com/training/schedule.php?class=1200)

Training: MySQL 5.0 Upgrading and New Features (3 Days)
Munich, Chicago, San Francisco

MySQL 5.0 Upgrading and New Features class is designed for Developers and Database Administrators who wish to migrate to MySQL 5.0. This course will prepare each student with the skills needed to utilize Stored Procedures, Triggers, Views, and the INFORMATION_SCHEMA metadata to enhance their productivity. Students will be exposed to the new storage engines, the ANSI SQL features and commands, the new status and configuration variables, the new precise math features and commands, and the new indexing and optimization features. In addition, this course will explain the MySQL recommended migration strategy.

Register Now for an Upcoming Date » (http://www.mysql.com/training/schedule.php?class=5301)

MySQL Packaged Consulting: MySQL Performance Tuning & Optimization

  • Are you having critical application downtime that requires immediate resolution?
  • Do your applications slow down during busy times?
  • Are you having difficulties pinpointing performance bottlenecks?
  • Will finding and fixing performance issues take weeks of time and expertise that you just don't have?

Then the MySQL Performance Tuning & Optimization package is for you! Typical performance improvements range from 50% to 100%

With customized tuning, performance may increase from 5 to 10 times Our consultants specialize in web applications, data warehouses, clustering, and embedded systems.

Contact the MySQL Consulting Team to Schedule a Visit » (http://www.mysql.com/company/contact/sales.html?s=consulting)

The MySQL Team