MySQL Newsletter October 2006

New Release of MySQL Tools for Microsoft Visual Studio 1.0.1 (Beta)

MySQL has released a beta 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.

New Release of MySQL Connector/PHP for MySQL 5.0.26

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 the complete list of changes visit »

New Release of MySQL Connector/ODBC 5.0.5 (Beta)

MySQL Connector/ODBC 5.0 is meant to be used with MySQL-5.0 and newer, as it relies on information available in INFORMATION_SCHEMA when fulfilling requests for metadata. You no longer need to have Connector/ODBC 3.51 installed (however this release can co-exist with a 3.51 installation), as this version now uses its own setup library unlike prior ALPHA releases.

New Release of MySQL Connector/J 5.0.4 (GA)

This is a bugfix release for the current production branch of Connector/J. Version 5.0.4 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0 or MySQL-5.1 beta. This release includes changes and fixes from versions 3.1.14 and the yet-to-be-released 3.1.15 versions.

New Release of MySQL Connector/Net 1.0.8 (Release Candidate)

MySQL Connector/Net is an all-managed ADO.Net provider for MySQL.

We are making this release available as an RC because there were significant changes made to the provider beyond just simple bug fixes. This release includes many bug fixes along with the following enhancements/changes:

Executing stored procedures now no longer requires the user to have select privileges on the mysql.proc table
Shared memory connections now work as expected
Queries containing a large number of parameters now run many times faster than before

For the complete list of changes visit »

New Release of Perl Driver for MySQL (DBD::mysql version 3.0008)

Version 3.0008 is the production version with server-side prepare statements turned off by default, and 3.0008_1 is the development version with server-side prepare statements turned on by default. Changes include:

Added patch for SSL Verify Certificate (Thanks Eric Chen!)
Added multiple fixes to dbd_st_prepare which fixed variable overwrite and unset increment counter.
Added fix to Makefile.PL to obtain correct build flags on VMS (Thanks to Eric Milkie!)

Article about Converting scripts to MySQLi »

New Release of MySQLi PHP Converter Tool

The MySQL ext/mysqli Converter Tool is a collection of PHP scripts that help you upgrade PHP applications using the old PHP mysql extensions to using the newer PHP mysqli extension. The old ext/mysql extension does not support the full functionality of MySQL versions greater than 4.1, such as Store Procedures, Triggers, Views, and much more. In order to use all the functions in the latest MySQL server release (currently 5.0.26), you should be using the mysqli extension that is available as of PHP 5.

Read the MySQL 5.0 Documentation »

Hints & Tips

Documentation: Option and Variable Reference

A new overview table lists all available options, system variables, and MySQL server variables makes it easier to find details on setting and using the options and variables.

Read the MySQL 5.1 Documentation »

Sizing Guide and Performance Benchmarks for HP Proliant Servers

This document includes the benchmark results for a MySQL database server on HP ProLiant BL35p, BL25p and BL45p G1 servers. The benchmark uses the SysBench 0.4.7 benchmarking software to generate the results in a Red Hat Enterprise Linux 4 AS Update 3 (RHEL4ASu3) environment utilizing MySQL database server 5.0.17c x86_64.

Download the Performance Benchmarks »

PlanetMySQL Blog: I Can't See My Databases!

Bob Field

This common complaint uttered fairly frequently on the forums appears to stem from some basic misunderstandings of the MySQL account structure. The most common culprit is the "anonymous guest" account set up by default, coupled with an initial lack of knowledge of how to connect to MySQL.

PlanetMySQL Blog: What to Tune in MySQL Server after Installation

Peter Zeitzev

Even though you can tune many variables in MySQL Server, there are a few that are really important for the most common workloads.

PlanetMySQL Blog: MySQL Benchmarking, Compiling Super-Smack on Solaris

Frank Mash

This is the part 4 of MySQL Benchmarking series. In the last post I showed you how you can compile Sysbench on Solaris 10. In this post, I will be showing you how you can compile Super-Smack on Solaris 10.

PlanetMySQL Blog: MySQL Query Profiler

Baron Schwartz

This is the fourth in a series of articles on profiling MySQL. My past three articles have explained how to measure the work a query causes MySQL to do. In this article I introduce a tool I've written to do the work for you and produce a compact, readable report of that work, with all the math already done, and the measurements labelled and grouped for ease of comprehension. With this tool you can understand query performance at a glance.

PlanetMySQL Blog: Should MySQL and a Web Server share the same box?

Peter Zeitzev

This is interesting question which I thought would be good to write about. There are obviously benefits and drawbacks for each method.

PlanetMySQL Blog: Making a Corresponding Test Case for your Patch

Jay Pipes

Recently, we've seen a number of excellent contributions to the MySQL server. Below are some helpful hints about getting a proper build environment up and running on your machine and running the test suite properly.

Get More Details on MySQL Camp »

Events

Web Seminar (French): Web Session Management with MySQL

Thursday, October 26th, 10:00am CET (Germany)

Many web applications require knowledge of a user's interactions and current state on the website, as in online banking or ecommerce. This web seminar will explore how MySQL and MySQL Cluster can be used as part of a cost-effective, high-performance, open-source solution for database-centric session management.

Zend/PHP Conference & Expo (Oct. 30-Nov. 2)

Monday, October 30th - Thursday November 2nd

Zend is hosting it's second annual Zend / PHP Conference & Expo on Oct 30 - Nov 2 in San Jose at the Doubletree Hotel. The program has expanded from last year and includes a full day of tutorials on Monday. The conference features in-depth technical sessions on topics such as high volume scaling techniques for PHP and MySQL, performance tuning, web services as well as sessions on new capabilities in forthcoming PHP 6.

Learn More »

Web Seminar: MySQL Enterprise: Discover the New MySQL Network Monitoring and Advisory Services!

Tuesday, October 31st 2006, 10:00 am PDT; 1:00 pm EDT; 17:00 GMT

Now is your chance to discover MySQL Enterprise, including the new MySQL Network Monitoring and Advisory services. It's like having a "Virtual DBA Assistant" at your side. In this web seminar you'll learn and see how MySQL Enterprise will help you to:

Manage multiple servers with new monitoring and advisory services.
Gain in-depth visibility into the health of all your MySQL servers
Discover tuning opportunities you could not find yourself
Build custom monitoring and advisory rules tailored to the needs of your environment
Identify and fix problems before they become costly outages
Enforce MySQL recommended best practices

Web Seminar: Cost-Effective Database Scale-Out Using MySQL

Wednesday, November 1, 2006, 10:00am PDT, 1:00pm EDT

Scaling out (or Horizontal Scaling) means distributing the computing and data workload among multiple commodity servers by load balancing, with the ability to add or subtract servers to increase or decrease capacity. By distributing the workload, processing resources are spread among multiple low-cost servers, which improves both performance and the availability of the overall service at a dramatically lower cost.

PHP Conference in Frankfurt, Germany

November 5-8, 2006

Join MySQL at the International PHP Conference 2006. MySQL is hosting a number of sessions including:

MySQL Falcon Storage Engine
An Introduction to MySQL Cluster: Architecture and Use
MySQL 5.1 in Depth
Confession Time: Deadly Sins using MySQL and PHP
Making use of MySQL Cluster with PHP

Learn More »

Web Seminar: MySQL 5.0 for OEMs and ISVs

Tuesday, November 7th, 2006, 10:00am PDT, 1:00pm EDT

In this Webinar, which is designed specifically for OEMs and ISVs, you will learn:

How to choose the right pluggable storage engine
Mix and match storage engines in one application.
Meet regulatory data archiving requirements
Access data across servers using the Federated Storage Engine
Use triggers, stored procedures and views.
How to increase speed and manageability by embedding the MySQL Server Library into your application.

Web Seminar: LAMP - Security for the Web 2.0

Thursday, November 9th, 10:00am PDT, 1:00pm EDT

If you are developing Web 2.0 and AJAX applications and want to now about the old and new security risks, this presentation is for you. In this presentation, Johann-Peter Hartmann, CTO, Mayflower GmbH will discuss:

The changes of security risks in web applications
Why XSS plays the leading part of AJAX exploits
The origination and types of javascript malware
Ways to secure your LAMP stack applications for the Web 2.0

MySQL Camp

Nov 10-12 2006, Google Headquarters, Mountain View, California

Get together with other hard-core MySQL developers. There are quite a few proposed session topics, on anything from advice on getting VC funding, to high performance database schemas for folksonomy applications. The Session Schedule is taking shape now.

Web Seminar: High Availability Clustering: Designing Scalable, Fault-tolerant Databases with MySQL Cluster

Thursday, November 16th, 2006, November 16, 2006

MySQL Cluster combines the world's most popular open source database with a fault tolerant database clustering architecture so you can deliver mission-critical database applications with 99.999% availability. MySQL Cluster has a flexible distributed architecture which gives you complete control over the level of performance, reliability and scalability you need to match your application requirements. You'll learn all about it at the MySQL Web Seminar.

Training, Consulting, and Certification

MySQL Packaged Consulting: MySQL Performance Tuning & Optimization

(Starting at 3 Days)

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)

Training: MySQL Advanced Stored Procedures (2 Days)

Köln, San Francisco

Do want to add to your knowledge of Stored Procedures, Functions and Triggers to improve the quality of your applications?
Do you want to be able to fully utilize the programming capabilities of the MySQL Stored Procedures?
Do you want to be able to optimize and debug your Stored Procedures?

Then Advanced Stored Procedures in MySQL is the class for you!

Training: MySQL 5.0 for Database Administrators (5 Days)

Montreal, London, Milan, Paris, Vancouver

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?

Partners

Tableau Software Professional Edition for MySQL

Tableau Professional Edition for MySQL is a visual analysis and reporting solution. It is typically used by people looking for a world-class query & analysis solution. Tableau makes analyzing powerful databases as easy as using Microsoft Excel. With no programming or training, users can visually explore MySQL databases from any angle, dynamically analyze and pivot information, create on-the-fly calculations, and bring the full power of visual analysis to their companies.

For more information, visit »

Trial version »

Zmanda Recovery Manager for MySQL

Zmanda has introduced Zmanda Recovery Manager (ZRM) for MySQL. This is the first comprehensive solution with enterprise class backup and recovery features that has been designed to meet the specific needs of MySQL Database Administrators.